Shah Birju Shah & Vanier Eric Vanier 
Advanced MySQL 8 [EPUB ebook] 
Discover the full potential of MySQL and ensure high performance of your database

Design cost-efficient database solutions, scale enterprise operations and reduce overhead business costs with My SQLKey Features Explore the new and advanced features of My SQL 8.0Use advanced techniques to optimize My SQL performance Create My SQL-based applications for your enterprise with the help of practical examples Book Description Advanced My SQL 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 My SQL 8.0 features and how to utilize them for maximum efficiency. As you make your way through the chapters, you will learn to optimize My SQL performance using indexes and advanced data query techniques for large queries. You will also discover My SQL Server 8.0 settings and work with the My SQL data dictionary to boost the performance of your database. In the concluding chapters, you will cover My SQL 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 My SQL 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 My SQL 8.0Analyze and optimize large My SQL queries Understand My SQL Server 8.0 settings Master the deployment of Group Replication and use it in an Inno DB 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 My SQL 8 is for database administrators, data architects, and database developers who want to dive deeper into building advanced database applications in the My SQL environment.