Chapter 7. MySQL 8 Best Practices
In the previous chapter, you learned how to use replication to build highly available solutions. It covered a lot of interesting aspects such as failovers, group replications, clustering, and so on. In this chapter, we will go through the best practices of MySQL 8, which is a much-awaited version that promises to address many of the shortfalls of the prior versions and has exciting new features. MySQL 8 promises not to be just a standalone database, but also will play a significant role in various areas including big data solutions.
Topics that we will be covering in this chapters are mentioned below:
- MySQL benchmarks and configurations
- Best practices for MySQL queries
- Best practices for the Memcached configuration
- Best practices for replication
Due to prominent optimizations and changes, MySQL 8 advanced its version directly from the release of MySQL 5.7. MySQL 8 will not have the limitation of files that was previously restricting the number of databases that...