github / github/gh-ost

Using gh-ost for data migration (across database)?

Open
#816 1 comment 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

Thanks for reading, we are currently using gh-ost for schema change and we are wondering if gh-ost can be used for data migration?

Scenario:
TableA is on databaseA, we want to duplicate this table (100GB) onto databaseB, but not losing any updates along the duplication process. Table swapping is not needed and gh-ost's updates to new TableB should be terminated on command.

Question:
Can gh-ost do this, create a duplicated ghost table on another database?

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.