89482

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 linę 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 rangę 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".