DC1-2(root@localhost) [test]>show binlog events in "binlog.000040"; +---------------+-----+----------------+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Log_name | Pos | Event_type | Server_id | End_log_pos | Info | +---------------+-----+----------------+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | binlog.000040 | 4 | Format_desc | 3306 | 126 | Server ver: 8.0.29-21.1, Binlog ver: 4 | | binlog.000040 | 126 | Previous_gtids | 3306 | 373 | 25849473-611b-11ee-a815-1e6eed6a032d:1-3, 99f0b6e2-8b37-11eb-b340-08002734ed50:1, 9fc92088-1d55-11ec-a866-08002734ed50:1-15, ab5deb8e-389d-11eb-b1c0-36eca47bacf0:1-5216405:5216415-5216648, dc20eb8e-389d-11eb-b1c0-36eca47bacf0:1-2 | +---------------+-----+----------------+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) DC1-2(root@localhost) [test]>select * from a; Empty set (0.00 sec) DC1-2(root@localhost) [test]> DC1-3(root@localhost) [(none)]>show binlog events in "binlog.000044"; +---------------+-----+----------------+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Log_name | Pos | Event_type | Server_id | End_log_pos | Info | +---------------+-----+----------------+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | binlog.000044 | 4 | Format_desc | 3306 | 126 | Server ver: 8.0.29-21.1, Binlog ver: 4 | | binlog.000044 | 126 | Previous_gtids | 3306 | 373 | 25849473-611b-11ee-a815-1e6eed6a032d:1-3, 99f0b6e2-8b37-11eb-b340-08002734ed50:1, 9fc92088-1d55-11ec-a866-08002734ed50:1-15, ab5deb8e-389d-11eb-b1c0-36eca47bacf0:1-5216405:5216415-5216648, dc20eb8e-389d-11eb-b1c0-36eca47bacf0:1-2 | +---------------+-----+----------------+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) DC1-3(root@localhost) [(none)]> DC1-3(root@localhost) [test]>select * from a; Empty set (0.00 sec) DC1-3(root@localhost) [test]> Now let us insert 1 row with all nodes NOT desync: DC1-2(root@localhost) [test]>insert into a values(null,"all node are sync",now()); Query OK, 1 row affected, 1 warning (0.00 sec) DC1-2(root@localhost) [test]>select * from a; +---+-------------------+------------+ | a | b | c | +---+-------------------+------------+ | 1 | all node are sync | 2023-11-14 | +---+-------------------+------------+ 1 row in set (0.00 sec) DC1-2(root@localhost) [test]> ON THE OTHER PXC NODE: DC1-3(root@localhost) [test]>select * from a; +---+-------------------+------------+ | a | b | c | +---+-------------------+------------+ | 1 | all node are sync | 2023-11-14 | +---+-------------------+------------+ 1 row in set (0.01 sec) DC1-3(root@localhost) [test]> NOW let us desync the node DC1-3: DC1-3(root@localhost) [test]>set global wsrep_desync=1;show global variables like 'wsrep_desync'; Query OK, 0 rows affected, 1 warning (0.00 sec) +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wsrep_desync | ON | +---------------+-------+ 1 row in set (0.00 sec) DC1-3(root@localhost) [test]> NOW LET INSERT ANOTER ROW in DC1-2 DC1-2(root@localhost) [test]>insert into a values(null,"Node DC1-3 is desync",now()); Query OK, 1 row affected, 1 warning (0.01 sec) DC1-2(root@localhost) [test]>show binlog events in "binlog.000040"; +---------------+-----+----------------+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Log_name | Pos | Event_type | Server_id | End_log_pos | Info | +---------------+-----+----------------+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | binlog.000040 | 4 | Format_desc | 3306 | 126 | Server ver: 8.0.29-21.1, Binlog ver: 4 | | binlog.000040 | 126 | Previous_gtids | 3306 | 373 | 25849473-611b-11ee-a815-1e6eed6a032d:1-3, 99f0b6e2-8b37-11eb-b340-08002734ed50:1, 9fc92088-1d55-11ec-a866-08002734ed50:1-15, ab5deb8e-389d-11eb-b1c0-36eca47bacf0:1-5216405:5216415-5216648, dc20eb8e-389d-11eb-b1c0-36eca47bacf0:1-2 | | binlog.000040 | 373 | Gtid | 3306 | 452 | SET @@SESSION.GTID_NEXT= '25849473-611b-11ee-a815-1e6eed6a032d:4' | | binlog.000040 | 452 | Query | 3306 | 540 | BEGIN | | binlog.000040 | 540 | Table_map | 3306 | 595 | table_id: 114 (test.a) | | binlog.000040 | 595 | Write_rows | 3306 | 657 | table_id: 114 flags: STMT_END_F | | binlog.000040 | 657 | Xid | 3306 | 688 | COMMIT /* xid=12 */ | | binlog.000040 | 688 | Gtid | 3306 | 767 | SET @@SESSION.GTID_NEXT= '25849473-611b-11ee-a815-1e6eed6a032d:5' | | binlog.000040 | 767 | Query | 3306 | 855 | BEGIN | | binlog.000040 | 855 | Table_map | 3306 | 910 | table_id: 114 (test.a) | | binlog.000040 | 910 | Write_rows | 3306 | 975 | table_id: 114 flags: STMT_END_F | | binlog.000040 | 975 | Xid | 3306 | 1006 | COMMIT /* xid=13 */ | +---------------+-----+----------------+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 12 rows in set (0.00 sec) DC1-2(root@localhost) [test]>select * from a; +---+----------------------+------------+ | a | b | c | +---+----------------------+------------+ | 1 | all node are sync | 2023-11-14 | | 4 | Node DC1-3 is desync | 2023-11-14 | +---+----------------------+------------+ 2 rows in set (0.00 sec) Let us check what happened in DC1-3: DC1-3(root@localhost) [test]>show binlog events in "binlog.000044"; +---------------+-----+----------------+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Log_name | Pos | Event_type | Server_id | End_log_pos | Info | +---------------+-----+----------------+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | binlog.000044 | 4 | Format_desc | 3306 | 126 | Server ver: 8.0.29-21.1, Binlog ver: 4 | | binlog.000044 | 126 | Previous_gtids | 3306 | 373 | 25849473-611b-11ee-a815-1e6eed6a032d:1-3, 99f0b6e2-8b37-11eb-b340-08002734ed50:1, 9fc92088-1d55-11ec-a866-08002734ed50:1-15, ab5deb8e-389d-11eb-b1c0-36eca47bacf0:1-5216405:5216415-5216648, dc20eb8e-389d-11eb-b1c0-36eca47bacf0:1-2 | | binlog.000044 | 373 | Gtid | 3306 | 452 | SET @@SESSION.GTID_NEXT= '25849473-611b-11ee-a815-1e6eed6a032d:4' | | binlog.000044 | 452 | Query | 3306 | 527 | BEGIN | | binlog.000044 | 527 | Table_map | 3306 | 582 | table_id: 103 (test.a) | | binlog.000044 | 582 | Write_rows | 3306 | 644 | table_id: 103 flags: STMT_END_F | | binlog.000044 | 644 | Xid | 3306 | 675 | COMMIT /* xid=12 */ | | binlog.000044 | 675 | Gtid | 3306 | 754 | SET @@SESSION.GTID_NEXT= '25849473-611b-11ee-a815-1e6eed6a032d:5' | | binlog.000044 | 754 | Query | 3306 | 829 | BEGIN | | binlog.000044 | 829 | Table_map | 3306 | 884 | table_id: 103 (test.a) | | binlog.000044 | 884 | Write_rows | 3306 | 949 | table_id: 103 flags: STMT_END_F | | binlog.000044 | 949 | Xid | 3306 | 980 | COMMIT /* xid=13 */ | +---------------+-----+----------------+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 12 rows in set (0.00 sec) DC1-3(root@localhost) [test]>select * from a; +---+----------------------+------------+ | a | b | c | +---+----------------------+------------+ | 1 | all node are sync | 2023-11-14 | | 4 | Node DC1-3 is desync | 2023-11-14 | +---+----------------------+------------+ 2 rows in set (0.01 sec) DC1-3(root@localhost) [test]> So all transactions are passed and pushed to binllog.