Finding the Best Practices for long alter table queries

0

Hi,
With Aurora what is the best practices to perform long alter table operations without downtime?
Is there equivalent of pt-online-schema-change which can run alter table without locking ?

vhan
asked 3 years ago615 views
1 Answer
0

Sure, you could use percona tool for alter table.

you could find reference as below link.
https://medium.com/@soomiq/altering-large-mysql-table-using-percona-toolkit-on-aws-aurora-acb6e57a33d4

But I recommend that you could use gh-ost for that. it is trigger-less which I think much better than percona online schema change tool. I have tested and it works fine with aurora 5.6 & 5.7

https://github.com/github/gh-ost

Hope this could solve your problem.

answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions