Debian Codegraph @

mysql-test/suite/sys_vars/t/wsrep_sst_method_basic.test

raw
1 --source include/have_wsrep.inc
2
3 --echo #
4 --echo # wsrep_sst_method
5 --echo #
6
7 --echo # save the initial value
8 SET @wsrep_sst_method_global_saved = @@global.wsrep_sst_method;
9
10 --echo # default
11 SELECT @@global.wsrep_sst_method;
12
13 --echo
14 --echo # scope
15 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
16 SELECT @@session.wsrep_sst_method;
17 SET @@global.wsrep_sst_method=rsync;
18 SELECT @@global.wsrep_sst_method;
19
20 --echo
21 --echo # valid values
22 SET @@global.wsrep_sst_method=rsync;
23 SELECT @@global.wsrep_sst_method;
24 SET @@global.wsrep_sst_method=mysqldump;
25 SELECT @@global.wsrep_sst_method;
26 # The xtrabackup and xtrabackup-v2 methods are obsolete,
27 # but we can still select them (they will be automatically
28 # replaced to mariabackup):
29 SET @@global.wsrep_sst_method=xtrabackup;
30 SELECT @@global.wsrep_sst_method;
31 SET @@global.wsrep_sst_method="xtrabackup-v2";
32 SELECT @@global.wsrep_sst_method;
33 SET @@global.wsrep_sst_method="mariabackup";
34 SELECT @@global.wsrep_sst_method;
35 SET @@global.wsrep_sst_method=default;
36 SELECT @@global.wsrep_sst_method;
37
38 # Its a valid name for an SST method
39 SET @@global.wsrep_sst_method='junk';
40 SELECT @@global.wsrep_sst_method;
41
42 --echo
43 --echo # invalid values
44 --error ER_WRONG_VALUE_FOR_VAR
45 SET @@global.wsrep_sst_method=NULL;
46 SELECT @@global.wsrep_sst_method;
47
48 --echo
49 --echo # restore the initial value
50 SET @@global.wsrep_sst_method = @wsrep_sst_method_global_saved;
51
52 --echo # End of test