Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Roadmap: Integrate Percona Toolkit? #182

Open
ghost opened this issue May 22, 2018 · 1 comment
Open

Roadmap: Integrate Percona Toolkit? #182

ghost opened this issue May 22, 2018 · 1 comment

Comments

@ghost
Copy link

ghost commented May 22, 2018

I've been using RM for a couple years now, and I've got tables in production with millions of rows. Adding a column these days is downright painful just because it is slow and I think it locks the table.

Percona Toolkit (https://www.percona.com/doc/percona-toolkit/LATEST/pt-online-schema-change.html) can do online table alterations with a command line interface, but I like the way RM keeps track of migrations.

I wonder if there might be a way to hook the two up? I want to use RM for all migrations, but where there are super large tables, RM could use Percona?

@ruckus
Copy link
Owner

ruckus commented May 24, 2018

Wow that sounds pretty cool.

Ultimately sounds like it would be a pretty big job to transparently integrate with pt-online-schema-change .

I have not used this package in years and to be honest its kind of abandoned at this point. If I were to do something in PHP I would probably use Laravel which has its own migration infrastructure. I say all of this to essentially indicate that I'm not in a position to make major changes to this library, but if someone wants to pick up the mantle I'm more than happy to pass it on!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant