Add support to replication aligned consistent snapshot for pt-table-sync

Description

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.

Environment

None

Attachments

1

Activity

Show:

Sveta Smirnova April 5, 2023 at 5:09 PM

Thank you for the feature request ad attached patch.

Details

Assignee

Reporter

Priority

Components

Fix versions

Needs QA

Yes

Smart Checklist

Created April 5, 2023 at 4:16 PM
Updated September 23, 2024 at 10:51 AM