1include/master-slave.inc 2[connection master] 3connection master; 4RESET MASTER; 5SET @@GLOBAL.rpl_semi_sync_master_enabled = 1; 6connection slave; 7include/stop_slave.inc 8SET @@GLOBAL. rpl_semi_sync_slave_enabled = 1; 9include/start_slave.inc 10connection master; 11CREATE TABLE t1 (a INT); 12INSERT INTO t1 SET a = 1; 13include/save_master_gtid.inc 14FLUSH LOGS; 15INSERT INTO t1 SET a = 2; 16connection slave; 17connection slave; 18include/stop_slave_sql.inc 19connection master; 20INSERT INTO t1 SET a = 3; 21include/sync_slave_io_with_master.inc 22connection slave; 23include/stop_slave_io.inc 24connection master; 25RESET MASTER; 26SET @@global.gtid_binlog_state = '0-1-2'; 27connection slave; 28CHANGE MASTER TO MASTER_USE_GTID = slave_pos; 29SET @@global.gtid_slave_pos = '0-1-2'; 30include/start_slave.inc 31connection master; 32INSERT INTO t1 SET a = 4; 33connection master; 34DROP TABLE t1; 35SET @@GLOBAL. rpl_semi_sync_master_enabled = 0; 36connection slave; 37include/stop_slave.inc 38SET @@GLOBAL. rpl_semi_sync_slave_enabled = 0; 39include/start_slave.inc 40include/rpl_end.inc 41