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

support create-table flag for simplified gh-ost migration #1384

Open
najisawas opened this issue Mar 2, 2024 · 0 comments
Open

support create-table flag for simplified gh-ost migration #1384

najisawas opened this issue Mar 2, 2024 · 0 comments

Comments

@najisawas
Copy link

najisawas commented Mar 2, 2024

Enhancement

gh-ost currently only allows providing ALTER statements. It would be helpful if we can directly define the goal-state table rather than the list of ALTER statements needed to achieve it.

This is especially helpful for platform products where there are implementation details that may need to change across the entire platform. Instead of needing to determine the sequence of ALTERs for every change, one can simply provide the new table definition and have gh-ost use it in CreateGhostTable.

It would be the caller's responsibility to ensure that the table definition is compatible with backfilling and cutting over. gh-ost would continue doing simple internal validations similar to the ALTER flow.

@najisawas najisawas changed the title support running multiple ALTER statements atomically support create-table flag for simplified gh-ost migration Mar 5, 2024
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

1 participant