Replication Master Options and Variables-opracowanie

Replication Master Options and Variables
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 [1991] 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 16.1.4.4, “Binary Log Options
and Variables”.
... zobacz całą notatkę