Debian Codegraph @

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

raw
1 #
2 # Test node connections over SSL. The accompanying galera_ssl.cnf has a customized
3 # wsrep_provider_options setting that enables SSL.
4 #
5 # At this time, the actual operation of SSL is not visible only in the error log and not in SHOW STATUS.
6 # So this test can only check that the cluster has formed and is replicating.
7 #
8
9 --source include/galera_cluster.inc
10 --source include/have_innodb.inc
11 --source include/big_test.inc
12 --source include/have_perfschema.inc
13
14 # Verify that SSL is handled by the provider.
15 SELECT COUNT(*) `expect 0` FROM performance_schema.socket_instances WHERE EVENT_NAME LIKE '%wsrep%';
16
17 SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
18 SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
19
20 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=InnoDB;
21 INSERT INTO t1 VALUES (1);
22
23 --connection node_2
24 SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
25 SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
26
27 SELECT COUNT(*) = 1 FROM t1;
28
29 DROP TABLE t1;