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. Image Courtesy : Photo by Andrew Ruiz on Unsplash
This presentation was made at LSPE event in Bangalore (India) held at Walmart labs on 10-03-2018. This presentation focuses how we have harnessed the power of Ansible at Mydbops.
This presentation is about Galera. Galera is a synchronous high availability clustering solution designed for MySQL. At MyDBOPS we have customers on Galera. They depend on the Galera for their business high availability and read scaling. Handling and troubleshooting a Galera cluster needs more expertise. This presentation is a walk through on Galera Cluster with … Continue reading Galera Cluster a Walk through ( Presentation)
MySQL Enterprise Backup (MEB) is a high performance hot backup tool. It is a stable tool and evolved with changes in IT industry. The recent versions has support to direct cloud backup in S3. It is an enterprise backup tool from Oracle MySQL and integrated quite well with MEM ( MySQL Enterprise Monitor ). This … Continue reading MySQL Enterprise Backup ( MEB)
Presentation on MySQL Sys Schema in MySQL 5.7. Sys Schema views can help in better monitoring and understanding the MySQL resource consumption at various levels.