The schema changes in production can cause lock at time and makes the slave to lag. It is more tedious and troublesome with PXC ( Galera ) cluster which can be made smoother with Percona online schema change.
Published by Vinoth Kanna
Vinoth Kanna is the co-founder of Mydbops IT Solutions. Founded in 2015, HQ in Bangalore India with 150+ customer base across the globe. Mydbops is on Database Consulting with core specialisation on MySQL and MongoDB Administration and Support. Mydbops have experts team of certified DBA’s providing full time support and currently managing 300+ servers on cloud. Mydbops helps organisations to architect and scale systems in MySQL/Mongo by implementing the advanced technologies in industry which are completely open source. We are the leading solution provider in the market for all sort of cloud based deployments and management. https://www.linkedin.com/in/vinothkanna18/ View all posts by Vinoth Kanna