include/master-slave.inc
Warnings:
Note	####	Sending passwords in plain text without SSL/TLS is extremely insecure.
Note	####	Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[connection master]
call mtr.add_suppression("Slave SQL: .*Could not execute Write_rows event on table d1.t1; Duplicate entry '13' for key 'a'");
call mtr.add_suppression("Slave SQL: ... The slave coordinator and worker threads are stopped, possibly leaving data in inconsistent state.");
call mtr.add_suppression("Error writing relay log configuration.");
include/stop_slave.inc
SET @save.slave_parallel_workers=@@global.slave_parallel_workers;
SET @@global.slave_parallel_workers=2;
include/start_slave.inc
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE TABLE d1.t1 (a int unique) ENGINE=INNODB;
CREATE TABLE d2.t1 (a int unique) ENGINE=INNODB;
INSERT INTO d1.t1 VALUES (1);
FLUSH LOGS;
include/sync_slave_sql_with_master.inc
include/stop_slave.inc
CHANGE MASTER TO MASTER_DELAY=5;
include/start_slave.inc
INSERT INTO d1.t1 VALUES (3);
INSERT INTO d1.t1 VALUES (5);
FLUSH LOGS;
include/stop_slave.inc
CHANGE MASTER TO RELAY_LOG_FILE=FILE,  RELAY_LOG_POS= POS;
include/start_slave.inc
include/stop_slave.inc
CHANGE MASTER TO RELAY_LOG_FILE=FILE,  RELAY_LOG_POS= POS, MASTER_DELAY=0;
include/start_slave.inc
BEGIN;
INSERT INTO d1.t1 VALUES (13);
INSERT INTO d1.t1 VALUES (6);
INSERT INTO d2.t1 VALUES (7);
INSERT INTO d1.t1 VALUES (13);
INSERT INTO d2.t1 VALUES (8);
INSERT INTO d2.t1 VALUES (9);
COMMIT;
include/wait_for_slave_sql_error.inc [errno=1062]
include/stop_slave_io.inc
CHANGE MASTER TO RELAY_LOG_FILE=FILE,  RELAY_LOG_POS= POS;
ERROR HY000: CHANGE MASTER cannot be executed when the slave was stopped with an error or killed in MTS mode. Consider using RESET SLAVE or START SLAVE UNTIL.
SET @@global.slave_parallel_workers= @save.slave_parallel_workers;
include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery --skip-slave-start]
SELECT @@global.relay_log_recovery as 'must be ON';
must be ON
1
call mtr.add_suppression("--relay-log-recovery cannot be executed when the slave was stopped with an error or killed in MTS mode; consider using RESET SLAVE or restart the server with --relay-log-recovery = 0");
call mtr.add_suppression("Failed to initialize the master info structure");
call mtr.add_suppression("It is not possible to change the type of the relay log repository because there are workers repositories with possible execution gaps. The value of --relay_log_info_repository is altered to one of the found Worker repositories");
include/rpl_restart_server.inc [server_number=2 parameters: --skip-slave-start]
SELECT @@global.relay_log_recovery as 'must be OFF';
must be OFF
0
DELETE FROM d1.t1 WHERE a = 13;
include/start_slave.inc
DROP DATABASE d1;
DROP DATABASE d2;
include/sync_slave_sql_with_master.inc
[connection slave]
include/stop_slave.inc
SET @save.slave_parallel_workers=@@global.slave_parallel_workers;
SET @@global.slave_parallel_workers=2;
SET @save.relay_log_info_repository=@@global.relay_log_info_repository;
SET @@global.relay_log_info_repository='TABLE';
include/start_slave.inc
[connection master]
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE TABLE d1.t1 (a int unique) ENGINE=INNODB;
CREATE TABLE d2.t1 (a int unique) ENGINE=INNODB;
include/sync_slave_sql_with_master.inc
BEGIN;
INSERT INTO d1.t1 VALUES (13);
[connection master]
INSERT INTO d1.t1 VALUES (6);
INSERT INTO d2.t1 VALUES (7);
INSERT INTO d1.t1 VALUES (13);
INSERT INTO d2.t1 VALUES (8);
INSERT INTO d2.t1 VALUES (9);
[connection slave1]
[connection slave]
COMMIT;
include/wait_for_slave_sql_error.inc [errno=1062]
include/stop_slave_io.inc
[connection master]
FLUSH LOGS;
[connection slave]
CHANGE MASTER TO MASTER_HOST= '127.0.0.1', MASTER_PORT= MASTER_PORT, MASTER_USER= 'root',MASTER_LOG_FILE = 'FILE', MASTER_LOG_POS = POS ;
ERROR HY000: CHANGE MASTER cannot be executed when the slave was stopped with an error or killed in MTS mode. Consider using RESET SLAVE or START SLAVE UNTIL.
reset slave;
CHANGE MASTER TO MASTER_HOST= '127.0.0.1', MASTER_PORT= MASTER_PORT, MASTER_USER= 'root',MASTER_LOG_FILE = 'FILE', MASTER_LOG_POS = POS ;
Warnings:
Note	####	Sending passwords in plain text without SSL/TLS is extremely insecure.
Note	####	Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
SET @@global.slave_parallel_workers= @save.slave_parallel_workers;
SET @@global.relay_log_info_repository= @save.relay_log_info_repository;
include/start_slave.inc
[connection master]
DROP DATABASE d1;
DROP DATABASE d2;
include/rpl_end.inc
