This is an old revision of the document!
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:
- Disaster Recovery
- Performance increase by offloading the selects
- Backup enhancement by performing backups on the standby
- Others
There are couple ways how we can set up a master/slave replication