mirror of
https://github.com/MariaDB/server.git
synced 2025-11-03 20:36:16 +01:00
27 lines
1,011 B
PHP
27 lines
1,011 B
PHP
#
|
|
# Set all the variables required for the SST to be performed via mysqldump
|
|
#
|
|
|
|
--echo Setting SST method to mysqldump ...
|
|
|
|
call mtr.add_suppression("WSREP: wsrep_sst_method is set to 'mysqldump' yet mysqld bind_address is set to '127\\.0\\.0\\.1'");
|
|
call mtr.add_suppression("Failed to load slave replication state from table mysql\\.gtid_slave_pos");
|
|
|
|
--connection node_1
|
|
# We need a user with a password to perform SST, otherwise we hit LP #1378253
|
|
CREATE USER 'sst';
|
|
GRANT ALL PRIVILEGES ON *.* TO 'sst';
|
|
|
|
--let $wsrep_sst_auth_orig = `SELECT @@wsrep_sst_auth`
|
|
SET GLOBAL wsrep_sst_auth = 'sst:';
|
|
|
|
--connection node_2
|
|
--source include/wait_until_connected_again.inc
|
|
--let $wsrep_sst_method_orig = `SELECT @@wsrep_sst_method`
|
|
--let $wsrep_sst_receive_address_orig = `SELECT @@wsrep_sst_receive_address`
|
|
|
|
--disable_query_log
|
|
# Set wsrep_sst_receive_address to the SQL port
|
|
--eval SET GLOBAL wsrep_sst_receive_address = '127.0.0.1:$NODE_MYPORT_2';
|
|
--enable_query_log
|
|
SET GLOBAL wsrep_sst_method = 'mysqldump';
|