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:
There are couple ways how we can set up a master/slave replication