MySQL 8 Cookbook

Key Features

• Store, retrieve and manipulate you data, and design efficient database solutions with latest MySQL 8 features
• Practical recipes on efficient MySQL administration, with tips on effective user management, security, database monitoring, performance tuning, troubleshooting and more.
• Practical tips and tricks to give you the edge over others while designing, developing and administering your database.

Book Description

MySQL is one of the most popular and widely used relational databases in the world today. With the recently released MySQL 8, it promises to be better and more efficient than ever, giving you high performance, more features and additional support as document store.

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, shows you the newest improvements in MySQL 8 and gives you experience in managing high-transaction, real-time and huge data sets. 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 practical recipes on efficient MySQL administration, with tips on effective user management, security, database monitoring, performance tuning, troubleshooting and more. Right from quick solutions to the common problems you might encounter while working with MySQL, the book contains practical tips and tricks to give you the edge over others while designing, developing and administering your database.

What you will learn

• Install and configure your MySQL 8 instance without any hassle
• Connect and query MySQL using drivers of different languages
• Perform backup tasks and set up replication for your database
• Recover data from mysqldump and mydumper
• Manage and monitor your MySQL instance and implement efficient performance tuning tasks
• Troubleshoot your MySQL database for any issues and ensure high performance