Debian Codegraph @

mysql-test/suite/galera/t/galera_replica_no_gtid.test

raw
1 #
2 # Test Galera as a replica to a MySQL async replication
3 #
4 # The galera/galera_2node_slave.cnf describes the setup of the nodes
5 #
6 --source include/force_restart.inc
7 --source include/galera_cluster.inc
8 --source include/have_innodb.inc
9 --source include/have_sequence.inc
10
11 # As node #3 is not a Galera node, and galera_cluster.inc does not open connetion to it
12 # we open the node_3 connection here
13 --connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3
14
15 create user repl@'%' identified by 'repl';
16 grant all on *.* to repl@'%';
17 flush privileges;
18 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
19
20 --let $node_1 = node_1
21 --let $node_2 = node_2
22 --source include/auto_increment_offset_save.inc
23
24 --connection node_2
25 --disable_query_log
26 --eval CHANGE MASTER TO master_host='127.0.0.1', master_user='repl', master_password='repl', master_ssl_verify_server_cert=0, master_port=$NODE_MYPORT_3, master_use_gtid=slave_pos;
27 --enable_query_log
28 START SLAVE;
29
30 --connection node_3
31
32 CREATE TABLE t1 (id bigint primary key, msg varchar(100)) engine=innodb;
33 --disable_query_log
34 INSERT INTO t1 SELECT seq, 'test' from seq_1_to_10000;
35 --enable_query_log
36 SELECT COUNT(*) AS EXPECT_10000 FROM t1;
37
38 --connection node_2
39 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
40 --source include/wait_condition.inc
41
42 --let $wait_condition = SELECT COUNT(*) = 10000 FROM t1;
43 --source include/wait_condition.inc
44
45 #
46 # Node_2 is slave so mysql.gtid_slave_pos table is also replicated
47 #
48 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
49 SELECT COUNT(*) AS EXPECT_10000 FROM t1;
50
51 --connection node_1
52 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
53 --source include/wait_condition.inc
54
55 --let $wait_condition = SELECT COUNT(*) = 10000 FROM t1;
56 --source include/wait_condition.inc
57
58 #
59 # mysql-gtid_slave_pos table should not be replicated by Galera
60 #
61 SELECT COUNT(*) AS EXPECT_0 FROM mysql.gtid_slave_pos;
62 SELECT COUNT(*) AS EXPECT_10000 FROM t1;
63
64 --connection node_2
65 --echo # Verify that graceful shutdown succeeds.
66 --source include/shutdown_mysqld.inc
67 --echo # Force SST
68 --remove_file $MYSQLTEST_VARDIR/mysqld.2/data/grastate.dat
69
70 --connection node_1
71 --echo # Waiting until node_2 is not part of cluster anymore
72 --let $wait_condition = SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
73 --source include/wait_condition.inc
74 --let $wait_condition = SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
75 --source include/wait_condition.inc
76
77 --connection node_2
78 --echo # Start node_2 again
79 --source include/start_mysqld.inc
80
81 --echo ยค Wait until node_2 is back on cluster
82 --let $wait_condition = SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
83 --source include/wait_condition.inc
84 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
85 --source include/wait_condition.inc
86 --let $wait_condition = SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
87 --source include/wait_condition.inc
88
89 --connection node_2
90 call mtr.add_suppression("Slave: Operation CREATE USER failed for ");
91 SELECT COUNT(*) AS EXPECT_0 FROM mysql.gtid_slave_pos;
92 SELECT COUNT(*) AS EXPECT_10000 FROM t1;
93
94 --connection node_1
95 SELECT COUNT(*) AS EXPECT_0 FROM mysql.gtid_slave_pos;
96 SELECT COUNT(*) AS EXPECT_10000 FROM t1;
97
98 --connection node_3
99 SELECT COUNT(*) AS EXPECT_10000 FROM t1;
100
101 #
102 # Cleanup
103 #
104 --connection node_2
105 STOP SLAVE;
106 RESET SLAVE ALL;
107
108 --connection node_3
109 RESET MASTER;
110 drop table t1;
111
112 --connection node_2
113 DROP TABLE t1;
114
115 --connection node_1
116 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
117 --source include/wait_condition.inc
118
119 --connection node_1
120 --disconnect node_3
121
122 --source include/auto_increment_offset_restore.inc
123 --source include/galera_end.inc
124 --echo # End of test