17.1.3.1. Replication and Binary Logging Option and Variable Reference

The following tables list basic information about the MySQL command-line options and system variables applicable to replication and the binary log.

Table 17.1. Replication Option/Variable Summary

NameCmd-LineOption fileSystem VarStatus VarVar ScopeDynamic
abort-slave-event-countYesYes    
Com_change_master   YesBothNo
Com_show_master_status   YesBothNo
Com_show_new_master   YesBothNo
Com_show_slave_hosts   YesBothNo
Com_show_slave_status   YesBothNo
Com_slave_start   YesBothNo
Com_slave_stop   YesBothNo
disconnect-slave-event-countYesYes    
init_slaveYesYesYes GlobalYes
log-slave-updatesYesYes  GlobalNo
- Variable: log_slave_updates  Yes GlobalNo
master-bindYesYesYes GlobalNo
master-connect-retryYesYes    
master-hostYesYes    
master-info-fileYesYes    
master-passwordYesYes    
master-portYesYes    
master-retry-countYesYes    
master-sslYesYes    
master-ssl-caYesYes    
master-ssl-capathYesYes    
master-ssl-certYesYes    
master-ssl-cipherYesYes    
master-ssl-keyYesYes    
master-userYesYes    
relay-logYesYes    
relay-log-indexYesYes  BothNo
- Variable: relay_log_index  Yes BothNo
relay-log-info-fileYesYes    
- Variable: relay_log_info_file      
relay_log_purgeYesYesYes GlobalYes
relay_log_recoveryYesYesYes GlobalYes
relay_log_space_limitYesYesYes GlobalNo
replicate-do-dbYesYes    
replicate-do-tableYesYes    
replicate-ignore-dbYesYes    
replicate-ignore-tableYesYes    
replicate-rewrite-dbYesYes    
replicate-same-server-idYesYes    
replicate-wild-do-tableYesYes    
replicate-wild-ignore-tableYesYes    
report-hostYesYes  GlobalNo
- Variable: report_host  Yes GlobalNo
report-passwordYesYes  GlobalNo
- Variable: report_password  Yes GlobalNo
report-portYesYes  GlobalNo
- Variable: report_port  Yes GlobalNo
report-userYesYes  GlobalNo
- Variable: report_user  Yes GlobalNo
rpl_recovery_rank  Yes GlobalYes
Rpl_semi_sync_master_clients   YesGlobalNo
rpl_semi_sync_master_enabled  Yes GlobalYes
Rpl_semi_sync_master_net_avg_wait_time   YesGlobalNo
Rpl_semi_sync_master_net_wait_time   YesGlobalNo
Rpl_semi_sync_master_net_waits   YesGlobalNo
Rpl_semi_sync_master_no_times   YesGlobalNo
Rpl_semi_sync_master_no_tx   YesGlobalNo
Rpl_semi_sync_master_status   YesGlobalNo
Rpl_semi_sync_master_timefunc_failures   YesGlobalNo
rpl_semi_sync_master_timeout  Yes GlobalYes
rpl_semi_sync_master_trace_level  Yes GlobalYes
Rpl_semi_sync_master_tx_avg_wait_time   YesGlobalNo
Rpl_semi_sync_master_tx_wait_time   YesGlobalNo
Rpl_semi_sync_master_tx_waits   YesGlobalNo
rpl_semi_sync_master_wait_no_slave  Yes GlobalYes
Rpl_semi_sync_master_wait_pos_backtraverse   YesGlobalNo
Rpl_semi_sync_master_wait_sessions   YesGlobalNo
Rpl_semi_sync_master_yes_tx   YesGlobalNo
rpl_semi_sync_slave_enabled  Yes GlobalYes
Rpl_semi_sync_slave_status   YesGlobalNo
rpl_semi_sync_slave_trace_level  Yes GlobalYes
Rpl_status   YesGlobalNo
show-slave-auth-infoYesYes    
skip-slave-startYesYes    
slave_compressed_protocolYesYesYes GlobalYes
slave_exec_mode  Yes GlobalYes
Slave_heartbeat_period   YesGlobalNo
slave-load-tmpdirYesYes  GlobalNo
- Variable: slave_load_tmpdir  Yes GlobalNo
slave-net-timeoutYesYes  GlobalYes
- Variable: slave_net_timeout  Yes GlobalYes
Slave_open_temp_tables   YesGlobalNo
Slave_received_heartbeats   YesGlobalNo
Slave_retried_transactions   YesGlobalNo
Slave_running   YesGlobalNo
slave-skip-errorsYesYes  GlobalNo
- Variable: slave_skip_errors  Yes GlobalNo
slave_transaction_retriesYesYesYes GlobalYes
slave_type_conversionsYesYesYes GlobalNo
sql_slave_skip_counter  Yes GlobalYes
sync_master_infoYesYesYes GlobalYes
sync_relay_logYesYesYes GlobalYes
sync_relay_log_infoYesYesYes GlobalYes

Section 17.1.3.2, “Replication Master Options and Variables”, provides more detailed information about options and variables relating to replication master servers. For more information about options and variables relating to replication slaves, see Section 17.1.3.3, “Replication Slave Options and Variables”.

Table 17.2. Binary Logging Option/Variable Summary

NameCmd-LineOption fileSystem VarStatus VarVar ScopeDynamic
Binlog_cache_disk_use   YesGlobalNo
binlog_cache_sizeYesYesYes GlobalYes
Binlog_cache_use   YesGlobalNo
binlog_direct_non_transactional_updatesYesYesYes BothYes
binlog-do-dbYesYes    
binlog-formatYesYes  BothYes
- Variable: binlog_format  Yes BothYes
binlog-ignore-dbYesYes    
binlog-row-event-max-sizeYesYes    
Binlog_stmt_cache_disk_use   YesGlobalNo
binlog_stmt_cache_sizeYesYesYes GlobalYes
Binlog_stmt_cache_use   YesGlobalNo
Com_show_binlog_events   YesBothNo
Com_show_binlogs   YesBothNo
max_binlog_cache_sizeYesYesYes GlobalYes
max-binlog-dump-eventsYesYes    
max_binlog_sizeYesYesYes GlobalYes
max_binlog_stmt_cache_sizeYesYesYes GlobalYes
sporadic-binlog-dump-failYesYes    

Section 17.1.3.4, “Binary Log Options and Variables”, provides more detailed information about options and variables relating to binary logging. For additional general information about the binary log, see Section 5.2.4, “The Binary Log”.

For a table showing all command-line options, system and status variables used with mysqld, see Section 5.1.1, “Server Option and Variable Reference”.

Copyright © 2010-2020 Platon Technologies, s.r.o.           Home | Man pages | tLDP | Documents | Utilities | About
Design by styleshout