Introduction to MySQL Replication & High Availability

Why Replication?

MySQL replication enables copying of data from one server (master) to another (slave). This improves read performance, allows backups without downtime, and provides high availability.

HA Concepts

• Failover mechanisms
• Load balancing
• Geographical distribution

Common tools: MySQL Replication, Group Replication, MySQL InnoDB Cluster