In this blog post, I am going to explain an interesting issue which I faced in one of our client project . Few weeks back , I got an requirement from our support client to construct a new MariaDB Galera Cluster ( 10.2.21 ) and an async … Continue reading Chose right SST method MariaDB Cluster 10.2
Recently we had encountered a strange issue with replication and temp directory(tmpdir) change while working for one major client. All the servers under this were running with Percona flavor of MySQL versioned 5.6.38 hosted on a Debian 8(Jessie) The MySQL architecture setup is as follows one master with 5 direct slaves under it Through this … Continue reading Impact of “tmpdir” change in MySQL replication
Introduction - Recently i worked on a production issue for one of our client under support .They have a architecture of a three node Galera cluster with one asynchronous slave . Node1 - 18.104.22.168Node2 - 22.214.171.124Node3 - 126.96.36.199Replica - 188.8.131.52 Architecture - The slave(replica) was configured with node3 as replica master. Unfortunately the node 3 was … Continue reading How to Switch Replica Master of a non-GTID Slave in Percona Cluster ?
I am a Junior DBA at Mydbops. This is my first blog professionally, I would like to brief my encounter with Log-rotate in first few weeks of my work, Hope it will help other beginners as well. This Blog will cover the following sections. Introduction to Log-rotate Issues FacedSolutions (Fix for the above issues)Best practicesHow … Continue reading Configuring efficient MySQL Logrotate
During our recent consulting with one of our client, We came across an interesting issue on RDS. The baseline is that "Low IO size on your RDS instance can affect your DB performance". Yes, It’s IO size, Not IOPS. We had our production systems running on RDS MySQL with a single master, 3 replicas. All … Continue reading Will IO Size Affect your RDS Performance?
The world of application and its related services are migrating more towards cloud, because of availability, Elasticity, Manageability etc. While moving the entire stack we need to be very cautious while migrating the database part. Migration of DB servers is not a simple lift and shift operation, Rather it would require a proper planning and … Continue reading Database Objects migration to RDS/ Aurora (AWS)
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
MySQL has multiple timeout variables these slides helps to give an overview of the different timeout variables and their purposes briefly.
In this blog post, We will be explaining about the timeouts in SST on systemd implementation which we faced recently in Percona XtraDB Cluster during our Consulting with a client. State Snapshot Transfers (SST) refers to complete data sync from one of the nodes from the cluster to the joining node. SST will happen for one or … Continue reading Handling long duration SST(timeout) in PXC with systemd
I was involved in one of the development support for MySQL. Here is an interesting case The application needs a Sequence generator as it was not present inbuilt with MySQL ( MariaDB will have it in 10.3 ) they have made sequence generator function with 'select for update' statement. But it tends to cause more locking … Continue reading Investigating a MySQL dead lock