--source include/not_group_replication_plugin.inc --echo # --echo # set up masters server_1 and server_3 with server_2 being a slave. --echo #. --let $rpl_multi_source= 1 --let $rpl_topology= 1->2,2->3,1->3 --source include/rpl_init.inc # Multisource replication is already setup. # On slave --let $rpl_connection_name= server_2 --source include/rpl_connection.inc stop slave; # On slave2 --let $rpl_connection_name= server_3 --source include/rpl_connection.inc update performance_schema.setup_objects set enabled='yes', timed='yes' where object_schema='mysql'; stop slave; start slave; select OBJECT_NAME, count_star from performance_schema.table_io_waits_summary_by_table where OBJECT_SCHEMA='mysql' and OBJECT_NAME like '%info%'; # On master --let $rpl_connection_name= server_1 --source include/rpl_connection.inc create table t1(f1 int) engine=innodb; insert into t1 values(1),(2),(3); insert into t1 values(1),(2),(3); insert into t1 values(1),(2),(3); insert into t1 values(1),(2),(3); insert into t1 values(1),(2),(3); insert into t1 values(1),(2),(3); select count(*) from t1; --sleep 5 # On slave2 --let $rpl_connection_name= server_3 --source include/rpl_connection.inc select OBJECT_NAME, count_star from performance_schema.table_io_waits_summary_by_table where OBJECT_SCHEMA='mysql' and OBJECT_NAME like '%info%'; select count(*) from t1; # On slave --let $rpl_connection_name= server_2 --source include/rpl_connection.inc start slave; --sleep 5 select count(*) from t1; --sleep 5 # On slave2 --let $rpl_connection_name= server_3 --source include/rpl_connection.inc select OBJECT_NAME, count_star from performance_schema.table_io_waits_summary_by_table where OBJECT_SCHEMA='mysql' and OBJECT_NAME like '%info%'; select count(*) from t1; --vertical_results show slave status; #--source include/master-slave.inc #connection slave; #update performance_schema.setup_objects set enabled='yes', timed='yes' where object_schema='mysql'; #stop slave; #start slave; #connection master;