Debian Codegraph @

mysql-test/suite/galera_3nodes/t/galera_var_node_address.test

raw
1 #
2 # Test wsrep_node_address . The galera_var_node_address.cnf contains various settings for
3 # wsrep_node_address, so in this test we simply confirm that the cluster has started up correctly.
4 #
5
6 --source include/galera_cluster.inc
7 --source include/have_innodb.inc
8
9 --connection node_1
10 --let $wait_condition = SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
11 --source include/wait_condition.inc
12
13 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
14
15 CREATE TABLE t1 (f1 INTEGER) ENGINE=INNODB;
16
17 --connection node_2
18 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
19 --source include/wait_condition.inc
20
21 INSERT INTO t1 VALUES (1);
22 SELECT COUNT(*) AS EXPECT_1 FROM t1;
23
24 --connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3
25 --connection node_3
26 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
27 --source include/wait_condition.inc
28 SELECT COUNT(*) AS EXPECT_1 FROM t1;
29
30 --connection node_1
31 SELECT COUNT(*) AS EXPECT_1 FROM t1;
32 DROP TABLE t1;