This section describes the server options and system variables
that you can use on replication master servers. You can specify
the options either on the
command line or in an
option file. You can specify
system variable values using
SET.
On the master and each slave, you must use the
server-id option to establish a unique
replication ID. For each server, you should pick a unique positive
integer in the range from 1 to 232
– 1, and each ID must be different from every other ID in
use by any other replication master or slave. Example:
server-id=3.
For options used on the master for controlling binary logging, see Section 14.8.4, “Binary Log Options and Variables”.


User Comments
Add your own comment.