MySQL Replication

The replication is perfect feature of MySQL for many reasons. Unlike other databases, in MySQL, the responsibility for the replication process is slave's job. Meaning that the primary database, doesn't “care” about if the replication is going or if the slave(standby) is alive at all. Furthermore, the Slave server can be a community edition (free) while the Primary is Enterprise (paid) edition. Replication provides the follow bonuses:

1. Disaster Recovery
2. Performance increase by offloading the selects
3. Backup enhancement by performing backups on the standby
4. Others

There are couple ways how we can set up a master/slave replication

• System replication
• Database & Table Replication
• Using Percona Backup (Automated)
• InnoDB Cluster