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

MONyog

MONyog is the MySQL-based database monitoring tool and is the product of a company called Webyog. Webyog was acquired on April 18, 2018 by the tech giant IDERA, Inc. Webyog is a leader in the category of database tools and the key component is to manage and monitor MySQL servers. It serves over 35,000 companies, with up to 2.5 million users worldwide. Webyog also has another quite successful product called SQLyog. It's the company's flagship product, being used for query profiling and migration. Synchronization and backups are also something SQLyog is primarily being used for.

MONyog is the company's database monitoring tool, designed to offer real-time insights. MONyog may have some room for improvement but shows some great promise. The design has some really different and innovative architectural decisions that help it to stand apart from other MySQL database...