github / github/gh-ost

enable gh-ost checking the binlog format in real time (enhancement)

Open
#854 1 comment 0 reactions 0 assignees View on GitHub
enhancement
Dominant language
Go
Stars
13.6k
Forks
1.4k
Avg merge
2h 31m
Merged PRs (30d)
4

Description

As we all know that if the binlog format was changed to statement or mixed on slave( where gh-ost get binlog from, master 's binlog is mixed) when gh-ost is running , some data maybe lose.
In our company(Baidu.com), We want to avoid any risk of losing data when doing ddl on big tables. So we add binlog format checking logic to gh-ost.

### The checking logic

We check every query event in the binlog stream , if the content in that event was a delete/insert/update/replace statement , we will issue an error and let gh-ost exit itself.

### We want give the pr to gh-ost to make it more safety to do ddl
This is ours test

![621ba57625238346791a5bed467e181b](https://user-images.githubusercontent.com/5636356/89854234-f1345380-dbc5-11ea-9f5d-629377ab2e67.jpeg)

> Thanks

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.