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]
SET @save_slave_parallel_workers= @@slave_parallel_workers;
SET @save_default_storage_engine=@@global.default_storage_engine;
SET @@global.default_storage_engine='innodb';
SET GLOBAL slave_parallel_workers= 4;
call mtr.add_suppression("Request to stop slave SQL Thread received while applying a group that has non-transactional changes");
include/stop_slave.inc
include/start_slave.inc
SET @save_default_storage_engine=@@global.default_storage_engine;
SET @@global.default_storage_engine='innodb';
SET @@session.default_storage_engine='innodb';
call mtr.add_suppression('.*Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.*');
CREATE DATABASE test_10;
CREATE TABLE test_10.t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(20), c BLOB, d INT NOT NULL DEFAULT 0);
CREATE DATABASE test_9;
CREATE TABLE test_9.t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(20), c BLOB, d INT NOT NULL DEFAULT 0);
CREATE DATABASE test_8;
CREATE TABLE test_8.t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(20), c BLOB, d INT NOT NULL DEFAULT 0);
CREATE DATABASE test_7;
CREATE TABLE test_7.t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(20), c BLOB, d INT NOT NULL DEFAULT 0);
CREATE DATABASE test_6;
CREATE TABLE test_6.t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(20), c BLOB, d INT NOT NULL DEFAULT 0);
CREATE DATABASE test_5;
CREATE TABLE test_5.t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(20), c BLOB, d INT NOT NULL DEFAULT 0);
CREATE DATABASE test_4;
CREATE TABLE test_4.t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(20), c BLOB, d INT NOT NULL DEFAULT 0);
CREATE DATABASE test_3;
CREATE TABLE test_3.t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(20), c BLOB, d INT NOT NULL DEFAULT 0);
CREATE DATABASE test_2;
CREATE TABLE test_2.t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(20), c BLOB, d INT NOT NULL DEFAULT 0);
CREATE DATABASE test_1;
CREATE TABLE test_1.t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(20), c BLOB, d INT NOT NULL DEFAULT 0);
include/start_slave.inc
DROP DATABASE test_10;
DROP DATABASE test_9;
DROP DATABASE test_8;
DROP DATABASE test_7;
DROP DATABASE test_6;
DROP DATABASE test_5;
DROP DATABASE test_4;
DROP DATABASE test_3;
DROP DATABASE test_2;
DROP DATABASE test_1;
SET @@global.default_storage_engine= @save_default_storage_engine;
SET @@global.default_storage_engine= @save_default_storage_engine;
SET GLOBAL slave_parallel_workers= @save_slave_parallel_workers;
include/rpl_end.inc
