Description



Advanced MySQL 8 teaches you to enhance your existing database infrastructure and build various tools to improve your enterprise applications and overall website performance. The book starts with the new and exciting MySQL 8.0 features and how to utilize them for maximum efficiency. As you make your way through the chapters, you will learn to optimize MySQL performance using indexes and advanced data query techniques for large queries. You will also discover MySQL Server 8.0 settings and work with the MySQL data dictionary to boost the performance of your database. In the concluding chapters, you will cover MySQL 8.0 Group Replication, which will enable you to create elastic, highly available, and fault-tolerant replication topologies. You will also explore backup and recovery techniques for your databases and understand important tips and tricks to help your critical data reach its full potential.



By the end of this book, you’ll have learned about new MySQL 8.0 security features that allow a database administrator (DBA) to simplify user management and increase the security of their multi-user environments.

What you will learn



   Explore new and exciting features of MySQL 8.0

   Analyze and optimize large MySQL queries

   Understand MySQL Server 8.0 settings

   Master the deployment of Group Replication and use it in an InnoDB cluster

   Monitor large distributed databases

   Discover different types of backups and recovery methods for your databases

   Explore tips to help your critical data reach its full potential



Who this book is for



Advanced MySQL 8 is for database administrators, data architects, and database developers who want to dive deeper into building advanced database applications in the MySQL environment.



Book Details



   Language: English

   Published: 2019

   ISBN: 1788834445

   Format: True PDF