The Wayback Machine - https://web.archive.org/web/20201121010349/https://github.com/github/gh-ost/issues/812
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

[Question] strategy for multiple table alters #812

Open
mike-code opened this issue Dec 27, 2019 · 1 comment
Open

[Question] strategy for multiple table alters #812

mike-code opened this issue Dec 27, 2019 · 1 comment
Labels

Comments

@mike-code
Copy link

@mike-code mike-code commented Dec 27, 2019

Imagine the migration alters two tables, but if I read the doc correctly gh-ost supports single table alteration. I understand that there's no "good way" of handling this kind of situation because even if you run migrations simultaneously (two instances of gh-ost), at some point you'll end up having one table migrated while the other one still in migration.

Do I assume correctly that the only right way here is just not allowing such migrations in the first place if you care about zero downtime?

@tomkrouper
Copy link
Contributor

@tomkrouper tomkrouper commented Dec 27, 2019

Can you give more details? In our situation we tend to run migrations that are backwards compatible. If two tables need to be altered to make something work, we might migrate table 1, then table 2. After that developers would make changes to the code and If necessary, we'd migrate table 1 or 2 a second time to complete the process.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
3 participants
You can’t perform that action at this time.