Thank you for such an amazing tool

[victor-ponamariov]

I cannot imagine it's not popular. People don't have big databases or what?
I understand that I can use percons/gh-ost tools directly, but then I won't be able to write laravel's migration.

Currently I have like a 5 millions db, and it takes 30 minutes to migrate.

So far works good!

[Daursu]

Thanks! I'm glad to hear that it works well for your use-case. It's true that you can use the tools directly, but I've designed this package to integrate seamlessly with Laravel's existing migrations, without having to learn new commands or change the existing deployment flow.

[erichowey]

I've also come to thank you for making this. I cannot believe this library isn't more popular.

[florianoversmake]

bump.

I just realized that the last time I've checked this repository was more than 2 years ago.

First of all, really great package, I don't understand why it's not more popular.
I guess most people are using AWS or SaaS like Planetscale for this?
Or they just don't mind hours of downtime :D

I was very sceptical about running and orchestrating long-running processes from within PHP, but the whole thing works like a charm for more than 2 years, for us, now.

We use gh-ost, to migrate our production databases, and perform schema changes on multiple tables with > 70M rows, in a single migration, under heavy read/write traffic and complex replication topologies without any downtime.

Since gh-ost 1.1.6 the --attempt-instant-ddl option is available, which makes the whole process even faster and less intrusive most of the time !

https://dev.mysql.com/doc/refman/9.0/en/innodb-online-ddl-operations.html

It's nerve-wracking the first few times, but once you get used to it and build CI around it, it gets a real game-changer.

This is our current approach, which is painful to set-up I think:
https://github.com/smakecloud/skeema