Book Image

Advanced MySQL 8

By : Eric Vanier, Birju Shah, Tejaswi Malepati
Book Image

Advanced MySQL 8

By: Eric Vanier, Birju Shah, Tejaswi Malepati

Overview of this book

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.
Table of Contents (13 chapters)
11
Advanced MySQL Performance Tips and Techniques

Summary

At the end of the day, out of thousands of database administration tools available out there, you can never declare a single one of them to be the best. It all depends on the requirements and the budget of the company/enterprise.

If you have multiple databases and you aren't only on MySQL but other platforms as well, then Navicat is your go-to platform. The simple reason is the ease of setup and cross-database support. It's the most expensive among the three but does bring a lot of features to the table that the other two don't. Datadog is another best option for small-to-medium companies. You can customize the tool according to your preference and get the best out of it. MONyog is the only agentless database monitoring tool and the fact that you'll be able to monitor your database without installing any kind of PHP or .NET agent is exciting.

All three...