AUTHOR: Karthik Appigatla
ISBN-10: 9781788395809; ISBN-13: 978-1788395809
Design and administer enterprise-grade MySQL 8 solutions
* Store, retrieve, and manipulate your data using the latest MySQL 8 features
* Practical recipes on effective administration in MySQL, with a focus on security, performance tuning, troubleshooting, and more
* Contains tips, tricks, and best practices for designing, developing, and administering your MySQL 8 database solution without any hassle
MySQL is one of the most popular and widely used relational databases in the World today. The recently released MySQL 8 version promises to be better and more efficient than ever before.
This book contains everything you need to know to be the go-to person in your organization when it comes to MySQL. Starting with a quick installation and configuration of your MySQL instance, the book quickly jumps into the querying aspects of MySQL. It shows you the newest improvements in MySQL 8 and gives you hands-on experience in managing high-transaction and real-time datasets. If you've already worked with MySQL before and are looking to migrate your application to MySQL 8, this book will also show you how to do that. The book also contains recipes on efficient MySQL administration, with tips on effective user management, data recovery, security, database monitoring, performance tuning, troubleshooting, and more.
With quick solutions to common and not-so-common problems you might encounter while working with MySQL 8, the book contains practical tips and tricks to give you the edge over others in designing, developing, and administering your database effectively.
What you will learn
* Install and configure your MySQL 8 instance without any hassle
* Get to grips with new features of MySQL 8 like CTE, Window functions and many more
* Perform backup tasks, recover data and set up various replication topologies for your database
* Maximize performance by using new features of MySQL 8 like descending indexes, controlling query optimizer and resource groups
* Learn how to use general table space to suit the SaaS or multi-tenant applications
* Analyze slow queries using performance schema, sys schema and third party tools
* Manage and monitor your MySQL instance and implement efficient performance-tuning tasks
Who This Book Is For
If you are a MySQL developer or administrator looking for quick, handy solutions to solve the most common and not-so-common problems in MySQL, this book is for you. MySQL DBAs looking to get up-to-speed with the latest MySQL 8 development and administration features will also find this book very useful. Prior knowledge of Linux and RDBMS is desirable.
About the Author
Karthik Appigatla is a highly reputed database architect and is very famous for performance tuning. He has been consulted by many companies all over the world for designing, performance tuning, building database infrastructure, and training. In his decade of experience, he has worked for companies such as Yahoo, Pythian, and Percona. Currently, he is working for LinkedIn, where he has innovated a new way of analyzing queries. He gave a talk about this at SRECon, Dublin in 2017.
Programming books display here are property of respective owners. All information about the book published in this website is in good faith and for general information purpose only.
Please support author by buying hardcopy to the nearest book store in your place or order books in publisher websites.
Most companies provide employee's loans for SSS and Pagibig member, Bank loan, Company salary loan or cash advance etc. Pinoy Web Application create a flexible loan data entry module that can connect to payroll process to deduct automatic to their salary for every pay period, until the loan is zero balance. read more »
Users who allowed to maintain table lookup like branch, project, banks, designation, department, special holidays, regular holiday, loan code, loan type, allowance etc. Those table are used on dropdown selection for data entry form in personal details, job information and allowances. read more »
Online Overtime module allows employee to enter the overtime worked on particular days and request authorization must be applied on their respective login account available for every employee's dashboard. read more »
Online leave management using Pinoy Web Application is the simple way to file a leave of absence with pay. By automating leave approval process can eliminate unexcused absences without filling of leave. Employee self-service dashboard account have an easy interface to apply and view leave request status. The online staff leave planner allows administrators to set up employee information and leave types and policies easily. read more »
Pinoy web application payroll register is a data process that all lists of total information for every pay period upon approved by payroll approver before saving to the payroll register like total gross pay, total overtime, total allowances, total of each type of deduction, and total net pay. The computation for each individual employee like gross pay, net pay, withholding tax, overtime pay and other deduction amount seen in payslip report are stored in database table payroll register. read more »