Debian Codegraph @

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

raw
1 #
2 # Test the --wsrep-new-cluster option by putting it in the galera_wsrep_new_cluster-master.opt file
3 #
4 # In MTR, running two nodes, the result is two separate clusters of size 1
5 #
6
7 --source include/galera_cluster.inc
8
9 # Save original auto_increment_offset values.
10 --let $node_1=node_1
11 --let $node_2=node_2
12 --source include/auto_increment_offset_save.inc
13
14 --connection node_2
15 --echo Shutting down server ...
16 --source include/shutdown_mysqld.inc
17
18 --connection node_1
19
20 --let $wait_condition = SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
21 --source include/wait_condition.inc
22
23 --connection node_2
24
25 #
26 # Delete grastate.dat with safe_to_bootstrap: 0
27 #
28 --echo Cleaning grastate.dat file ...
29 --remove_file $MYSQLTEST_VARDIR/mysqld.2/data/grastate.dat
30
31 --echo Starting server ...
32 --let $restart_noprint=2
33 --let $start_mysqld_params=--wsrep-new-cluster
34 --source include/start_mysqld.inc
35 --source include/wait_until_ready.inc
36
37 --connection node_1
38
39 --let $wait_condition = SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
40 --source include/wait_condition.inc
41 --let $wait_condition = SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
42 --source include/wait_condition.inc
43 --let $wait_condition = SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
44 --source include/wait_condition.inc
45
46 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
47 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_connected';
48 SELECT (VARIABLE_VALUE = 0 OR VARIABLE_VALUE = 1 ) FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_index';
49 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
50 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state';
51 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
52
53 --connection node_2
54
55 --let $wait_condition = SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
56 --source include/wait_condition.inc
57 --let $wait_condition = SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
58 --source include/wait_condition.inc
59 --let $wait_condition = SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
60 --source include/wait_condition.inc
61
62 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
63 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_connected';
64 SELECT (VARIABLE_VALUE = 0 OR VARIABLE_VALUE = 1 ) FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_index';
65 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
66 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state';
67 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
68
69 --echo Shutting down server ...
70 --source include/shutdown_mysqld.inc
71
72 #
73 # Force SST
74 #
75 --echo Cleaning var directory ...
76 --remove_file $MYSQLTEST_VARDIR/mysqld.2/data/grastate.dat
77 --remove_files_wildcard $MYSQLTEST_VARDIR/mysqld.2/data/mtr
78 --remove_files_wildcard $MYSQLTEST_VARDIR/mysqld.2/data/performance_schema
79 --remove_files_wildcard $MYSQLTEST_VARDIR/mysqld.2/data/test
80 --remove_files_wildcard $MYSQLTEST_VARDIR/mysqld.2/data/mysql
81 --remove_files_wildcard $MYSQLTEST_VARDIR/mysqld.2/data
82
83 --echo Starting server ...
84 --let $start_mysqld_params=
85 --source include/start_mysqld.inc
86 --source include/wait_until_ready.inc
87
88 --connection node_1
89
90 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
91 --source include/wait_condition.inc
92
93 --source include/auto_increment_offset_restore.inc