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

System replication

Database & Table Replication

Using Percona Backup (Automated)