github / gh-ost

GitHub's Online Schema-migration Tool for MySQL
MIT License
12.11k stars 1.23k forks source link

Does gh-ost support distributed databases? #1390

Closed iwanghc closed 3 months ago

iwanghc commented 3 months ago

For example GoldenDB, it is based on mysql, but the table creation syntax is different.

timvaillancourt commented 3 months ago

@iwanghc for the simplified answer is no. gh-ost only knows what plain MySQL is.

The more complicated answer is: there are cases where gh-ost has been successfully used on distributed MySQL-based databases, such as Vitess. gh-ost is able to work on Vitess because its shards still run plain MySQL, so gh-ost doesn't really "know" Vitess is there. For many other MySQL-compatible databases this assumption probably will not hold true, however

iwanghc commented 3 months ago

Thanks!