Chapter 1, Introduction, walks through the changes that took place in MySQL 8, compared to the previous versions. We also study what makes MySQL 8 a next-generation database, and also cover its architectural design.
Chapter 2, MySQL 8 – New Features, not only covers all the new, exciting features of MySQL 8.0, but also reviews the deprecated and removed features as well.
Chapter 3, Indexing Your Data for High Performance, explains how to optimize MySQL performance by using indexes and Query Execution plans with examples. Optimization involves a good understanding of MySQL Optimizer, index strategies, and a solid knowledge of how indexes and queries work together.
Chapter 4, Advanced Data Techniques for Large Queries, explains how to analyze and optimize large MySQL queries and covers various tips and techniques. We will take a look at the concept of partitioning your data and deep dive into it.
Chapter 5, MySQL Data Dictionary in MySQL 8.0, explains how to get optimal MySQL Server 8.0 settings and how to work with MySQL's data dictionary, and also covers the data dictionary's limitations.
Chapter 6, MySQL Server Settings, explains how to get optimal MySQL Server 8.0 settings. We will also work on two case studies, which will focus on scenarios when MySQL uses more than 100% of a CPU and when MySQL swaps on disk.
Chapter 7, Group Replication in MySQL 8.0, focuses on an important topic: high availability. With this feature, we will be able to create a very powerful, reliable, and highly available replication infrastructure.
Chapter 8, InnoDB Cluster in MySQL 8.0, explains what InnoDB cluster is and its requirements. We will learn how to create one and manage it. We shall study the limitations of InnoDB and learn about its storage engines.
Chapter 9, Monitoring Your Large Distributed Databases, explores and compares the top three monitoring tools for large distributed databases, which are MONYOG, Datadog, and Navicat.
Chapter 10, Authentication and Security Management with MySQL 8.0, goes through the differences between dynamic and static security privileges, along with an overview of the grant table. We will see also how to troubleshoot a connection problem and share some tips and techniques.
Chapter 11, Advanced MySQL Performance Tips and Techniques, covers pattern and anti-pattern use cases for MySQL and different ways to enhance and optimize the performance of a database, followed by solutions to commonly asked questions.