Debian Codegraph @

mysql-test/suite/galera/include/galera_sst_set_mysqldump.inc

raw
1 #
2 # Set all the variables required for the SST to be performed via mysqldump
3 #
4
5 --echo Setting SST method to mysqldump ...
6
7 call mtr.add_suppression("WSREP: wsrep_sst_method is set to 'mysqldump' yet mysqld bind_address is set to '127\\.0\\.0\\.1'");
8 call mtr.add_suppression("Failed to load slave replication state from table mysql\\.gtid_slave_pos");
9
10 --connection node_1
11 # We need a user with a password to perform SST, otherwise we hit LP #1378253
12 CREATE USER 'sst';
13 GRANT ALL PRIVILEGES ON *.* TO 'sst';
14
15 --let $wsrep_sst_auth_orig = `SELECT @@wsrep_sst_auth`
16 SET GLOBAL wsrep_sst_auth = 'sst:';
17
18 --connection node_2
19 --source include/wait_until_connected_again.inc
20 --let $wsrep_sst_method_orig = `SELECT @@wsrep_sst_method`
21 --let $wsrep_sst_receive_address_orig = `SELECT @@wsrep_sst_receive_address`
22
23 --disable_query_log
24 # Set wsrep_sst_receive_address to the SQL port
25 --eval SET GLOBAL wsrep_sst_receive_address = '127.0.0.1:$NODE_MYPORT_2';
26 --enable_query_log
27 SET GLOBAL wsrep_sst_method = 'mysqldump';