Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_rotate_gtid.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 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.
5 [connection master]
6 # Preparing the relaylog
7 [connection slave]
8 include/stop_slave.inc
9 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION=0;
10 include/start_slave_io.inc
11 SET @save_debug=@@global.debug;
12 SET GLOBAL DEBUG='+d,stop_io_after_reading_gtid_log_event';
13 # Create a transaction on the master
14 # that will have it's GTID and other events in separated relay log files
15 [connection master]
16 CREATE TABLE t1 (c1 INT) ENGINE=InnoDB;
17 [connection slave]
18 include/wait_for_slave_io_to_stop.inc
19 SET GLOBAL DEBUG=@save_debug;
20 include/start_slave_io.inc
21 # Create other transaction on the master
22 [connection master]
23 CREATE TABLE t2 (c1 INT) ENGINE=InnoDB;
24 include/sync_slave_io_with_master.inc
25 # Restart the SQL thread until the beginning of the last relay log file
26 [connection slave]
27 START SLAVE SQL_THREAD UNTIL
28 RELAY_LOG_FILE= 'slave-relay-bin.000003',
29 RELAY_LOG_POS= 4;
30 include/wait_for_slave_sql_to_stop.inc
31 # Restart the SQL thread
32 include/start_slave_sql.inc
33 [connection master]
34 include/sync_slave_sql_with_master.inc
35 include/assert.inc [t1 should be replicated]
36 # Cleanup
37 [connection master]
38 DROP TABLE t1, t2;
39 include/rpl_end.inc