Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Run gh-ost on master, replica, or neither? #1476

Open
joshlawrence opened this issue Dec 10, 2024 · 1 comment
Open

Run gh-ost on master, replica, or neither? #1476

joshlawrence opened this issue Dec 10, 2024 · 1 comment

Comments

@joshlawrence
Copy link

Hello!

I am new to gh-ost, but familiar with pt-online-schema-change. Normally, I would run pt-osc on a master server, so I assumed that gh-ost would be the same. But in looking at gh-ost's doc, it appears that I should run it not on the master or the replica, but on my client machine that is able to connect to both my master and replica. Is this correct?

Apologies for what I'm sure is a dumb question, but I wanted to confirm.

Thanks!

@susanzhang27
Copy link

👋 Running gh-ost on replica is the preferred method as to reduce the extra load on the master. You can run gh-ost on the primary as long as you don't write to it also. More information on the different use cases can be found here

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants