Using MySQL’s Built-In Replication To Maximize Availability
MySQL’s internal replication is built on a master-slave relationship between two or more servers, with one acting as the master, and any number acting as slaves. I’ll walk through configuring two servers as a master slave pair, describing the process as we move through it.
step by step instructions on setting up master-slave replication on MySQL