Advanced MySQL 8

Summary

In this chapter, we concentrated on the different storage engines available in MySQL and also looked at why InnoDB was chosen to achieve high availability. We also covered MySQL Shell and MySQL Router, and their roles in achieving high availability. We also checked out AdminAPI and how to configure an InnoDB sandbox cluster, as well as a production environment. We also went through how to manage clusters in production and discussed various scenarios and methods relevant to cluster management.

Finally, we covered how you can migrate from a master-slave replication mechanism to an InnoDB cluster, and how to make your system highly available as well as fault tolerant. In the next chapter, we will explore the best tools for monitoring ...