Advanced MySQL 8

▶Book 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

▶Key Features
⦁ Explore the new and advanced features of MySQL 8.0
⦁ Use advanced techniques to optimize MySQL performance
⦁ Create MySQL-based applications for your enterprise with the help of practical examples

▶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.

▶What this book covers
⦁ 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 antipattern use cases for MySQL and different ways to enhance and optimize the performance of a database, followed by solutions to commonly asked questions.