The simple mtr test to repeat it:
*.test: ======================= --source include/have_binlog_format_row.inc --source include/have_gtid.inc
--echo *** Set up master (server_1) <-> master (server_2) replication *** --let $rpl_topology= 1->2->1 --source include/rpl_init.inc --echo
--connection server_2 --let $s2b=`select * from sys.memory_global_total` --connection server_1 --let $s1b=`select * from sys.memory_global_total`
--disable_query_log CREATE TABLE t1(a INT); --let $i=3000 while($i) { --eval INSERT INTO t1 VALUES ($i) --dec $i } DROP TABLE t1; --enable_query_log
--source include/rpl_sync.inc --connection server_2 --let $s2a=`select * from sys.memory_global_total` --connection server_1 --let $s1a=`select * from sys.memory_global_total` =================================
*.cnf: ================================= !include ../my.cnf
[mysqld.1] sync_relay_log_info=1 enforce-gtid-consistency=ON gtid-mode=ON master-info-repository=TABLE relay-log-info-repository=TABLE log-slave-updates
[mysqld.2] sync_relay_log_info=1 enforce-gtid-consistency=ON gtid-mode=ON master-info-repository=TABLE relay-log-info-repository=TABLE log-slave-updates
--echo "server_1: $s1b $s1a" --echo "server_2: $s2b $s2a"
# Cleanup --source include/rpl_end.inc ==================================
can be placed in "mysql-test/suite/rpl/t" .
The simple mtr test to repeat it:
*.test: ======= ======= == have_binlog_ format_ row.inc have_gtid. inc
=======
--source include/
--source include/
--echo *** Set up master (server_1) <-> master (server_2) replication *** rpl_init. inc
--let $rpl_topology= 1->2->1
--source include/
--echo
--connection server_2 global_ total` global_ total`
--let $s2b=`select * from sys.memory_
--connection server_1
--let $s1b=`select * from sys.memory_
--disable_query_log
CREATE TABLE t1(a INT);
--let $i=3000
while($i)
{
--eval INSERT INTO t1 VALUES ($i)
--dec $i
}
DROP TABLE t1;
--enable_query_log
--source include/ rpl_sync. inc global_ total` global_ total` ======= ======= ======= =====
--connection server_2
--let $s2a=`select * from sys.memory_
--connection server_1
--let $s1a=`select * from sys.memory_
=======
*.cnf: ======= ======= ======= =====
=======
!include ../my.cnf
[mysqld.1] log_info= 1 gtid-consistenc y=ON info-repository =TABLE info-repository =TABLE
sync_relay_
enforce-
gtid-mode=ON
master-
relay-log-
log-slave-updates
[mysqld.2] log_info= 1 gtid-consistenc y=ON info-repository =TABLE info-repository =TABLE
sync_relay_
enforce-
gtid-mode=ON
master-
relay-log-
log-slave-updates
--echo "server_1: $s1b $s1a"
--echo "server_2: $s2b $s2a"
# Cleanup ======= ======= ======= ======
--source include/rpl_end.inc
=======
can be placed in "mysql- test/suite/ rpl/t" .