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
|
include/only_with_option.inc [GLOBAL.replica_parallel_workers > 2]
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 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.
[connection master]
# Adding debug point 'set_commit_parent_100' to @@GLOBAL.debug
CREATE TABLE t1 (a int primary key) engine=innodb;
CREATE TABLE t2 (a int primary key) engine=innodb;
CREATE TABLE t3 (a int primary key) engine=innodb;
CREATE TABLE t4 (a int primary key) engine=innodb;
include/sync_slave_sql_with_master.inc
include/stop_slave_sql.inc
# Adding debug point 'crash_in_a_worker' to @@GLOBAL.debug
# Removing debug point 'set_commit_parent_100' from @@GLOBAL.debug
# Adding debug point 'set_commit_parent_150' to @@GLOBAL.debug
INSERT INTO t1 values (0);
BEGIN;
INSERT INTO t2 values (1),(2),(3);
UPDATE t2 SET a= a+1 WHERE a=3;
COMMIT;
BEGIN;
INSERT INTO t3 values (1),(2),(3);
UPDATE t3 SET a= a+1 WHERE a=3;
COMMIT;
BEGIN;
INSERT INTO t4 values (1),(2),(3);
UPDATE t4 SET a= a+1 WHERE a=3;
COMMIT;
BEGIN;
INSERT INTO t1 values (1),(2),(3);
UPDATE t1 SET a= a+1 WHERE a=3;
COMMIT;
# Removing debug point 'set_commit_parent_150' from @@GLOBAL.debug
include/sync_slave_io_with_master.inc
[connection slave1]
BEGIN;
INSERT INTO t1 (a) VALUES (4);
INSERT INTO t2 (a) VALUES (4);
INSERT INTO t3 (a) VALUES (4);
INSERT INTO t4 (a) VALUES (4);
[connection slave]
START SLAVE;
Warnings:
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
include/rpl_start_server.inc [server_number=2]
# Reconnecting to the slave server
START SLAVE UNTIL SQL_AFTER_MTS_GAPS;
CREATE TABLE t5 (a int);
include/wait_for_slave_sql_to_stop.inc
include/start_slave.inc
DROP TABLES t1, t2, t3, t4, t5;
include/sync_slave_sql_with_master.inc
include/rpl_end.inc
|
