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
질문됨 3년 전657회 조회
1개 답변
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.

답변함 3년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인