Sams Teach Yourself MySQL in 21 Days, Second Edition

Setting Up a Master-Slave Replication System

Now that you understand what needs to be achieved, it's time to get hands-on and talk you through the process of setting up a replicated system of one master and one slave.

You will need two servers on which you have installed MySQL. Ideally this should be version 4.0.2 or later, and if possible the same version on each machine.

In essence the following instructions will show you how to

• Set up the master.

• Set up the slave.

• Start replicating.

Master Setup Principles

Setting up the master involves five steps, each of which is straightforward. Here's an overview:

1.	Create a user account on the master; this is the user account with which the slave will connect.
2.	Shut down mysqld on the master.
3.	Make ...