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

[Improvement] Support CompressGtidSet when lastseenGtid exceeds special length #127

Open
gerayking opened this issue Jun 12, 2023 · 0 comments
Assignees
Labels
enhancement New feature or request low-priority

Comments

@gerayking
Copy link
Contributor

To ensure Read-After-Write (RAW) consistency, vtgate internally maintains lastseengtid, which verifies that MySQL has executed the corresponding Data Manipulation Language (DML). However, the length of lastseengtid tends to increment continuously, thus necessitating the design of the CompressGtidset mechanism to prevent lastseengtid from becoming excessively long.

Currently, the CompressGtidset function is invoked passively through the broadcast protocol of the health check system. During instances of high concurrency, the length of lastseengtid may surge abruptly. Refer to the following links for additional information on RAW and CompressGtidSet.

Moving forward, the goal is to facilitate active data collection of the MySQL instance status and invoke CompressGtidset whenever the length of lastseengtid crosses a certain threshold.

@earayu earayu added enhancement New feature or request low-priority labels Jun 12, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request low-priority
Projects
None yet
Development

No branches or pull requests

2 participants