1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
|
#
# set up masters server_1 and server_3 with server_2 being a slave.
#.
include/rpl_init.inc [topology=1->2,3->2]
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
#### I. Initialize slaves ####
[connection server_2]
include/rpl_stop_slaves.inc
SET @save.innodb_lock_wait_timeout= @@global.innodb_lock_wait_timeout;
set @@global.innodb_lock_wait_timeout=5 + 1000;
#start slave
include/rpl_start_slaves.inc
#
# Generate MTS gaps for channel1.
#
[connection server_1]
[connection server_1]
CREATE DATABASE d1_1;;
CREATE DATABASE d2_1;;;
CREATE TABLE d1_1.t (a INT PRIMARY KEY, name text) ENGINE=INNODB;;
CREATE TABLE d2_1.t (a INT PRIMARY KEY, name text) ENGINE=INNODB;;
include/sync_slave_sql_with_master.inc [FOR CHANNEL 'channel_1']
[connection slave_con_channel1]
BEGIN;
INSERT INTO d2_1.t VALUES (2, 'Slave local'); # Hold T3;
INSERT INTO d1_1.t VALUES (3, 'Slave local'); # Hold T6;
[connection server_1]
INSERT INTO d1_1.t VALUES (1, 'T1');;
INSERT INTO d2_1.t VALUES (1, 'T2');;
INSERT INTO d2_1.t VALUES (2, 'T3'); # This will be a gap when executed on slave;
INSERT INTO d2_1.t VALUES (3, 'T4'); # This will be a gap when executed on slave;
INSERT INTO d1_1.t VALUES (2, 'T5');;
[connection server_2]
# Now d1_1.t has two rows and d2_.t has one row.
#
# Generate MTS gaps for channel3.
#
[connection server_3]
[connection server_3]
CREATE DATABASE d1_3;;
CREATE DATABASE d2_3;;;
CREATE TABLE d1_3.t (a INT PRIMARY KEY, name text) ENGINE=INNODB;;
CREATE TABLE d2_3.t (a INT PRIMARY KEY, name text) ENGINE=INNODB;;
include/sync_slave_sql_with_master.inc [FOR CHANNEL 'channel_3']
[connection slave_con_channel3]
BEGIN;
INSERT INTO d2_3.t VALUES (2, 'Slave local'); # Hold T3;
INSERT INTO d1_3.t VALUES (3, 'Slave local'); # Hold T6;
[connection server_3]
INSERT INTO d1_3.t VALUES (1, 'T1');;
INSERT INTO d2_3.t VALUES (1, 'T2');;
INSERT INTO d2_3.t VALUES (2, 'T3'); # This will be a gap when executed on slave;
INSERT INTO d2_3.t VALUES (3, 'T4'); # This will be a gap when executed on slave;
INSERT INTO d1_3.t VALUES (2, 'T5');;
[connection server_2]
# Now d1_3.t has two rows and d2_.t has one row.
[connection server_2]
CALL mtr.add_suppression("Recovery from source pos");
# Kill the server
include/rpl_start_server.inc [server_number=2 parameters: --relay-log-recovery --skip-replica-start --gtid-mode=off]
[connection server_2]
START SLAVE;
Warnings:
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
# channel 1
[connection server_1]
include/sync_slave_sql_with_master.inc [FOR CHANNEL 'channel_1']
# channel 3
[connection server_3]
include/sync_slave_sql_with_master.inc [FOR CHANNEL 'channel_3']
connection_server_1
DROP DATABASE d1_1;
DROP DATABASE d2_1;
include/sync_slave_sql_with_master.inc [FOR CHANNEL 'channel_1']
connection_server_3
DROP DATABASE d1_3;
DROP DATABASE d2_3;
include/sync_slave_sql_with_master.inc [FOR CHANNEL 'channel_3']
include/rpl_end.inc
RESET REPLICA ALL FOR CHANNEL 'channel_1';
RESET REPLICA ALL FOR CHANNEL 'channel_3';
|
