Debian Codegraph @

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

raw
1 #
2 # Test galera dynamic protocol support. By providing `socket.dynamic=true` in
3 # galera configuration it is possible to use same port for communication over ssl or tcp.
4 #
5
6 --source include/big_test.inc
7 --source include/galera_cluster.inc
8 --source include/have_innodb.inc
9
10 --connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3
11 # Save original auto_increment_offset values.
12 --let $node_1 = node_1
13 --let $node_2 = node_2
14 --let $node_3 = node_3
15 --source ../galera/include/auto_increment_offset_save.inc
16
17 --connection node_1
18 --let $wait_condition = SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
19 --source include/wait_condition.inc
20 --let $wait_condition = SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
21 --source include/wait_condition.inc
22
23 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=InnoDB;
24 INSERT INTO t1 VALUES (1);
25
26 --connection node_2
27 --let $wait_condition = SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
28 --source include/wait_condition.inc
29 --let $wait_condition = SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
30 --source include/wait_condition.inc
31
32 --connection node_3
33 --let $wait_condition = SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
34 --source include/wait_condition.inc
35 --let $wait_condition = SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
36 --source include/wait_condition.inc
37
38 SELECT COUNT(*) = 1 FROM t1;
39
40 # Setup galera ports
41 --connection node_1
42 --source suite/galera/include/galera_base_port.inc
43 --let $NODE_GALERAPORT_1 = $_NODE_GALERAPORT
44
45 --connection node_2
46 --source suite/galera/include/galera_base_port.inc
47 --let $NODE_GALERAPORT_2 = $_NODE_GALERAPORT
48
49 --connection node_2
50 # Restart node with SSL enabled
51 --source include/shutdown_mysqld.inc
52 --let $restart_noprint = 1
53 --let $restart_parameters = --wsrep_cluster_address=gcomm://127.0.0.1:$NODE_GALERAPORT_1 --wsrep_provider_options=base_port=$NODE_GALERAPORT_2;socket.ssl=yes;socket.ssl_ca=$MYSQL_TEST_DIR/std_data/cacert.pem;socket.ssl_cert=$MYSQL_TEST_DIR/std_data/server-cert.pem;socket.ssl_key=$MYSQL_TEST_DIR/std_data/server-key.pem
54 --source include/start_mysqld.inc
55 --source include/galera_wait_ready.inc
56
57 INSERT INTO t1 VALUES (2);
58
59 --connection node_3
60 SELECT COUNT(*) = 2 FROM t1;
61
62 DROP TABLE t1;
63
64 --source ../galera/include/auto_increment_offset_restore.inc