search

square / shift

shift is an application that helps you run schema migrations on MySQL databases
Apache License 2.0
738 stars 52 forks source link

support gh-ost #43

Open allixsenos opened 7 years ago

allixsenos commented 7 years ago

gh-ost seems to be a better solution than pt-online-schema, it'd be amazing if it were available as an option

michaelfinch commented 7 years ago

Agreed. We plan to add gh-ost integration and let you choose between using that and pt-osc. I'm hoping to have that done by the end of this year.

ramkireddy commented 7 years ago

Hi, In your blog post on shift (https://medium.com/square-corner-blog/shift-safe-and-easy-database-migrations-42108ee216f#.yt6jep9x1) you mentioned about following future enhancements, do you have any integration in-place to work with flyway or liquibase database migration tools? Would be interested to know if you have made any progress on this front.

"we plan to build into it in the near future to make it more robust, one example being to make it easier to integrate with developer workflows (ex: direct integration with ActiveRecord)"

Thanks, Ramki

michaelfinch commented 7 years ago

Hey @ramkireddy, haven't made much progress on that front unfortunately.

Regarding gh-ost: I have begun the work to integrate it, but still need to find time to push that to completion. I'll post an update about that here when I have one

dba1307 commented 7 years ago

Hi, Does shift take care of replication lag same like ghost or not.

michaelfinch commented 7 years ago

Shift uses pt-online-schema-change, which will monitor slave lag for you (https://www.percona.com/doc/percona-toolkit/2.1/pt-online-schema-change.html#cmdoption-pt-online-schema-change--max-lag)

gilahacker commented 7 years ago

Just throwing out a +1 for gh-ost support. Shift looks fantastic, but our devs have made extensive use of triggers, so pt-osc is sadly not an option for us.

rbroemeling commented 6 years ago

@michaelfinch Just as a quick query -- has any progress been made on using gh-ost instead of pt-online-schema-change? Thanks!

michaelfinch commented 6 years ago

Unfortunately it has not. It's still on my team's roadmap at Square, but it keeps getting punted on in favor of higher-priority work.

mailankitkm commented 5 years ago

@michaelfinch We are waiting for gh-ost support in shift. shift is very useful tool to put a process around schema changes. Please push gh-ost support. Thanks.