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
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
|
include/rpl_init.inc [topology=1->2->3]
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.
include/rpl_default_connections.inc
include/rpl_reset.inc
==== Case 1A: Transaction filtered out ====
include/gtid_step_reset.inc
CREATE TABLE t_ignore(id INT);
INSERT INTO t_ignore VALUES (1);
DROP TABLE t_ignore;
CREATE TABLE t_ignore_wild(id INT);
INSERT INTO t_ignore_wild VALUES (1);
DROP TABLE t_ignore_wild;
include/gtid_step_assert.inc [count=6, only_count=0]
include/rpl_sync.inc
==== Case 1B: CREATE/ALTER/DROP TEMPORARY filtered out ====
CREATE TEMPORARY TABLE t_ignore(a INT);
ALTER TABLE t_ignore ADD COLUMN b INT;
INSERT INTO t_ignore VALUES (1, 2);
DROP TEMPORARY TABLE t_ignore;
CREATE TEMPORARY TABLE t_ignore_wild(a INT);
ALTER TABLE t_ignore_wild ADD COLUMN b INT;
INSERT INTO t_ignore_wild VALUES (1, 2);
DROP TEMPORARY TABLE t_ignore_wild;
include/gtid_step_assert.inc [count=0, only_count=0]
include/rpl_sync.inc
==== Case 1C: database filters on slave applier ====
include/gtid_step_reset.inc
CREATE DATABASE db_ignore;
USE db_ignore;
CREATE TABLE t1 (a INT);
INSERT INTO t1 VALUES (1);
USE test;
include/gtid_step_assert.inc [count=3, only_count=0]
include/rpl_sync.inc
include/assert.inc [db_ignore should not be created on slave]
include/assert.inc [db_ignore should not be created on second slave]
DROP DATABASE db_ignore;
include/rpl_sync.inc
==== Case 1D: database filters on slave binary log ====
include/gtid_step_reset.inc
CREATE DATABASE db_binlog_ignore;
USE db_binlog_ignore;
CREATE TABLE t1 (a INT);
INSERT INTO t1 VALUES (1);
USE test;
include/gtid_step_assert.inc [count=3, only_count=0]
include/rpl_sync.inc
include/assert.inc [db_binlog_ignore should not be created on slave]
include/assert.inc [db_binlog_ignore should not be created on second slave]
DROP DATABASE db_binlog_ignore;
include/rpl_sync.inc
==== Case 2A: temp table transaction not logged in row format ====
---- Initialize ----
SET @save.binlog_format= @@global.binlog_format;
Warnings:
Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
include/stop_slave_sql.inc
SET @@global.binlog_format= 'row';
Warnings:
Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
include/start_slave_sql.inc
---- Test ----
include/gtid_step_reset.inc
CREATE TEMPORARY TABLE t2 (a INT);
ALTER TABLE t2 ADD COLUMN b INT;
INSERT INTO t2 VALUES (1, 2);
include/gtid_step_assert.inc [count=0, only_count=0]
include/rpl_sync.inc
---- Clean up ----
DROP TEMPORARY TABLE t2;
include/rpl_sync.inc
include/stop_slave_sql.inc
SET @@global.binlog_format= @save.binlog_format;
Warnings:
Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
==== Case 2B: transaction with no effect not logged in row format ====
---- Initialize ----
SET @save.binlog_format= @@global.binlog_format;
Warnings:
Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
SET @@global.binlog_format= 'row';
Warnings:
Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
include/start_slave_sql.inc
SET @@session.binlog_format= statement;
Warnings:
Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
CREATE TABLE t1(id INT) ENGINE = InnoDB;
include/rpl_sync.inc
INSERT INTO t1 VALUES (0);
---- Test ----
UPDATE t1 SET id= 1 WHERE id = 0;
include/rpl_sync.inc
---- Clean up ----
DROP TABLE t1;
include/rpl_sync.inc
include/stop_slave_sql.inc
SET @@global.binlog_format= @save.binlog_format;
Warnings:
Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
include/start_slave_sql.inc
==== Case 3: explicit empty transaction on master ====
SET @@SESSION.binlog_format= 'row';
Warnings:
Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
include/gtid_step_reset.inc
SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
COMMIT;
SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
include/gtid_step_assert.inc [count=1, only_count=1]
CREATE TABLE t1 (a INT);
CREATE PROCEDURE p1()
BEGIN
SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2';
START TRANSACTION;
COMMIT;
SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:3';
START TRANSACTION;
COMMIT;
END|
include/gtid_step_assert.inc [count=2, only_count=1]
CALL p1();
SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
include/gtid_step_assert.inc [count=2, only_count=1]
DROP TABLE t1;
include/rpl_sync.inc
==== Case 4: Nothing logged for ROLLBACK transactions ====
---- Initialize ----
CREATE TABLE t1 (a INT) ENGINE = InnoDB;
---- Test ----
include/gtid_step_reset.inc
DROP TABLE t2;
ERROR 42S02: Unknown table 'test.t2'
INSERT INTO t1 VALUES (1, 1);
ERROR 21S01: Column count doesn't match value count at row 1
BEGIN;
INSERT INTO t1 VALUES (2);
ROLLBACK;
include/gtid_step_assert.inc [count=0, only_count=0]
---- Clean Up ----
DROP TABLE t1;
DROP PROCEDURE p1;
include/rpl_end.inc
|
