| 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'; |