Setting the Replication Slave Configuration-opracowanie

Setting the Replication Slave Configuration
On a replication slave, you must establish a unique server ID. If this has not already been done, this
part of slave setup requires a server restart.
If the slave server ID is not already set, or the current value conflicts with the value that you have
chosen for the master server, you should shut down your slave server and edit the configuration to
specify a unique server ID. For example:
[mysqld]
server-id=2
After making the changes, restart the server.
If you are setting up multiple slaves, each one must have a unique server-id [1991] value that
differs from that of the master and from each of the other slaves. Think of server-id [1991]
values as something similar to IP addresses: These IDs uniquely identify each server instance in the
community of replication partners.
... zobacz całą notatkę