Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Statements executed in RSU mode generate local GTID events

Description

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:

 

 

Environment

None

AFFECTED CS IDs

CS0040074, CS0044922

blocks

Activity

Show:

Kamil Holubicki February 27, 2024 at 9:19 AM

Conclusions from THIS Slack conversation are:

  1. Do not generate binlog event, do not generate GTID

  2. Report DDL in full in the warning, such that we will be able to trace it and eventually apply on Replica sites. Or even automate that by scripting. Additionally, CLI should show the warning.

Done

Details

Assignee

Reporter

Planned Version/s

Needs QA

Yes

Sprint

Fix versions

Affects versions

Priority

Smart Checklist

Created October 4, 2023 at 2:10 PM
Updated November 7, 2024 at 12:54 PM
Resolved September 9, 2024 at 9:54 AM