Debian Codegraph @

mysql-test/suite/galera/r/rpl_galera_to_mariadb_clone_slave_using_mariadb-backup.result

raw
1 connection node_2;
2 connection node_1;
3 #
4 # MDEV-33355 Add a Galera-2-node-to-MariaDB replication MTR test cloning the slave with mariadb-backup
5 #
6 connect master, 127.0.0.1, root, , test, $NODE_MYPORT_1;
7 connect slave, 127.0.0.1, root, , test, $NODE_MYPORT_3;
8 START SLAVE;
9 include/wait_for_slave_to_start.inc
10 connection master;
11 connection slave;
12 ##############################################################
13 ### Initial block with some transactions
14 ### Slave: Make sure replication is not using GTID
15 connection slave;
16 # Using_Gtid=No
17 ### Master: Create and populate t1
18 connection master;
19 CREATE TABLE t1(a TEXT) ENGINE=InnoDB CHARSET=latin1;
20 START TRANSACTION;
21 INSERT INTO t1 VALUES ('tr#00:stmt#00 - slave run#0, before backup');
22 INSERT INTO t1 VALUES ('tr#00:stmt#01 - slave run#0, before backup');
23 INSERT INTO t1 VALUES ('tr#00:stmt#02 - slave run#0, before backup');
24 COMMIT;
25 connection slave;
26 ##############################################################
27 ### Run the last transaction before mariadb-backup --backup
28 ### Remember SHOW MASTER STATUS and @@gtid_binlog_pos
29 ### before and after the transaction.
30 ### Master: Rember MASTER STATUS and @@gtid_binlog_pos before tr#01
31 connection master;
32 ### Slave: Remember MASTER STATUS and @@gtid_binlog_pos before tr#01
33 connection slave;
34 ### Master: Run the actual last transaction before the backup
35 connection master;
36 START TRANSACTION;
37 INSERT INTO t1 VALUES ('tr#01:stmt#00 - slave run#0, before backup');
38 INSERT INTO t1 VALUES ('tr#01:stmt#01 - slave run#0, before backup');
39 INSERT INTO t1 VALUES ('tr#01:stmt#02 - slave run#0, before backup');
40 COMMIT;
41 connection slave;
42 ### Master: Remember MASTER STATUS and @@gtid_binlog_pos after tr#01
43 connection master;
44 ### Slave: Remember MASTER STATUS and @@gtid_binlog_pos after tr#01
45 connection slave;
46 ##############################################################
47 ### Running `mariadb-backup --backup,--prepare` and checking
48 ### that mariadb_backup_slave_info and mariadb_backup_binlog_info are OK
49 ### Slave: Create a backup
50 ### Slave: Prepare the backup
51 ### Slave: xtrabackup files:
52 ############################ mariadb_backup_slave_info
53 CHANGE MASTER TO MASTER_LOG_FILE='master_after_tr01_show_master_status_file', MASTER_LOG_POS=master_after_tr01_show_master_status_position;
54 ############################ mariadb_backup_binlog_info
55 slave_after_tr01_show_master_status_file slave_after_tr01_show_master_status_position slave_after_tr01_gtid_binlog_pos
56 ############################
57 ##############################################################
58 ### Run more transactions after the backup:
59 ### - while the slave is still running, then
60 ### - while the slave is shut down
61 ### Master: Run another transaction while the slave is still running
62 connection master;
63 START TRANSACTION;
64 INSERT INTO t1 VALUES ('tr#02:stmt#00 - slave run#0, after backup');
65 INSERT INTO t1 VALUES ('tr#02:stmt#01 - slave run#0, after backup');
66 INSERT INTO t1 VALUES ('tr#02:stmt@02 - slave run#0, after backup');
67 COMMIT;
68 connection slave;
69 ### Master: Remember MASTER STATUS and @@gtid_binlog_pos after tr#02
70 connection master;
71 ### Slave: Remember MASTER STATUS and @@gtid_binlog_pos after tr#02
72 connection slave;
73 ### Master: Checking SHOW BINLOG EVENTS
74 connection master;
75 SHOW BINLOG EVENTS IN 'master_after_tr01_show_master_status_file' FROM master_after_tr01_show_master_status_position LIMIT 0,1;
76 Log_name master_after_tr01_show_master_status_file
77 Pos master_after_tr01_show_master_status_position
78 Event_type Gtid
79 Server_id #
80 End_log_pos #
81 Info BEGIN GTID master_after_tr02_gtid_binlog_pos
82 SHOW BINLOG EVENTS IN 'master_after_tr01_show_master_status_file' FROM master_after_tr01_show_master_status_position LIMIT 1,1;
83 Log_name master_after_tr01_show_master_status_file
84 Pos #
85 Event_type Query_or_Annotate_rows
86 Server_id #
87 End_log_pos #
88 Info INSERT INTO t1 VALUES ('tr#02:stmt#00 - slave run#0, after backup')
89 ### Slave: Checking SHOW BINLOG EVENTS
90 connection slave;
91 SHOW BINLOG EVENTS IN 'slave_after_tr01_show_master_status_file' FROM slave_after_tr01_show_master_status_position LIMIT 0,1;
92 Log_name slave_after_tr01_show_master_status_file
93 Pos #
94 Event_type Gtid
95 Server_id 1
96 End_log_pos #
97 Info BEGIN GTID slave_after_tr02_gtid_binlog_pos
98 SHOW BINLOG EVENTS IN 'slave_after_tr01_show_master_status_file' FROM slave_after_tr01_show_master_status_position LIMIT 1,1;
99 Log_name slave_after_tr01_show_master_status_file
100 Pos #
101 Event_type Query_or_Annotate_rows
102 Server_id #
103 End_log_pos #
104 Info INSERT INTO t1 VALUES ('tr#02:stmt#00 - slave run#0, after backup')
105 ### Slave: Stop replication
106 connection slave;
107 STOP SLAVE;
108 include/wait_for_slave_to_stop.inc
109 RESET SLAVE;
110 Warnings:
111 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
112 ### Slave: Shutdown the server
113 connection slave;
114 ### Master: Run a transaction while the slave is shut down
115 connection master;
116 START TRANSACTION;
117 INSERT INTO t1 VALUES ('tr#03:stmt#00 - after slave run#0, slave is shut down, after backup');
118 INSERT INTO t1 VALUES ('tr#03:stmt#01 - after slave run#0, slave is shut down, after backup');
119 INSERT INTO t1 VALUES ('tr#03:stmt#02 - after slave run#0, slave is shut down, after backup');
120 COMMIT;
121 ##############################################################
122 ### Emulate starting a new virgin slave
123 ### Slave: Remove the data directory
124 ### Slave: Copy back the backup
125 ### Slave: Restart the server
126 connection slave;
127 # restart
128 ### Slave: Display the restored data before START SLAVE
129 connection slave;
130 SELECT * FROM t1 ORDER BY a;
131 a
132 tr#00:stmt#00 - slave run#0, before backup
133 tr#00:stmt#01 - slave run#0, before backup
134 tr#00:stmt#02 - slave run#0, before backup
135 tr#01:stmt#00 - slave run#0, before backup
136 tr#01:stmt#01 - slave run#0, before backup
137 tr#01:stmt#02 - slave run#0, before backup
138 ### Slave: Execute the CHANGE MASTER statement to set up the host and port
139 CHANGE MASTER '' TO MASTER_USER='root', MASTER_HOST='127.0.0.1', MASTER_PORT=###, MASTER_CONNECT_RETRY=1, MASTER_SSL_VERIFY_SERVER_CERT=0;
140 ### Slave: Execute the CHANGE MASTER statement from mariadb_backup_slave_info
141 CHANGE MASTER TO MASTER_LOG_FILE='master_after_tr01_show_master_status_file', MASTER_LOG_POS=master_after_tr01_show_master_status_position;
142 Warnings:
143 Note 4190 CHANGE MASTER TO is implicitly changing the value of 'Using_Gtid' from 'Slave_Pos' to 'No'
144 ### Slave: Execute START SLAVE
145 include/start_slave.inc
146 ### Master: Wait for the slave to apply all master events
147 connection master;
148 connection slave;
149 ### Slave: Make sure replication is not using GTID after the slave restart
150 connection slave;
151 # Using_Gtid=No
152 ### Slave: Display the restored data after START SLAVE
153 connection slave;
154 SELECT * FROM t1 ORDER BY a;
155 a
156 tr#00:stmt#00 - slave run#0, before backup
157 tr#00:stmt#01 - slave run#0, before backup
158 tr#00:stmt#02 - slave run#0, before backup
159 tr#01:stmt#00 - slave run#0, before backup
160 tr#01:stmt#01 - slave run#0, before backup
161 tr#01:stmt#02 - slave run#0, before backup
162 tr#02:stmt#00 - slave run#0, after backup
163 tr#02:stmt#01 - slave run#0, after backup
164 tr#02:stmt@02 - slave run#0, after backup
165 tr#03:stmt#00 - after slave run#0, slave is shut down, after backup
166 tr#03:stmt#01 - after slave run#0, slave is shut down, after backup
167 tr#03:stmt#02 - after slave run#0, slave is shut down, after backup
168 ##############################################################
169 ### Continue master transactions, check the new slave replicates well.
170 ### Master: Run a transaction after restarting replication
171 connection master;
172 START TRANSACTION;
173 INSERT INTO t1 VALUES ('tr#04:stmt#00 - slave run#1');
174 INSERT INTO t1 VALUES ('tr#04:stmt#01 - slave run#1');
175 INSERT INTO t1 VALUES ('tr#04:stmt#02 - slave run#1');
176 COMMIT;
177 connection slave;
178 ### Slave: Display the restored data + new transactions
179 connection slave;
180 SELECT * FROM t1 ORDER BY a;
181 a
182 tr#00:stmt#00 - slave run#0, before backup
183 tr#00:stmt#01 - slave run#0, before backup
184 tr#00:stmt#02 - slave run#0, before backup
185 tr#01:stmt#00 - slave run#0, before backup
186 tr#01:stmt#01 - slave run#0, before backup
187 tr#01:stmt#02 - slave run#0, before backup
188 tr#02:stmt#00 - slave run#0, after backup
189 tr#02:stmt#01 - slave run#0, after backup
190 tr#02:stmt@02 - slave run#0, after backup
191 tr#03:stmt#00 - after slave run#0, slave is shut down, after backup
192 tr#03:stmt#01 - after slave run#0, slave is shut down, after backup
193 tr#03:stmt#02 - after slave run#0, slave is shut down, after backup
194 tr#04:stmt#00 - slave run#1
195 tr#04:stmt#01 - slave run#1
196 tr#04:stmt#02 - slave run#1
197 ##############################################################
198 ### Cleanup
199 ### Removing the backup directory
200 connection master;
201 DROP TABLE t1;
202 connection slave;
203 STOP SLAVE;
204 include/wait_for_slave_to_stop.inc
205 RESET SLAVE ALL;
206 Warnings:
207 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
208 connection master;
209 set global wsrep_on=OFF;
210 RESET MASTER;
211 set global wsrep_on=ON;