Skip to content
This repository has been archived by the owner on Aug 21, 2023. It is now read-only.

Reduce the time dumpling holds the FTWRL lock #118

Closed
lichunzhu opened this issue Jul 9, 2020 · 0 comments · Fixed by #121
Closed

Reduce the time dumpling holds the FTWRL lock #118

lichunzhu opened this issue Jul 9, 2020 · 0 comments · Fixed by #121
Labels
priority/P1 High priority issue

Comments

@lichunzhu
Copy link
Contributor

Feature Request

Is your feature request related to a problem? Please describe:

When dumpling MySQL, dumpling will use FTWRL to lock all the tables and release the lock after all tables have been dumped which will strongly affect the MySQL server.

Describe the feature you'd like:

In mydumper, they use a special way to confirm consistency and "lock time". The solution is: FTWRL -> start THREADS*transactions(WITH CONSISTENT SNAPSHOT) -> UNLOCK TABLES -> dump data
I think we can also do this in dumpling.

Describe alternatives you've considered:

Teachability, Documentation, Adoption, Optimization:

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
priority/P1 High priority issue
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant