MySQL 8 Cookbook: Over 150 recipes for high-performance database querying and administration

MySQL 8 Cookbook: Over 150 recipes for high-performance database querying and administration

AUTHOR: Karthik Appigatla

PUBLISHER: Packt

PAGES: 446

ISBN-10: 9781788395809; ISBN-13: 978-1788395809

Design and administer enterprise-grade MySQL 8 solutions

Key Features
* 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

Book Description
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.

Book Category

Android Developer / Asp.Net / Asp.Net MVC / Blockchain / C# / C++ / Computer Science / Database / Game Developer / Java / JavaScript / jQuery / Linux / Maven / MS Sql / MySQL / Networking / Oracle / PHP / Python / Spring / VB.Net / Visual Studio / Web Developer

HRMS & Payroll Web Application

Timekeeping System and Timesheet Processing

Paper timesheets daily time record is to track when employees start and end their work hours a day, but today's technologies used biometric finger scanner or other digital device to record daily time attendance In/Out. read more »

HRMS Employee Shift Schedule

Fixed shift schedule in every employee from Monday to Sunday is required during the processing of timesheet to get man-hour distribution report. This module designed a flexible shift because rest day work can occur in any days, just example of working in Shopping Mall that operates 7 days a week. read more »

HRMS Employee Online Account

Employee can check their available vacation leave, sick leave, pay slip or ability to work at home. Filing of overtime work, request temporary shift schedule and leave benefits is a convenient way using a paperless online form. read more »

Employee Self-Service Online Filing Form

Delegate work to your employees and get more productive right away with a smart self-service dashboard user account for every employee. Modern HR management tools can help you remove the daily routine task that the system can handle it automatically and easy. read more »

Broken Time Schedule Data Entry and Approval Form

Broken time schedule is not suitable on automating work distribution need module data entry to handle the accurate computation that system get the computed hours during the timesheet processing. The logic of computation is time difference for every time in/out entry that excess of regular 8 hours is overtime work. The approver decide if the overtime work is required to deduct 1 hour OT hour lunch break or OTND lunch break before it approve. read more »