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] 6SET @save_global_debug=@@GLOBAL.DEBUG; 7SET @@GLOBAL.DEBUG= '+d,dbug.calculate_sbm_after_previous_gtid_log_event'; 8SET @saved_slave_transaction_retries=@@global.slave_transaction_retries; 9SET @@global.slave_transaction_retries=0; 10include/start_slave_io.inc 11include/stop_slave_io.inc 12include/start_slave_io.inc 13CREATE TABLE t1(i INT); 14INSERT INTO t1 VALUES (20); 15INSERT INTO t1 VALUES (19); 16INSERT INTO t1 VALUES (18); 17INSERT INTO t1 VALUES (17); 18INSERT INTO t1 VALUES (16); 19INSERT INTO t1 VALUES (15); 20INSERT INTO t1 VALUES (14); 21INSERT INTO t1 VALUES (13); 22INSERT INTO t1 VALUES (12); 23INSERT INTO t1 VALUES (11); 24INSERT INTO t1 VALUES (10); 25INSERT INTO t1 VALUES (9); 26INSERT INTO t1 VALUES (8); 27INSERT INTO t1 VALUES (7); 28INSERT INTO t1 VALUES (6); 29INSERT INTO t1 VALUES (5); 30INSERT INTO t1 VALUES (4); 31INSERT INTO t1 VALUES (3); 32INSERT INTO t1 VALUES (2); 33DROP TABLE t1; 34FLUSH LOGS; 35FLUSH LOGS; 36include/sync_slave_io_with_master.inc 37include/start_slave_sql.inc 38SET DEBUG_SYNC="now wait_for signal.reached"; 39include/assert.inc [Seconds Behind Master should be less than 180 seconds.] 40SET DEBUG_SYNC="now signal signal.done_sbm_calculation"; 41SET DEBUG_SYNC="now wait_for signal.reached"; 42include/assert.inc [Seconds Behind Master should be less than 180 seconds.] 43SET DEBUG_SYNC="now signal signal.done_sbm_calculation"; 44SET DEBUG_SYNC="now wait_for signal.reached"; 45include/assert.inc [Seconds Behind Master should be less than 180 seconds.] 46SET DEBUG_SYNC="now signal signal.done_sbm_calculation"; 47SET DEBUG_SYNC="now wait_for signal.reached"; 48include/assert.inc [Seconds Behind Master should be less than 180 seconds.] 49SET DEBUG_SYNC="now signal signal.done_sbm_calculation"; 50SET DEBUG_SYNC="now wait_for signal.reached"; 51include/assert.inc [Seconds Behind Master should be less than 180 seconds.] 52SET DEBUG_SYNC="now signal signal.done_sbm_calculation"; 53SET DEBUG_SYNC="now wait_for signal.reached"; 54include/assert.inc [Seconds Behind Master should be less than 180 seconds.] 55SET DEBUG_SYNC="now signal signal.done_sbm_calculation"; 56SET DEBUG_SYNC="now wait_for signal.reached"; 57include/assert.inc [Seconds Behind Master should be less than 180 seconds.] 58SET DEBUG_SYNC="now signal signal.done_sbm_calculation"; 59SET @@GLOBAL.DEBUG=@save_global_debug; 60SET @@global.slave_transaction_retries=@saved_slave_transaction_retries; 61include/rpl_end.inc 62