github / github/gh-ost

Question: Why Is the "Connect to Replica" mode preferred?

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

Description

Hi,

Sorry if there's an obvious answer, but why is the preferred mode to connect to the replica? I couldn't see in the [Docs](https://github.com/github/gh-ost/blob/master/doc/cheatsheet.md) the exact reason for it, but it would be helpful to determine which mode we should use in our environment.

For us, we are able to use both methods. But not all of our systems have the proper configuration for ghost (log_bin, log_slave_updates, binlog_format).

While we could schedule a maintenance window to make those changes, I'm wondering what would we lose out of we just ran from the master.

Thanks!
-w

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.