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 is our fourth blog in the ProxySQL Series MySQL Replication Read-write Split up Seamless Replication Switchover Using MHA Mirroring MySQL Queries This blog focuses on how to quickly find and address badly written queries using ProxySQL without any downtime and change in application code. When we get an incident about the high usage on … Continue reading ProxySQL Series: Handling resource expensive(bad) Queries in MySQL
We have seen with most of the consulting projects where the customer might be having a dedicated DB (MySQL) server ,but running with a default configuration, without any optimisation for underlying hardware, "An idle hardware is similar to idle money will give you no returns". Well again if you are from a non-DBA background and you … Continue reading Ensure better defaults with InnoDB Dedicated server.
MySQL has multiple timeout variables these slides helps to give an overview of the different timeout variables and their purposes briefly.
Encryption is a very important form of security and It's becoming a standard from a compliance perspective to ensure PCI, PII and HIPPA compliances. Encryption needs to be performed for Data at Rest, Data over Wire. Data At Rest: Until 5.6, To encrypt the MySQL data files, Only disk level encryption possible (Gazzang, Luks) From … Continue reading Fulfilled Tablespace Encryption (TDE) in Percona Cluster
Root conf is a community and conference on DevOps and cloud infrastructure. Root conf is one of the India's well known conference on DevOPS and IT infrastructure. It is organised by Hasgeek. This year (2018) it is scheduled at 10-May & 11-May Mydbops is one of the Exhibition Sponsor along with companies like MySQL , … Continue reading Mydbops Delighted to be part of Root Conf 2018
MySQL is the most widely used Relational Database Management System in the open source world. MySQL stepped into the NoSQL world by introducing the JSON Data Type in MySQL 5.7 release. In this blog post I am going to explain one of the major advantage of optimisation made in JSON … Continue reading Partial (Optimised) JSON updates and Replication in MySQL 8.0