Details
Assignee
UnassignedUnassignedReporter
Yves TrudeauYves Trudeau(Deactivated)Priority
MediumComponents
Fix versions
Labels
Needs QA
Yes
Details
Details
Assignee
Unassigned
UnassignedReporter
Yves Trudeau
Yves Trudeau(Deactivated)Priority
Components
Fix versions
Labels
Needs QA
Yes
Smart Checklist
Smart Checklist
Smart Checklist
Created April 5, 2023 at 4:16 PM
Updated September 23, 2024 at 10:51 AM
Storage engines like Myrocks do not support gap locks and thus cannot use SBR and pt-table-checksum. In order to compare tables between 2 servers with a direct replication link, we can use replication aligned consistent snapshot. This modified script has a new switch, "--repl-snapshot" that goes through the steps of establishing a replication aligned consistent snapshot between a source and a replica. It has been tested successfully on 8.0.31. A typical invocation would be:
The first DSN is the source and the 2nd the replica.