Debian Codegraph @

mysql-test/suite/rpl_gtid/t/rpl_server_version_multi_source.test

raw
1 #
2 # ==== Purpose ====
3 #
4 # In this test, we check that the original_server_version is correctly
5 # generated and replicated in a server_1 (Master) -> server_2 and
6 # server_3 (Master) -> server_2 multi-source replication topology.
7 #
8 # ==== Implementation ====
9 #
10 # Considering the above replication topology, we test two scenarios:
11 # Scenario 1: Force server_1 to write as its original_server_version the value
12 # 888888, synchronize with server_2 and check that the value is replicated
13 # unchanged.
14 # Scenario 2: Execute a transaction in server_3, synchronize with server_2, and
15 # check that the value written to server_3's binlog is the expected one and that
16 # it is replicated correctly to server_2.
17 #
18 # ==== References ====
19 #
20 # WL#11879 replicate original server version
21
22
23 # test is binlog format agnostic
24 --source include/have_binlog_format_row.inc
25 --source include/have_debug.inc
26 # Test requires master-info-repository=TABLE, relay-log-info-repository=TABLE
27 --source include/have_slave_repository_type_table.inc
28
29 # Establish the msr topology
30 --let $rpl_topology=1->2,3->2
31 --let $rpl_multi_source= 1
32 --source include/rpl_init.inc
33
34 # transform server version in format AA.BB.CC[-suffix] into AABBCC
35 --write_file $MYSQL_TMP_DIR/get_numerical_server_version.inc
36 --let $server_version = `SELECT @@GLOBAL.version`
37 --let $major_version_number = `SELECT SUBSTRING_INDEX('$server_version', '.', 1)`
38 --let $mid_version_number = `SELECT SUBSTRING_INDEX(SUBSTRING_INDEX('$server_version', '.', 2), '.', -1)`
39 --let $minor_version_number = `SELECT SUBSTRING_INDEX(SUBSTRING_INDEX('$server_version', '-', 1), '.', -1)`
40 --let $numerical_server_version = `SELECT $major_version_number * 10000 + $mid_version_number * 100 + $minor_version_number`
41 EOF
42
43 --let $rpl_connection_name = server_1
44 --source include/rpl_connection.inc
45
46 # Scenario 1:
47 # force server_1 to write 888888 as its original_server_version to check that
48 # the value is replicated unchanged
49 # force server_1 to write 888888 as its immediate_server_version to check that
50 # the value is written to its binlog but in server_2 its own server version is
51 # written to the binlog
52 --let $debug_point = fixed_server_version
53 --source include/add_debug_point.inc
54
55 --let $server_uuid = query_get_value(select @@global.server_uuid, @@global.server_uuid, 1)
56 --let $gtid = $server_uuid:1
57
58 CREATE TABLE t1 (a INT);
59
60 --let $rpl_channel_name= 'channel_1'
61 --let $sync_slave_connection=server_2
62 --source include/sync_slave_sql_with_master.inc
63
64 --let $rpl_connection_name = server_1
65 --source include/rpl_connection.inc
66 --source include/get_original_server_version.inc
67 --let $OSV_1 = $original_server_version
68 --source include/get_immediate_server_version.inc
69 --let $ISV_1 = $immediate_server_version
70
71 --let $rpl_connection_name = server_2
72 --source include/rpl_connection.inc
73 --source include/get_original_server_version.inc
74 --let $OSV_2 = $original_server_version
75 --source include/get_immediate_server_version.inc
76 --let $ISV_2 = $immediate_server_version
77 --source $MYSQL_TMP_DIR/get_numerical_server_version.inc
78 --let $numerical_server_version_2 = $numerical_server_version
79
80 --let $assert_text = server_1 original_server_version must be 888888
81 --let $assert_cond = $OSV_1 = 888888
82 --source include/assert.inc
83
84 --let $assert_text = server_2 original_server_version must be equal to server_1
85 --let $assert_cond = $OSV_2 = $OSV_1
86 --source include/assert.inc
87
88 --let $assert_text = server_1 immediate_server_version must be 888888
89 --let $assert_cond = $ISV_1 = 888888
90 --source include/assert.inc
91
92 --let $assert_text = server_2 immediate_server_version must be equal its own server version
93 --let $assert_cond = $ISV_2 = $numerical_server_version_2
94 --source include/assert.inc
95
96 # Scenario 2:
97 # execute a transaction in server_3 to check that the correct value of
98 # original_server_version is generated and replicated
99 --let $rpl_connection_name = server_3
100 --source include/rpl_connection.inc
101
102 --let $server_uuid = query_get_value(select @@global.server_uuid, @@global.server_uuid, 1)
103 --let $gtid = $server_uuid:1
104
105 CREATE TABLE t2 (a INT);
106
107 # sync server_2 with server_3
108 --let $rpl_channel_name= 'channel_3'
109 --let $sync_slave_connection=server_2
110 --source include/sync_slave_sql_with_master.inc
111
112 --let $rpl_connection_name = server_3
113 --source include/rpl_connection.inc
114 --source include/get_original_server_version.inc
115 --let $OSV_3 = $original_server_version
116 --source include/get_immediate_server_version.inc
117 --let $ISV_3 = $immediate_server_version
118 --source $MYSQL_TMP_DIR/get_numerical_server_version.inc
119 --let $numerical_server_version_3 = $numerical_server_version
120
121 --let $rpl_connection_name = server_2
122 --source include/rpl_connection.inc
123 --source include/get_original_server_version.inc
124 --let $OSV_2 = $original_server_version
125 --source include/get_immediate_server_version.inc
126 --let $ISV_2 = $immediate_server_version
127
128 --let $assert_text = server_3 original_server_version must be equal its own server version
129 --let $assert_cond = $numerical_server_version_3 = $OSV_3
130 --source include/assert.inc
131
132 --let $assert_text = server_2 original_server_version must be equal to server_3
133 --let $assert_cond = $OSV_2 = $OSV_3
134 --source include/assert.inc
135
136 --let $assert_text = server_3 immediate_server_version must be equal its own server version
137 --let $assert_cond = $ISV_3 = $numerical_server_version_3
138 --source include/assert.inc
139
140 --let $assert_text = server_2 immediate_server_version must be equal its own server version
141 --let $assert_cond = $ISV_2 = $numerical_server_version_2
142 --source include/assert.inc
143
144 # cleanup
145 --let $rpl_connection_name= server_1
146 --source include/rpl_connection.inc
147 --let $debug_point = fixed_server_version
148 --source include/remove_debug_point.inc
149 DROP TABLE t1;
150 --let $rpl_channel_name= 'channel_1'
151 --let $sync_slave_connection=server_2
152 --source include/sync_slave_sql_with_master.inc
153
154 --let $rpl_connection_name= server_3
155 --source include/rpl_connection.inc
156 DROP TABLE t2;
157 --let $rpl_channel_name= 'channel_3'
158 --let $sync_slave_connection=server_2
159 --source include/sync_slave_sql_with_master.inc
160
161 --let $rpl_skip_sync= 1
162 --source include/rpl_end.inc
163 --remove_file $MYSQL_TMP_DIR/get_numerical_server_version.inc