Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_gtid_server_sighup.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 include/stop_slave.inc
7 CHANGE REPLICATION SOURCE TO SOURCE_CONNECT_RETRY=30, SOURCE_RETRY_COUNT=30;
8 include/start_slave.inc
9 CREATE TABLE pid_table(pid_no INT);
10 [connection server_1]
11 LOAD DATA LOCAL INFILE 'pid_file' INTO TABLE pid_table;
12 DELETE FROM pid_table;
13 include/sync_slave_sql_with_master.inc
14 [connection server_1]
15 include/show_binlog_events.inc
16 Log_name Pos Event_type Server_id End_log_pos Info
17 master-bin.000002 # Previous_gtids # # Gtid_set
18 master-bin.000002 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
19 master-bin.000002 # Query # # BEGIN
20 master-bin.000002 # Query # # use `test`; DELETE FROM pid_table
21 master-bin.000002 # Xid # # COMMIT /* XID */
22 include/rpl_stop_server.inc [server_number=1]
23 include/rpl_start_server.inc [server_number=1 gtids=on]
24 include/sync_slave_sql_with_master.inc
25 [connection server_2]
26 LOAD DATA LOCAL INFILE 'pid_file' INTO TABLE pid_table;
27 [connection server_1]
28 DELETE FROM pid_table;
29 include/sync_slave_sql_with_master.inc
30 include/show_relaylog_events.inc
31 Log_name Pos Event_type Server_id End_log_pos Info
32 slave-relay-bin.000006 # Previous_gtids # # Gtid_set
33 slave-relay-bin.000006 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
34 slave-relay-bin.000006 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
35 slave-relay-bin.000006 # Query # # BEGIN
36 slave-relay-bin.000006 # Query # # use `test`; DELETE FROM pid_table
37 slave-relay-bin.000006 # Xid # # COMMIT /* XID */
38 include/rpl_stop_server.inc [server_number=2]
39 include/rpl_start_server.inc [server_number=2 gtids=on]
40 include/rpl_start_slaves.inc
41 [connection server_1]
42 DROP TABLE pid_table;
43 include/sync_slave_sql_with_master.inc
44 include/rpl_end.inc