github / github/gh-ost

support create-table flag for simplified gh-ost migration

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

Description

### 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.

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.