github / github/gh-ost

Is it bad practice to run gh-ost on a replica?

Open
#554 2 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,

I was having this discussion with someone from our SRE team who believe gh-ost should not be running on one of the replicas in our mysql cluster. But after searching around I couldn't find any explicit guidance on that.

I thought running gh-ost on the replica that's also generating the RBR replication log that gh-ost is tracking would skip a network hop and get the replication data to the gh-ost even faster. Further more, this is a replica that's not taking production traffic normally (it's our fallback read-only replica).

Is there any additional requirement we should know about to decide whether to run gh-ost on a replica or not other than the common-sense load/resource sharing considerations?

Thanks for open-sourcing gh-ost. We've been liking the tool a lot! :-)

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.