Master MySQL for designing cost-efficient database solutions, scaling enterprise operations, reducing overhead business cost and improving customer experience.Key FeaturesTake advantage of new and advanced features of MySQL 8.0, including transactional data dictionary, resource management, group replication and index optimizer. Solve performance issues and optimize MySQL performance using advanced index techniques, optimized queries and advanced server settings.Quick and simple practical example for developing MySQL based application for your enterprise.Book DescriptionThe aim of the book is to teach how you can enhance your existing database infrastructure and build various tools to improve your enterprise applications and overall website performance. The book will start all the new exciting features of MySQL 8.0 and how to utilize them for maximum efficiency. Next you will learn how to optimize MySQL performance by using indexes and the advanced data query techniques for large queries. Moving on, you will learn how to get optimal MySQL Server 8.0 Settings and how to work with MySQL data dictionary. You will cover MySQL 8.0 Group Replication which will enable you to create elastic, highly-available, fault-tolerant replication topologies.Towards the end of the book you’ll learn about the cover the new MySQL 8.0 security features that allows a DBA to simplify user management and increases the security of their multi-user environments. You will also learn backup and recovery techniques for your databases and important tips and tricks to keep your critical data reach to its full potential.What you will learnGet to know the new exciting features of MySQL 8.0Optimize MySQL performance by using indexes and further learn how to how to *Analyze and optimize large MySQL queriesGet optimal MySQL Server 8.0 SettingsMaster the deployment of Group Replication and how to use it in an InnoDB Cluster.Monitor your Large Distributed DatabasesAuthenticate and Secure your database using access privileges system, encrypted connections, security plugins and understand how they affect the security of your MySQL server and related applications.Discover different type of backups, recovery methods for your databasesExplore tips to keep your critical data reach to its full potentialWho This Book Is ForThis book would highly appeal to database administrators, data architects and all those who wants to advance in developing database applications in MySQL environment.About the AuthorEric Vanier is one of the few DBAs worldwide specializing in “MySQL Performance” and an expert with large architectures like Air Miles, Cogeco, McGill University, Bombardier Aerospace and many more. As an ace DBA and instructor since 17 years, he has a proven track record in performance and troubleshooting on dozens of high profile MySQL systems including complex Cluster environments.
Author: Eric Vanier