Debian Codegraph @

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

raw
1 #
2 # Test Galera as a master to a MySQL slave
3 #
4 # The galera/galera_2node_master.cnf describes the setup of the nodes
5 #
6
7 --source include/have_innodb.inc
8 --source include/galera_cluster.inc
9
10 --connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3
11 --disable_query_log
12 --eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_USER='root', MASTER_SSL_VERIFY_SERVER_CERT=0, MASTER_PORT=$NODE_MYPORT_1;
13 --enable_query_log
14 START SLAVE;
15
16 --connection node_1
17 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
18 INSERT INTO t1 VALUES(1);
19
20 --echo # Disable binary logging for current session
21 SET SQL_LOG_BIN=OFF;
22 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
23 INSERT INTO t2 VALUES(1);
24 INSERT INTO t1 VALUES(2);
25 CREATE TABLE test.t3 AS SELECT * from t1;
26
27 SET SQL_LOG_BIN=ON;
28 INSERT INTO t1 VALUES(3);
29 CREATE TABLE test.t4 AS SELECT * from t1;
30
31 --connection node_2
32 SELECT * FROM t1;
33 SELECT * FROM t2;
34 SELECT * FROM t3;
35 SELECT * FROM t4;
36
37 --connection node_3
38 --let $wait_condition = SELECT COUNT(*) = 2 FROM t1;
39 --source include/wait_condition.inc
40
41 --let $wait_condition = SELECT COUNT(*) = 3 FROM t4;
42 --source include/wait_condition.inc
43
44 SHOW TABLES;
45
46 SELECT * FROM t1;
47 SELECT * FROM t4;
48
49 --echo # Cleanup
50 --connection node_1
51 DROP TABLE t1, t4;
52 SET SQL_LOG_BIN=OFF;
53 DROP TABLE t2, t3;
54
55 --let binlog_pos=`SELECT @@gtid_binlog_pos;`
56
57 --connection node_3
58 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
59 --source include/wait_condition.inc
60 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't4';
61 --source include/wait_condition.inc
62
63 --disable_query_log
64 --eval SELECT STRCMP(@@gtid_binlog_pos, "$binlog_pos") = 0 AS BINLOG_POSITIONS_MATCH;
65 --enable_query_log
66
67 STOP SLAVE;
68 RESET SLAVE ALL;
69
70 CALL mtr.add_suppression('You need to use --log-bin to make --binlog-format work');
71
72 --connection node_1
73 set global wsrep_on=OFF;
74 RESET MASTER;
75 set global wsrep_on=ON;