84 lines
2.6 KiB
Text
84 lines
2.6 KiB
Text
|
|
# Not GTIDs because it sets slave_sql_skip_counter
|
|
# When log-bin, skip-log-bin and binlog-format options are specified, mask the warning.
|
|
--disable_query_log
|
|
call mtr.add_suppression("\\[Warning\\] \\[[^]]*\\] \\[[^]]*\\] You need to use --log-bin to make --binlog-format work.");
|
|
--enable_query_log
|
|
#
|
|
# Checks how replication commands behave when replication if OFF
|
|
# due to server-id = 0.
|
|
#
|
|
|
|
#
|
|
# Commands associated with the REPLICA.
|
|
#
|
|
SHOW REPLICA STATUS;
|
|
--error ER_REPLICA_CONFIGURATION
|
|
RESET REPLICA;
|
|
--error ER_REPLICA_CONFIGURATION
|
|
SHOW RELAYLOG EVENTS;
|
|
--error ER_REPLICA_CONFIGURATION
|
|
STOP REPLICA;
|
|
--error ER_REPLICA_CONFIGURATION
|
|
START REPLICA;
|
|
SELECT SOURCE_POS_WAIT('non-existent', 0);
|
|
--error ER_REPLICA_CONFIGURATION
|
|
CHANGE REPLICATION SOURCE TO SOURCE_CONNECT_RETRY = 1, SOURCE_HEARTBEAT_PERIOD = 1.01;
|
|
--error 2
|
|
--exec $MYSQL_DUMP --compact --source-data=2 test
|
|
FLUSH LOGS;
|
|
FLUSH RELAY LOGS;
|
|
|
|
# Commands associated with replication filters
|
|
--error ER_REPLICA_CONFIGURATION
|
|
CHANGE REPLICATION FILTER REPLICATE_DO_DB=(db1);
|
|
--error ER_REPLICA_CONFIGURATION
|
|
CHANGE REPLICATION FILTER REPLICATE_IGNORE_DB=(db1);
|
|
--error ER_REPLICA_CONFIGURATION
|
|
CHANGE REPLICATION FILTER REPLICATE_DO_TABLE=(db1.t1);
|
|
--error ER_REPLICA_CONFIGURATION
|
|
CHANGE REPLICATION FILTER REPLICATE_IGNORE_TABLE=(db1.t1);
|
|
--error ER_REPLICA_CONFIGURATION
|
|
CHANGE REPLICATION FILTER REPLICATE_WILD_DO_TABLE=('db1.t%');
|
|
--error ER_REPLICA_CONFIGURATION
|
|
CHANGE REPLICATION FILTER REPLICATE_WILD_IGNORE_TABLE=('db1.t%');
|
|
--error ER_REPLICA_CONFIGURATION
|
|
CHANGE REPLICATION FILTER REPLICATE_REWRITE_DB=((db1,db2));
|
|
|
|
#
|
|
# Configuration options associated with the REPLICA.
|
|
#
|
|
--let $saved= `SELECT @@GLOBAL.max_relay_log_size`
|
|
SET @@GLOBAL.max_relay_log_size= 536870912;
|
|
--eval SET @@GLOBAL.max_relay_log_size= $saved
|
|
--let $saved= `SELECT @@GLOBAL.replica_net_timeout`
|
|
SET @@GLOBAL.replica_net_timeout= 10;
|
|
--eval SET @@GLOBAL.replica_net_timeout= $saved
|
|
--let $saved= `SELECT @@GLOBAL.sql_replica_skip_counter`
|
|
SET @@GLOBAL.sql_replica_skip_counter= 10;
|
|
--eval SET @@GLOBAL.sql_replica_skip_counter= $saved
|
|
--let $saved= `SELECT @@SESSION.sql_log_bin`
|
|
SET @@SESSION.sql_log_bin= 0;
|
|
--eval SET @@SESSION.sql_log_bin= $saved
|
|
|
|
#
|
|
# Commands associated with the SOURCE.
|
|
#
|
|
--error ER_NO_BINARY_LOGGING
|
|
SHOW BINARY LOGS;
|
|
SHOW BINARY LOG STATUS;
|
|
SHOW REPLICAS;
|
|
RESET BINARY LOGS AND GTIDS;
|
|
SHOW BINLOG EVENTS;
|
|
--error 2
|
|
--exec $MYSQL_DUMP --compact --source-data=2 test
|
|
FLUSH LOGS;
|
|
FLUSH BINARY LOGS;
|
|
|
|
|
|
#
|
|
# Configuration options associated with the SOURCE.
|
|
#
|
|
--let $saved= `SELECT @@GLOBAL.max_binlog_size`
|
|
SET @@GLOBAL.max_binlog_size= 536870912;
|
|
--eval SET @@GLOBAL.max_binlog_size= $saved
|