Debian Codegraph @

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

raw
1 #
2 # This test performs basic checks on the contents of the wsrep_schema
3 #
4 # wsrep_members_history checks are temporarily disabled until it
5 # can be made configurable.
6 #
7
8 --source include/galera_cluster.inc
9 --source include/have_innodb.inc
10
11 --connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3
12 --connection node_1
13
14 # Save original auto_increment_offset values.
15 --let $node_1=node_1
16 --let $node_2=node_2
17 --let $node_3=node_3
18 --source ../galera/include/auto_increment_offset_save.inc
19
20 # Make the test fail if table structure has changed
21
22 SHOW CREATE TABLE mysql.wsrep_cluster;
23 SHOW CREATE TABLE mysql.wsrep_cluster_members;
24 #disabled SHOW CREATE TABLE mysql.wsrep_member_history;
25 SELECT @@sql_safe_updates;
26
27 # Checks for the wsrep_cluster table
28
29 SELECT COUNT(*) = 1 FROM mysql.wsrep_cluster;
30 SELECT cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid') FROM mysql.wsrep_cluster;
31
32 # Checks for the wsrep_cluster_members table
33
34 SELECT COUNT(*) = 3 FROM mysql.wsrep_cluster_members;
35 SELECT COUNT(*) = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size') FROM mysql.wsrep_cluster_members;
36 SELECT COUNT(*) = 1 FROM mysql.wsrep_cluster_members WHERE node_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_gcomm_uuid');
37
38 SELECT node_incoming_address LIKE '127.0.0.1:%' from mysql.wsrep_cluster_members;
39 SELECT cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid') FROM mysql.wsrep_cluster_members;
40
41 --connection node_2
42
43 SELECT COUNT(*) = 3 FROM mysql.wsrep_cluster_members;
44 SELECT COUNT(*) = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size') FROM mysql.wsrep_cluster_members;
45 SELECT COUNT(*) = 1 FROM mysql.wsrep_cluster_members WHERE node_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_gcomm_uuid');
46
47 SELECT node_incoming_address LIKE '127.0.0.1:%' from mysql.wsrep_cluster_members;
48 SELECT cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid') FROM mysql.wsrep_cluster_members;
49
50 --connection node_3
51 SELECT COUNT(*) = 3 FROM mysql.wsrep_cluster_members;
52 SELECT COUNT(*) = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size') FROM mysql.wsrep_cluster_members;
53 SELECT COUNT(*) = 1 FROM mysql.wsrep_cluster_members WHERE node_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_gcomm_uuid');
54
55 SELECT node_incoming_address LIKE '127.0.0.1:%' from mysql.wsrep_cluster_members;
56 SELECT cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid') FROM mysql.wsrep_cluster_members;
57
58 --source ../galera/include/auto_increment_offset_restore.inc