MySQL 8.0 has come with a list of new features for DBA's ,we will discuss the new feature in MySQL 8.0 which supports Descending index.Prior to MySQL 8.0 (i.e MySQL 5.6 and 5.7) creating desc index syntax was supported but desc keyword was ignored, Now in MySQL 8.0 release descending index is extended are supported. … Continue reading Descending index in MySQL 8.0
This is the 5th blog in series of Maxscale blog, Below is the list of our previous blogs, Which provides deep insight for Maxscale and its use cases for different architectures. Scale with Maxscale part -1 (Intro & Galera Cluster) Scale with Maxscale part - 2 (Administration, Installation & operation) Scale with Maxscale part - … Continue reading Scale-with-Maxscale-part5 (Multi-Master)
As Mydbops we have consulted many large scale MySQL deployments. This presentation is about one of our customer who is one of the largest retailer in North America. This is about their data migration to InnoDB Cluster ( MySQL ) from an enterprise database.
In this blog, we will see the very basic thing "I" of "ACID" and an important property of Transaction ie., "ISOLATION" The isolation defines the way in which the MySQL server (InnoDB) separates each transaction from other concurrent running transaction in the server and also ensures that the transactions are processed in a reliable way. If transactions … Continue reading Back to basics: Isolation Levels In MySQL
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