Debian Codegraph @

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

raw
1 --let galera_connection_address=::1
2 --source include/galera_cluster.inc
3 --source include/check_ipv6.inc
4 --source include/force_restart.inc
5
6 # Confirm that initial handshake happened over ipv6
7
8 SELECT VARIABLE_VALUE LIKE '%[::1]%' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_incoming_addresses';
9 SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
10
11 # Force IST
12
13 --connection node_2
14 SET GLOBAL wsrep_provider_options='gmcast.isolate=1';
15
16 --connection node_1
17 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
18 --source include/wait_condition.inc
19
20 CREATE TABLE t1 (f1 INTEGER NOT NULL PRIMARY KEY) ENGINE=InnoDB;
21 INSERT INTO t1 VALUES (1);
22
23 --connection node_2
24 SET GLOBAL wsrep_provider_options='gmcast.isolate=0';
25
26 --let $wait_condition = SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
27 --source include/wait_condition.inc
28
29 --let $wait_condition = SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
30 --source include/wait_condition.inc
31
32 SELECT COUNT(*) AS EXPECT_1 FROM t1;
33
34 DROP TABLE t1;