1include/master-slave.inc 2Warnings: 3Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. 4Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 5[connection master] 6include/stop_slave.inc 7include/start_slave.inc 8SET GLOBAL event_scheduler = ON; 9CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, f varchar(8)) ENGINE=ENGINE_TYPE; 10INSERT INTO t1 (f) VALUES ('a'),('a'),('a'),('a'),('a'); 11INSERT INTO t1 SELECT i+5, f FROM t1; 12INSERT INTO t1 SELECT i+10, f FROM t1; 13CREATE EVENT ev1 ON SCHEDULE EVERY 1 SECOND 14DO INSERT INTO t1 VALUES (SLEEP(5),CONCAT('ev1_',CONNECTION_ID())); 15CREATE EVENT ev2 ON SCHEDULE EVERY 1 SECOND 16DO INSERT INTO t1 VALUES (SLEEP(5),CONCAT('ev2_',CONNECTION_ID())); 17STOP SLAVE IO_THREAD; 18UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 20; 19UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 19; 20UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 18; 21UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 17; 22UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 16; 23UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 15; 24UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 14; 25UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 13; 26UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 12; 27UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 11; 28UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 10; 29UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 9; 30UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 8; 31UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 7; 32UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 6; 33UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 5; 34UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 4; 35UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 3; 36UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 2; 37UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = 1; 38SET GLOBAL event_scheduler = OFF; 39include/stop_slave.inc 40UNINSTALL PLUGIN rpl_semi_sync_slave; 41UNINSTALL PLUGIN rpl_semi_sync_master; 42include/start_slave.inc 43DROP EVENT ev1; 44DROP EVENT ev2; 45DROP TABLE t1; 46include/sync_slave_sql_with_master.inc 47include/rpl_end.inc 48