The easiest and most straightforward method for setting up replication is to use new master and slave servers.
You can also use this method if you are setting up new servers but have an existing dump of the databases from a different server that you want to load into your replication configuration. By loading the data into a new master, the data will be automatically replicated to the slaves.
To set up replication between a new master and slave:
Configure the MySQL master with the necessary configuration properties. See Section 188.8.131.52, “Setting the Replication Master Configuration”.
Start up the MySQL master.
Set up a user. See Section 184.108.40.206, “Creating a User for Replication”.
Obtain the master status information. See Section 220.127.116.11, “Obtaining the Replication Master Binary Log Coordinates”. Continue reading “MySQL Replication by MySQL” »