Debian Codegraph @

mysql-test/suite/group_replication/t/gr_single_primary_async_after_gr_primary.test

raw
1 #
2 # Test case to verify that asynchronous replication channel can be started
3 # on primary, while group replication is running on single-primary mode.
4 #
5 # Test:
6 #
7 # 1. Start GR on server1 & 2.
8 # 2. Add some data to server1 & 3.
9 # 3. Create new channel ch3_1: server1(slave), server3(master).
10 # 4. Verify channel ch3_1 IO and SQL THREADS are ON
11 # 5. Verify data is replicated to server1 & 2
12 # 6. Clean up.
13 #
14
15 --source include/have_group_replication_plugin.inc
16 --let $rpl_skip_group_replication_start= 1
17 --let $rpl_server_count= 3
18 --let $rpl_group_replication_single_primary_mode=1
19 --source include/group_replication.inc
20
21 --echo
22 --echo # 1. Start GR on server1 & 2
23
24 # Boostrap start GR on server1 (Primary)
25 --let $rpl_connection_name= server1
26 --source include/rpl_connection.inc
27 --source include/start_and_bootstrap_group_replication.inc
28
29 # Start GR on server2 (Secondary)
30 --let $rpl_connection_name= server2
31 --source include/rpl_connection.inc
32 --source include/start_group_replication.inc
33
34 --echo
35 --echo # 2. Add some data to server1 & 3
36
37 # server1: create table t1 and add data
38 --let $rpl_connection_name= server1
39 --source include/rpl_connection.inc
40 CREATE TABLE test.t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
41 INSERT INTO test.t1 VALUES (1);
42
43 # server3: create table t2 and add data
44 --let $rpl_connection_name= server3
45 --source include/rpl_connection.inc
46 CREATE TABLE test.t2 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
47 INSERT INTO test.t2 VALUES (1);
48
49
50 --echo
51 --echo # 3. Create and start new channel ch3_1: server1(slave), server3(master)
52 --let $rpl_connection_name= server1
53 --source include/rpl_connection.inc
54 --replace_result $SERVER_MYPORT_3 SERVER_3_PORT
55 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='localhost', SOURCE_USER='root', SOURCE_PORT=$SERVER_MYPORT_3 for channel 'ch3_1'
56
57 --let $rpl_channel_name='ch3_1'
58 --source include/start_slave.inc
59 --let $rpl_channel_name=
60
61 --echo
62 --echo # 4. Verify channel ch3_1 IO and SQL THREADS are ON
63 --let $assert_text= Verify channel ch3_1 IO_THREAD is ON
64 --let $assert_cond= "[SELECT SERVICE_STATE FROM performance_schema.replication_connection_status WHERE channel_name = \'ch3_1\', SERVICE_STATE, 1]" = "ON"
65 --source include/assert.inc
66
67 --let $assert_text= Verify channel ch3_1 SQL_THREAD is ON
68 --let $assert_cond= "[SELECT SERVICE_STATE FROM performance_schema.replication_applier_status WHERE channel_name = \'ch3_1\', SERVICE_STATE, 1]" = "ON"
69 --source include/assert.inc
70
71 --echo
72 --echo # 5. Verify data is replicated to server1 & 2
73
74 # Sync slave(server1) with master(server3)
75 --let $rpl_connection_name= server3
76 --source include/rpl_connection.inc
77 --let $rpl_channel_name='ch3_1'
78 --let $sync_slave_connection=server1
79 --source include/sync_slave_sql_with_master.inc
80 --let $rpl_channel_name=
81
82 # Wait for all servers to be in sync
83 --source include/rpl_sync.inc
84
85 --let $rpl_connection_name= server2
86 --source include/rpl_connection.inc
87
88 --let $assert_text= Verify two tables (t1 & t2) are present in test database
89 --let $assert_cond= "[SELECT count(table_name) COUNT FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = \'test\', COUNT, 1]" = "2"
90 --source include/assert.inc
91
92 --let $assert_text= Verify test.t2 is synced
93 --let $assert_cond= "[SELECT count(*) COUNT FROM test.t2, COUNT, 1]" = "1"
94 --source include/assert.inc
95
96
97 --let $rpl_connection_name= server1
98 --source include/rpl_connection.inc
99
100 --let $assert_text= Verify two tables (t1 & t2) are present in test database
101 --let $assert_cond= "[SELECT count(table_name) COUNT FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = \'test\', COUNT, 1]" = "2"
102 --source include/assert.inc
103
104 --let $assert_text= Verify test.t2 is synced
105 --let $assert_cond= "[SELECT count(*) COUNT FROM test.t2, COUNT, 1]" = "1"
106 --source include/assert.inc
107
108
109 --echo
110 --echo # 6. Clean Up
111
112 --let $rpl_connection_name= server1
113 --source include/rpl_connection.inc
114 STOP SLAVE FOR CHANNEL 'ch3_1';
115 RESET SLAVE ALL FOR CHANNEL 'ch3_1';
116
117 DROP TABLE test.t1;
118 DROP TABLE test.t2;
119
120 --let $rpl_connection_name= server3
121 --source include/rpl_connection.inc
122 DROP TABLE test.t2;
123
124 --source include/group_replication_end.inc