github / github/gh-ost

Alternative use of gh-ost : Resync slave tables

Open
#839 3 comments 3 reactions 0 assignees View on GitHub
documentation question
Dominant language
Go
Stars
13.6k
Forks
1.4k
Avg merge
2h 31m
Merged PRs (30d)
4

Description

Not really an issue, but rather another use of the tool that could be advertised in the documentation.

We have slaves that have discrepancies (missing rows, rows with some different values) as highlighted by a very long run of pt-table-checksum. We tried fixing these tables with pt-table-sync with no success.

By running gh-ost on a master using RBR (does not work with statement based replication) and doing a simple "engine=innodb", the whole table gets recreated with the data of the master thus fixing the differences that existed on the slave.

I think it's a nice usage of the tool that some other people could be made aware of (or maybe it is done already and I did not see it)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.