1 2# 3# Replication is disabled in embedded mode. 4# 5--source include/not_embedded.inc 6# Not GTIDs because it sets slave_sql_skip_counter 7--source include/not_gtid_enabled.inc 8 9# 10# Checks how replication commands behave when replication if OFF 11# due to server-id = 0. 12# 13 14# 15# Commands associated with the SLAVE. 16# 17SHOW SLAVE STATUS; 18--error ER_SLAVE_CONFIGURATION 19RESET SLAVE; 20--error ER_SLAVE_CONFIGURATION 21SHOW RELAYLOG EVENTS; 22--error ER_SLAVE_CONFIGURATION 23STOP SLAVE; 24--error ER_SLAVE_CONFIGURATION 25START SLAVE; 26SELECT MASTER_POS_WAIT('non-existent', 0); 27--error ER_SLAVE_CONFIGURATION 28CHANGE MASTER TO MASTER_CONNECT_RETRY = 1, MASTER_HEARTBEAT_PERIOD = 1.01; 29--error 2 30--exec $MYSQL_DUMP --compact --master-data=2 test 31FLUSH LOGS; 32FLUSH RELAY LOGS; 33 34# Commands associated with replication filters 35--error ER_SLAVE_CONFIGURATION 36CHANGE REPLICATION FILTER REPLICATE_DO_DB=(db1); 37--error ER_SLAVE_CONFIGURATION 38CHANGE REPLICATION FILTER REPLICATE_IGNORE_DB=(db1); 39--error ER_SLAVE_CONFIGURATION 40CHANGE REPLICATION FILTER REPLICATE_DO_TABLE=(db1.t1); 41--error ER_SLAVE_CONFIGURATION 42CHANGE REPLICATION FILTER REPLICATE_IGNORE_TABLE=(db1.t1); 43--error ER_SLAVE_CONFIGURATION 44CHANGE REPLICATION FILTER REPLICATE_WILD_DO_TABLE=('db1.t%'); 45--error ER_SLAVE_CONFIGURATION 46CHANGE REPLICATION FILTER REPLICATE_WILD_IGNORE_TABLE=('db1.t%'); 47--error ER_SLAVE_CONFIGURATION 48CHANGE REPLICATION FILTER REPLICATE_REWRITE_DB=((db1,db2)); 49 50# 51# Configuration options associated with the SLAVE. 52# 53--let $saved= `SELECT @@GLOBAL.master_info_repository` 54SET @@GLOBAL.master_info_repository= "TABLE"; 55--disable_query_log 56--eval SET @@GLOBAL.master_info_repository= "$saved" 57--enable_query_log 58--let $saved= `SELECT @@GLOBAL.relay_log_info_repository` 59SET @@GLOBAL.relay_log_info_repository= "TABLE"; 60--disable_query_log 61--eval SET @@GLOBAL.relay_log_info_repository= "$saved" 62--enable_query_log 63--let $saved= `SELECT @@GLOBAL.max_relay_log_size` 64SET @@GLOBAL.max_relay_log_size= 536870912; 65--eval SET @@GLOBAL.max_relay_log_size= $saved 66--let $saved= `SELECT @@GLOBAL.slave_net_timeout` 67SET @@GLOBAL.slave_net_timeout= 10; 68--eval SET @@GLOBAL.slave_net_timeout= $saved 69--let $saved= `SELECT @@GLOBAL.sql_slave_skip_counter` 70SET @@GLOBAL.sql_slave_skip_counter= 10; 71--eval SET @@GLOBAL.sql_slave_skip_counter= $saved 72--let $saved= `SELECT @@SESSION.sql_log_bin` 73SET @@SESSION.sql_log_bin= 0; 74--eval SET @@SESSION.sql_log_bin= $saved 75 76# 77# Commands associated with the MASTER. 78# 79--error ER_NO_BINARY_LOGGING 80SHOW MASTER LOGS; 81SHOW MASTER STATUS; 82SHOW SLAVE HOSTS; 83RESET MASTER; 84SHOW BINLOG EVENTS; 85--error 2 86--exec $MYSQL_DUMP --compact --master-data=2 test 87FLUSH LOGS; 88FLUSH BINARY LOGS; 89 90 91# 92# Configuration options associated with the MASTER. 93# 94--let $saved= `SELECT @@GLOBAL.max_binlog_size` 95SET @@GLOBAL.max_binlog_size= 536870912; 96--eval SET @@GLOBAL.max_binlog_size= $saved 97