mirror of
https://github.com/MariaDB/server.git
synced 2025-10-30 18:36:12 +01:00
77 lines
3.3 KiB
Text
77 lines
3.3 KiB
Text
connection node_2;
|
|
connection node_1;
|
|
# On node_2
|
|
connection node_2;
|
|
SET GLOBAL wsrep_on=OFF;
|
|
RESET MASTER;
|
|
SET GLOBAL wsrep_on=ON;
|
|
# On node_1
|
|
connection node_1;
|
|
SET GLOBAL wsrep_on=OFF;
|
|
RESET MASTER;
|
|
SET GLOBAL wsrep_on=ON;
|
|
CREATE TABLE t1(i INT)ENGINE=INNODB;
|
|
INSERT INTO t1 VALUES(1);
|
|
DELETE FROM t1 WHERE i = 1;
|
|
# On node_2
|
|
connection node_2;
|
|
INSERT INTO t1 VALUES(2);
|
|
DELETE FROM t1 WHERE i = 2;
|
|
# On node_1
|
|
connection node_1;
|
|
SHOW BINLOG EVENTS IN 'mysqld-bin.000001' FROM <start_pos>;
|
|
Log_name Pos Event_type Server_id End_log_pos Info
|
|
mysqld-bin.000001 # Gtid_list 1 # []
|
|
mysqld-bin.000001 # Binlog_checkpoint 1 # mysqld-bin.000001
|
|
mysqld-bin.000001 # Gtid 1 # GTID 0-1-1
|
|
mysqld-bin.000001 # Query 1 # use `test`; CREATE TABLE t1(i INT)ENGINE=INNODB
|
|
mysqld-bin.000001 # Gtid 1 # BEGIN GTID 0-1-2
|
|
mysqld-bin.000001 # Annotate_rows 1 # INSERT INTO t1 VALUES(1)
|
|
mysqld-bin.000001 # Table_map 1 # table_id: # (test.t1)
|
|
mysqld-bin.000001 # Write_rows_v1 1 # table_id: # flags: STMT_END_F
|
|
mysqld-bin.000001 # Xid 1 # COMMIT /* xid= */
|
|
mysqld-bin.000001 # Gtid 1 # BEGIN GTID 0-1-3
|
|
mysqld-bin.000001 # Annotate_rows 1 # DELETE FROM t1 WHERE i = 1
|
|
mysqld-bin.000001 # Table_map 1 # table_id: # (test.t1)
|
|
mysqld-bin.000001 # Delete_rows_v1 1 # table_id: # flags: STMT_END_F
|
|
mysqld-bin.000001 # Xid 1 # COMMIT /* xid= */
|
|
mysqld-bin.000001 # Gtid 2 # BEGIN GTID 0-2-4
|
|
mysqld-bin.000001 # Annotate_rows 2 # INSERT INTO t1 VALUES(2)
|
|
mysqld-bin.000001 # Table_map 2 # table_id: # (test.t1)
|
|
mysqld-bin.000001 # Write_rows_v1 2 # table_id: # flags: STMT_END_F
|
|
mysqld-bin.000001 # Xid 2 # COMMIT /* xid= */
|
|
mysqld-bin.000001 # Gtid 2 # BEGIN GTID 0-2-5
|
|
mysqld-bin.000001 # Annotate_rows 2 # DELETE FROM t1 WHERE i = 2
|
|
mysqld-bin.000001 # Table_map 2 # table_id: # (test.t1)
|
|
mysqld-bin.000001 # Delete_rows_v1 2 # table_id: # flags: STMT_END_F
|
|
mysqld-bin.000001 # Xid 2 # COMMIT /* xid= */
|
|
# On node_2
|
|
connection node_2;
|
|
SHOW BINLOG EVENTS IN 'mysqld-bin.000001' FROM <start_pos>;
|
|
Log_name Pos Event_type Server_id End_log_pos Info
|
|
mysqld-bin.000001 # Gtid_list 2 # []
|
|
mysqld-bin.000001 # Binlog_checkpoint 2 # mysqld-bin.000001
|
|
mysqld-bin.000001 # Gtid 1 # GTID 0-1-1
|
|
mysqld-bin.000001 # Query 1 # use `test`; CREATE TABLE t1(i INT)ENGINE=INNODB
|
|
mysqld-bin.000001 # Gtid 1 # BEGIN GTID 0-1-2
|
|
mysqld-bin.000001 # Annotate_rows 1 # INSERT INTO t1 VALUES(1)
|
|
mysqld-bin.000001 # Table_map 1 # table_id: # (test.t1)
|
|
mysqld-bin.000001 # Write_rows_v1 1 # table_id: # flags: STMT_END_F
|
|
mysqld-bin.000001 # Xid 1 # COMMIT /* xid= */
|
|
mysqld-bin.000001 # Gtid 1 # BEGIN GTID 0-1-3
|
|
mysqld-bin.000001 # Annotate_rows 1 # DELETE FROM t1 WHERE i = 1
|
|
mysqld-bin.000001 # Table_map 1 # table_id: # (test.t1)
|
|
mysqld-bin.000001 # Delete_rows_v1 1 # table_id: # flags: STMT_END_F
|
|
mysqld-bin.000001 # Xid 1 # COMMIT /* xid= */
|
|
mysqld-bin.000001 # Gtid 2 # BEGIN GTID 0-2-4
|
|
mysqld-bin.000001 # Annotate_rows 2 # INSERT INTO t1 VALUES(2)
|
|
mysqld-bin.000001 # Table_map 2 # table_id: # (test.t1)
|
|
mysqld-bin.000001 # Write_rows_v1 2 # table_id: # flags: STMT_END_F
|
|
mysqld-bin.000001 # Xid 2 # COMMIT /* xid= */
|
|
mysqld-bin.000001 # Gtid 2 # BEGIN GTID 0-2-5
|
|
mysqld-bin.000001 # Annotate_rows 2 # DELETE FROM t1 WHERE i = 2
|
|
mysqld-bin.000001 # Table_map 2 # table_id: # (test.t1)
|
|
mysqld-bin.000001 # Delete_rows_v1 2 # table_id: # flags: STMT_END_F
|
|
mysqld-bin.000001 # Xid 2 # COMMIT /* xid= */
|
|
DROP TABLE t1;
|
|
# End of test
|