connection node_2; connection node_1; CREATE TABLE t1 (f1 INT PRIMARY KEY); SET SESSION wsrep_trx_fragment_size=1; INSERT INTO t1 VALUES (1); connection node_2; SELECT COUNT(*) = 1 FROM t1; COUNT(*) = 1 1 SET SESSION wsrep_trx_fragment_size=1; UPDATE t1 SET f1 = 2; connection node_1; SET SESSION wsrep_trx_fragment_size=0; connection node_2; SET SESSION wsrep_trx_fragment_size=0; connection node_1; SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2; COUNT(*) = 1 1 SHOW BINLOG EVENTS IN 'mysqld-bin.000002' FROM 256; Log_name Pos Event_type Server_id End_log_pos Info mysqld-bin.000002 Gtid_list 1 [] mysqld-bin.000002 Binlog_checkpoint 1 mysqld-bin.000001 mysqld-bin.000002 Binlog_checkpoint 1 mysqld-bin.000002 mysqld-bin.000002 Gtid 1 GTID 0-1-1 mysqld-bin.000002 Query 1 use `test`; CREATE TABLE t1 (f1 INT PRIMARY KEY) mysqld-bin.000002 Gtid 1 BEGIN GTID 0-1-2 mysqld-bin.000002 Annotate_rows 1 INSERT INTO t1 VALUES (1) mysqld-bin.000002 Table_map 1 table_id: ### (test.t1) mysqld-bin.000002 Write_rows_v1 1 table_id: ### flags: STMT_END_F mysqld-bin.000002 Xid 1 COMMIT /* xid=### */ mysqld-bin.000002 Gtid 2 BEGIN GTID 0-2-3 mysqld-bin.000002 Annotate_rows 2 UPDATE t1 SET f1 = 2 mysqld-bin.000002 Table_map 2 table_id: ### (test.t1) mysqld-bin.000002 Update_rows_v1 2 table_id: ### flags: STMT_END_F mysqld-bin.000002 Xid 2 COMMIT /* xid=### */ connection node_2; SELECT 1 FROM DUAL; 1 1 SHOW BINLOG EVENTS IN 'mysqld-bin.000003' FROM 256; Log_name Pos Event_type Server_id End_log_pos Info mysqld-bin.000003 Gtid_list 2 [] mysqld-bin.000003 Binlog_checkpoint 2 mysqld-bin.000003 mysqld-bin.000003 Gtid 1 GTID 0-1-1 mysqld-bin.000003 Query 1 use `test`; CREATE TABLE t1 (f1 INT PRIMARY KEY) mysqld-bin.000003 Gtid 1 BEGIN GTID 0-1-2 mysqld-bin.000003 Annotate_rows 1 INSERT INTO t1 VALUES (1) mysqld-bin.000003 Table_map 1 table_id: ### (test.t1) mysqld-bin.000003 Write_rows_v1 1 table_id: ### flags: STMT_END_F mysqld-bin.000003 Xid 1 COMMIT /* xid=### */ mysqld-bin.000003 Gtid 2 BEGIN GTID 0-2-3 mysqld-bin.000003 Annotate_rows 2 UPDATE t1 SET f1 = 2 mysqld-bin.000003 Table_map 2 table_id: ### (test.t1) mysqld-bin.000003 Update_rows_v1 2 table_id: ### flags: STMT_END_F mysqld-bin.000003 Xid 2 COMMIT /* xid=### */ DROP TABLE t1;