Design cost-efficient database solutions, scale enterprise operations and reduce overhead business costs with MySQL.

Key Features

• Explore the new and advanced features of MySQL 8.0
• Use advanced techniques to optimise MySQL performance
• Create MySQL-based applications for your enterprise with the help of practical examples

Book Description

Advanced MySQL 8 teaches you to enhance your existing database infrastructure.  Also build various tools to improve your enterprise applications and overall website performance. The book starts with the new and exciting MySQL 8.0 features. Equally important how to utilise them for maximum efficiency. As you make your way through the chapters, you will learn to optimise MySQL performance.  Not to mention using indexes and advanced data query techniques for large queries. You will also discover MySQL Server 8.0 settings. Moreover 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.  Furthermore which will enable you to create elastic, highly available, and fault-tolerant replication topologies. Then you will also explore backup and recovery techniques for your databases. Also 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.  Not to mention increase the security of their multi-user environments.

What you will learn

• Explore new and exciting features of MySQL 8.0
• Analyse and optimise 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.

Table of Contents

1. Introduction and Topics
2. MySQL 8 – New Features
3. Indexing Your Data For High Performance
4. Advanced Data Techniques For Large Queries
5. MySQL data dictionary in MySQL 8.0
6. MySQL Server Settings
7. Group Replication in MySQL 8.0
8. InnoDB Cluster in MySQL 8.0
9. Monitoring Your Large Distributed Databases
10. Authentication and Security Management with MySQL 8.0
11. Advanced MySQL 8.0 Performance Tips & Techniques

Product description