Done
Details
Details
Assignee
parveez.baig
parveez.baigReporter
Przemyslaw Malkowski
Przemyslaw MalkowskiPlanned Version/s
Needs QA
Yes
Sprint
Add sprint
Fix versions
Affects versions
Priority
MediumCreated October 4, 2023 at 2:10 PM
Updated November 7, 2024 at 12:54 PM
Resolved September 9, 2024 at 9:54 AM
The issue was discussed a long time ago in #PXC-1980.
However, the issue is breaking the solution of connecting two PXC clusters or simply having an async replica. We have functionality like:
https://docs.percona.com/percona-distribution-for-mysql/8.0/replication-manager/replication-manager-for-pxc.html
or
https://docs.percona.com/percona-operator-for-mysql/pxc/replication.html
which will not work as expected if RSU causes extra GTID sets to appear on single nodes.
In general, RSU mode is expected to NOT replicate anything, so IMHO, that should also apply to NOT bin-logging anything as well.
Currently, statements in RSU produce binlog events, which complicates things:
node2 [localhost:29335] {msandbox} ((none)) > select @@GLOBAL.gtid_executed\G *************************** 1. row *************************** @@GLOBAL.gtid_executed: 00ccb0de-6133-11ee-bc00-4bb5e7e3b356:1-40 1 row in set (0.00 sec) node2 [localhost:29335] {msandbox} ((none)) > set wsrep_osu_method='rsu'; Query OK, 0 rows affected (0.00 sec) node2 [localhost:29335] {msandbox} ((none)) > alter table test.t1 engine=innodb; Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 node2 [localhost:29335] {msandbox} ((none)) > select @@GLOBAL.gtid_executed\G *************************** 1. row *************************** @@GLOBAL.gtid_executed: 00ccb0de-6133-11ee-bc00-4bb5e7e3b356:1-40, 105db127-6133-11ee-920d-a27280225d74:1 1 row in set (0.00 sec) node2 [localhost:29335] {msandbox} ((none)) > show binlog events in 'mysql-bin.000006'; +------------------+-----+----------------+-----------+-------------+-------------------------------------------------------------------+ | Log_name | Pos | Event_type | Server_id | End_log_pos | Info | +------------------+-----+----------------+-----------+-------------+-------------------------------------------------------------------+ | mysql-bin.000006 | 4 | Format_desc | 29335 | 126 | Server ver: 8.0.33-25.1, Binlog ver: 4 | | mysql-bin.000006 | 126 | Previous_gtids | 29335 | 197 | 00ccb0de-6133-11ee-bc00-4bb5e7e3b356:1-40 | | mysql-bin.000006 | 197 | Gtid | 29335 | 274 | SET @@SESSION.GTID_NEXT= '105db127-6133-11ee-920d-a27280225d74:1' | | mysql-bin.000006 | 274 | Query | 29335 | 391 | alter table test.t1 engine=innodb /* xid=33 */ | +------------------+-----+----------------+-----------+-------------+-------------------------------------------------------------------+ 4 rows in set (0.00 sec)