In the previous chapter, we focused on tuning MySQL variables to achieve maximum performance. In this chapter, we are going to focus on an important topic—high availability. With this feature, we will be able to create a very powerful, reliable, and highly available replication infrastructure.
In this chapter, we will be looking into the following topics:
- The journey of MySQL replication mechanisms
- Types of replication method in MySQL
- Group replication
- How group replication works
- The installation, configuration, and management of group replication