The only option you must configure on the slave is to set the unique server ID. If this option is not already set, or the current value conflicts with the value that you have chosen for the master server, then you should shutdown your slave server, and edit the configuration to specify the server id. For example:
[mysqld] server-id=2
If you are setting up multiple slaves, each one must have a
unique server-id value that differs from that
of the master and from each of the other slaves. Think of
server-id values as something similar to IP
addresses: These IDs uniquely identify each server instance in
the community of replication partners.
If you do not specify a server-id value, it
is set to 1 if you have not defined
master-host; otherwise it is set to 2. Note
that in the case of server-id omission, a
master refuses connections from all slaves, and a slave refuses
to connect to a master. Thus, omitting
server-id is good only for backup with a
binary log.
You do not have to enable binary logging on the slave for replication to be enabled. However, if you enable binary logging on the slave then you can use the binary log for data backups and crash recovery on the slave, and also use the slave as part of a more complex replication topology.

User Comments
Add your own comment.