Replication and Binary Logging Options and Variables • log_bin : Whether binary log is enabled. • log_bin_basename : Path and base name for binary log files. • log_bin_use_v1_row_events : Whether server is using version 1 binary log row events. • log_slave_updates : Whether replica should log updates performed by its replication SQL thread to its own binary log. • master_verify_checksum : Cause source to examine checksums when reading from binary log. • max-binlog-dump-events : Option used by mysql-test for debugging and testing of replication. • max_binlog_cache_size : Can be used to restrict total size used to cache multi-statement transaction. • max_binlog_size : Binary log is rotated automatically when size exceeds this value. • max_binlog_stmt_cache_size : Can be used to restrict total size used to cache all nontransactional statements during transaction. • slave-sql-verify-checksum : Cause replica to examine checksums when reading from relay log. • slave_sql_verify_checksum : Cause replica to examine checksums when reading from relay log. • sporadic-binlog-dump-fail : Option used by mysql-test for debugging and testing of replication. • sync_binlog : Synchronously flush binary log to disk after every #th event. • --show-slave-auth-info 3496 Display replication user names and passwords in the output of  SHOW REPLICAS | SHOW SLAVE HOSTS  on the source for replicas started with the  --report-user  and  --report-password  options. The following list describes startup options for controlling replication source servers. Replication-related system variables are discussed later in this section. For options used on the source for controlling binary logging, see Section 17.1.6.4, “Binary Logging Options and Variables” . On the source and each replica, you must set the  server_id  system variable to establish a unique replication ID. For each server, you should pick a unique positive integer in the range from 1 to 2$^{32}$  −  1, and each ID must be different from every other ID in use by any other source or replica in the replication topology. Example:  server-id=3 . This section describes the server options and system variables that you can use on replication source servers. You can specify the options either on the command line or in an option file. You can specify system variable values using  SET . For a listing of all command-line options, system and status variables used with  mysqld , see Section 5.1.4, “Server Option, System Variable, and Status Variable Reference” . 17.1.6.2 Replication Source Options and Variables Startup Options for Replication Source Servers Command-Line Format --show-slave-auth-info[={OFF|ON}] Type Boolean Default Value OFF