Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_stop_on_rotate.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6
7 ############################################################
8 # 1. Add some data to be applied in the replica
9 CREATE TABLE t1 (a INT PRIMARY KEY);
10 INSERT INTO t1 VALUES(1);
11 include/sync_slave_sql_with_master.inc
12
13 ############################################################
14 # 2. Add a debug point so the replica stops at the first sent rotate
15 # Stop the replica IO thread so the auto positioning protocol runs
16 include/stop_slave_io.inc
17 # Adding debug point 'block_on_master_pos_4_rotate' to @@GLOBAL.debug
18 # Adding debug point 'block_on_thread_stop_after_awake' to @@GLOBAL.debug
19 include/start_slave_io.inc
20
21 ############################################################
22 # 3. Stop the replica ensuring it stops on the first replica
23 # sent rotate that has 4 as the position
24 SET DEBUG_SYNC= "now WAIT_FOR signal.reach_pos_4_rotate_event";
25 STOP REPLICA;
26 [connection server_2]
27 SET DEBUG_SYNC= "now WAIT_FOR signal.stop_point_after_awake";
28 SET DEBUG_SYNC= "now SIGNAL signal.rotate_event_continue";
29 [connection slave]
30
31 ############################################################
32 # 4. Start the replica again and check all is good
33 # Removing debug point 'block_on_master_pos_4_rotate' from @@GLOBAL.debug
34 # Removing debug point 'block_on_thread_stop_after_awake' from @@GLOBAL.debug
35 SET DEBUG_SYNC= "RESET";
36 include/start_slave.inc
37 [connection master]
38 INSERT INTO t1 VALUES(2);
39 DROP TABLE t1;
40 include/sync_slave_sql_with_master.inc
41 include/rpl_end.inc