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
demandé il y a 3 ans659 vues
1 réponse
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.

répondu il y a 3 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions