Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Implement GTID based replication #1427

Open
altmannmarcelo opened this issue Feb 1, 2025 · 0 comments
Open

Implement GTID based replication #1427

altmannmarcelo opened this issue Feb 1, 2025 · 0 comments
Labels
Medium priority Created by Linear-GitHub Sync
Milestone

Comments

@altmannmarcelo
Copy link
Contributor

Description

When available we should be using GTID instead of Binary log file and position as it will make failover easier.
A few things to consider:

  • Since we have per table binlog position and we have selective table replication, we need to ensure that we don't create GTID gaps for events that we skip.
  • MySQL added support for GTID Tags, so the layout might look uuid:seq_id or uuid:tag:seq_id - we should be able to store both
  • MariaDB layout is also different, we should check if we can easily implement this and comply with both formats
  • Once this is done, we should register as a replica using auto_position=1 (GTID)

https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html

https://mariadb.com/kb/en/gtid/

Change in user-visible behavior

Requires documentation change

@altmannmarcelo altmannmarcelo added this to the v.63 milestone Feb 6, 2025
@altmannmarcelo altmannmarcelo added the Medium priority Created by Linear-GitHub Sync label Feb 6, 2025
@altmannmarcelo altmannmarcelo modified the milestones: v.63, v.64, v.65 Feb 10, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Medium priority Created by Linear-GitHub Sync
Projects
None yet
Development

No branches or pull requests

1 participant