In this post, We will learn how to handle online schema change if the table has triggers.
In PXC, an alter can be made directly ( TOI ) on tables with less than a 1G ( by default) , but on a 20GB or 200GB table we need some downtime to do ( RSU ).
Pt-osc is a good choice for Percona Cluster/Galera. By default percona toolkit’s pt-online-schema-change will create After “insert / update / delete” triggers for maintaining the sync between the shadow and the original table.
pt-online-schema-change process flow:
Check out the complete slides for effective MySQL administration here
If the tables has triggers already then pt-osc wont work well in …[Read more]