1include/master-slave.inc 2[connection master] 3connection master; 4include/rpl_reset.inc 5connection master; 6CREATE TABLE t1 (a INT); 7INSERT INTO t1 VALUES (1); 8INSERT INTO t1 VALUES (2); 9INSERT INTO t1 VALUES (3); 10******** [master] SHOW BINLOG EVENTS IN <FILE> ******** 11include/show_events.inc 12Log_name Pos Event_type Server_id End_log_pos Info 13master-bin.000001 # Gtid # # GTID #-#-# 14master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) 15master-bin.000001 # Gtid # # BEGIN GTID #-#-# 16master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1) 17master-bin.000001 # Query # # COMMIT 18master-bin.000001 # Gtid # # BEGIN GTID #-#-# 19master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2) 20master-bin.000001 # Query # # COMMIT 21master-bin.000001 # Gtid # # BEGIN GTID #-#-# 22master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3) 23master-bin.000001 # Query # # COMMIT 24******** [master] SHOW BINLOG EVENTS IN <FILE> LIMIT 2 ******** 25include/show_events.inc 26Log_name Pos Event_type Server_id End_log_pos Info 27master-bin.000001 # Gtid # # GTID #-#-# 28master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) 29******** [master] SHOW BINLOG EVENTS IN <FILE> LIMIT 2,4 ******** 30include/show_events.inc 31Log_name Pos Event_type Server_id End_log_pos Info 32master-bin.000001 # Gtid # # BEGIN GTID #-#-# 33master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1) 34master-bin.000001 # Query # # COMMIT 35master-bin.000001 # Gtid # # BEGIN GTID #-#-# 36******** [master] SHOW BINLOG EVENTS ******** 37include/show_events.inc 38Log_name Pos Event_type Server_id End_log_pos Info 39master-bin.000001 # Gtid # # GTID #-#-# 40master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) 41master-bin.000001 # Gtid # # BEGIN GTID #-#-# 42master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1) 43master-bin.000001 # Query # # COMMIT 44master-bin.000001 # Gtid # # BEGIN GTID #-#-# 45master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2) 46master-bin.000001 # Query # # COMMIT 47master-bin.000001 # Gtid # # BEGIN GTID #-#-# 48master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3) 49master-bin.000001 # Query # # COMMIT 50connection slave; 51******** [slave] SHOW BINLOG EVENTS IN <FILE> ******** 52include/show_events.inc 53Log_name Pos Event_type Server_id End_log_pos Info 54slave-bin.000001 # Gtid # # GTID #-#-# 55slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) 56slave-bin.000001 # Gtid # # BEGIN GTID #-#-# 57slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1) 58slave-bin.000001 # Query # # COMMIT 59slave-bin.000001 # Gtid # # BEGIN GTID #-#-# 60slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2) 61slave-bin.000001 # Query # # COMMIT 62slave-bin.000001 # Gtid # # BEGIN GTID #-#-# 63slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3) 64slave-bin.000001 # Query # # COMMIT 65******** [slave] SHOW BINLOG EVENTS IN <FILE> LIMIT 2 ******** 66include/show_events.inc 67Log_name Pos Event_type Server_id End_log_pos Info 68slave-bin.000001 # Gtid # # GTID #-#-# 69slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) 70******** [slave] SHOW BINLOG EVENTS IN <FILE> LIMIT 2,4 ******** 71include/show_events.inc 72Log_name Pos Event_type Server_id End_log_pos Info 73slave-bin.000001 # Gtid # # BEGIN GTID #-#-# 74slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1) 75slave-bin.000001 # Query # # COMMIT 76slave-bin.000001 # Gtid # # BEGIN GTID #-#-# 77******** [slave] SHOW BINLOG EVENTS ******** 78include/show_events.inc 79Log_name Pos Event_type Server_id End_log_pos Info 80slave-bin.000001 # Gtid # # GTID #-#-# 81slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) 82slave-bin.000001 # Gtid # # BEGIN GTID #-#-# 83slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1) 84slave-bin.000001 # Query # # COMMIT 85slave-bin.000001 # Gtid # # BEGIN GTID #-#-# 86slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2) 87slave-bin.000001 # Query # # COMMIT 88slave-bin.000001 # Gtid # # BEGIN GTID #-#-# 89slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3) 90slave-bin.000001 # Query # # COMMIT 91******** [slave] SHOW RELAYLOG EVENTS IN <FILE> ******** 92include/show_events.inc 93Log_name Pos Event_type Server_id End_log_pos Info 94slave-relay-bin.000002 # Rotate # # master-bin.000001;pos=POS 95slave-relay-bin.000002 # Format_desc # # SERVER_VERSION, BINLOG_VERSION 96slave-relay-bin.000002 # Gtid_list # # [] 97slave-relay-bin.000002 # Binlog_checkpoint # # master-bin.000001 98slave-relay-bin.000002 # Gtid # # GTID #-#-# 99slave-relay-bin.000002 # Query # # use `test`; CREATE TABLE t1 (a INT) 100slave-relay-bin.000002 # Gtid # # BEGIN GTID #-#-# 101slave-relay-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (1) 102slave-relay-bin.000002 # Query # # COMMIT 103slave-relay-bin.000002 # Gtid # # BEGIN GTID #-#-# 104slave-relay-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (2) 105slave-relay-bin.000002 # Query # # COMMIT 106slave-relay-bin.000002 # Gtid # # BEGIN GTID #-#-# 107slave-relay-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (3) 108slave-relay-bin.000002 # Query # # COMMIT 109******** [slave] SHOW RELAYLOG EVENTS IN <FILE> LIMIT 2 ******** 110include/show_events.inc 111Log_name Pos Event_type Server_id End_log_pos Info 112slave-relay-bin.000002 # Rotate # # master-bin.000001;pos=POS 113slave-relay-bin.000002 # Format_desc # # SERVER_VERSION, BINLOG_VERSION 114******** [slave] SHOW RELAYLOG EVENTS IN <FILE> LIMIT 2,4 ******** 115include/show_events.inc 116Log_name Pos Event_type Server_id End_log_pos Info 117slave-relay-bin.000002 # Gtid_list # # [] 118slave-relay-bin.000002 # Binlog_checkpoint # # master-bin.000001 119slave-relay-bin.000002 # Gtid # # GTID #-#-# 120slave-relay-bin.000002 # Query # # use `test`; CREATE TABLE t1 (a INT) 121******** [slave] SHOW RELAYLOG EVENTS ******** 122include/show_events.inc 123Log_name Pos Event_type Server_id End_log_pos Info 124slave-relay-bin.000001 # Rotate # # slave-relay-bin.000002;pos=POS 125FLUSH LOGS; 126connection master; 127FLUSH LOGS; 128DROP TABLE t1; 129******** [master] SHOW BINLOG EVENTS IN <FILE> ******** 130include/show_events.inc 131Log_name Pos Event_type Server_id End_log_pos Info 132master-bin.000002 # Binlog_checkpoint # # master-bin.000002 133master-bin.000002 # Gtid # # GTID #-#-# 134master-bin.000002 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ 135******** [master] SHOW BINLOG EVENTS IN <FILE> LIMIT 2 ******** 136include/show_events.inc 137Log_name Pos Event_type Server_id End_log_pos Info 138master-bin.000002 # Binlog_checkpoint # # master-bin.000002 139master-bin.000002 # Gtid # # GTID #-#-# 140******** [master] SHOW BINLOG EVENTS IN <FILE> LIMIT 2,4 ******** 141include/show_events.inc 142Log_name Pos Event_type Server_id End_log_pos Info 143master-bin.000002 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ 144******** [master] SHOW BINLOG EVENTS ******** 145include/show_events.inc 146Log_name Pos Event_type Server_id End_log_pos Info 147master-bin.000001 # Gtid # # GTID #-#-# 148master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) 149master-bin.000001 # Gtid # # BEGIN GTID #-#-# 150master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1) 151master-bin.000001 # Query # # COMMIT 152master-bin.000001 # Gtid # # BEGIN GTID #-#-# 153master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2) 154master-bin.000001 # Query # # COMMIT 155master-bin.000001 # Gtid # # BEGIN GTID #-#-# 156master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3) 157master-bin.000001 # Query # # COMMIT 158master-bin.000001 # Rotate # # master-bin.000002;pos=POS 159connection slave; 160******** [slave] SHOW BINLOG EVENTS IN <FILE> ******** 161include/show_events.inc 162Log_name Pos Event_type Server_id End_log_pos Info 163slave-bin.000002 # Binlog_checkpoint # # slave-bin.000002 164slave-bin.000002 # Gtid # # GTID #-#-# 165slave-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */ 166******** [slave] SHOW BINLOG EVENTS IN <FILE> LIMIT 2 ******** 167include/show_events.inc 168Log_name Pos Event_type Server_id End_log_pos Info 169slave-bin.000002 # Binlog_checkpoint # # slave-bin.000002 170slave-bin.000002 # Gtid # # GTID #-#-# 171******** [slave] SHOW BINLOG EVENTS IN <FILE> LIMIT 2,4 ******** 172include/show_events.inc 173Log_name Pos Event_type Server_id End_log_pos Info 174slave-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */ 175******** [slave] SHOW BINLOG EVENTS ******** 176include/show_events.inc 177Log_name Pos Event_type Server_id End_log_pos Info 178slave-bin.000001 # Gtid # # GTID #-#-# 179slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) 180slave-bin.000001 # Gtid # # BEGIN GTID #-#-# 181slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1) 182slave-bin.000001 # Query # # COMMIT 183slave-bin.000001 # Gtid # # BEGIN GTID #-#-# 184slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2) 185slave-bin.000001 # Query # # COMMIT 186slave-bin.000001 # Gtid # # BEGIN GTID #-#-# 187slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3) 188slave-bin.000001 # Query # # COMMIT 189slave-bin.000001 # Rotate # # slave-bin.000002;pos=POS 190******** [slave] SHOW RELAYLOG EVENTS IN <FILE> ******** 191include/show_events.inc 192Log_name Pos Event_type Server_id End_log_pos Info 193slave-relay-bin.000005 # Rotate # # master-bin.000002;pos=POS 194slave-relay-bin.000005 # Format_desc # # SERVER_VERSION, BINLOG_VERSION 195slave-relay-bin.000005 # Gtid_list # # [#-#-#] 196slave-relay-bin.000005 # Binlog_checkpoint # # master-bin.000001 197slave-relay-bin.000005 # Binlog_checkpoint # # master-bin.000002 198slave-relay-bin.000005 # Gtid # # GTID #-#-# 199slave-relay-bin.000005 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ 200******** [slave] SHOW RELAYLOG EVENTS IN <FILE> LIMIT 2 ******** 201include/show_events.inc 202Log_name Pos Event_type Server_id End_log_pos Info 203slave-relay-bin.000005 # Rotate # # master-bin.000002;pos=POS 204slave-relay-bin.000005 # Format_desc # # SERVER_VERSION, BINLOG_VERSION 205******** [slave] SHOW RELAYLOG EVENTS IN <FILE> LIMIT 2,4 ******** 206include/show_events.inc 207Log_name Pos Event_type Server_id End_log_pos Info 208slave-relay-bin.000005 # Gtid_list # # [#-#-#] 209slave-relay-bin.000005 # Binlog_checkpoint # # master-bin.000001 210slave-relay-bin.000005 # Binlog_checkpoint # # master-bin.000002 211slave-relay-bin.000005 # Gtid # # GTID #-#-# 212******** [slave] SHOW RELAYLOG EVENTS ******** 213include/show_events.inc 214Log_name Pos Event_type Server_id End_log_pos Info 215slave-relay-bin.000004 # Rotate # # master-bin.000002;pos=POS 216slave-relay-bin.000004 # Rotate # # slave-relay-bin.000005;pos=POS 217include/rpl_end.inc 218