TaskMax limit affects MySQL connections

Recently we had been bitten by a Systemd limitation at the “Tasks” created per-unit ie., process. This includes both the kernel threads and user-space threads, with each thread counting individually. Am writing this blog as a reference for someone who might come across this limitation. We have been actively working on migration DB instances, from … Continue reading TaskMax limit affects MySQL connections

Advertisements

Innotop – A Monitoring tool for MySQL

Monitoring MySQL server has never been an easy task. Monitoring also needs to go through many Complex and difficult queries to get the details. All these problems can be overcome by an excellent command line monitoring tool  called “Innotop”. Innotop comes with many features and different types of modes/options, which helps to monitor different aspects … Continue reading Innotop – A Monitoring tool for MySQL

Chose right SST method MariaDB Cluster 10.2

                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

Impact of “tmpdir” change in MySQL replication

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

How to Switch Replica Master of a non-GTID Slave in Percona Cluster ?

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 - 172.10.2.11Node2 - 172.10.2.12Node3 - 172.10.2.13Replica - 172.10.2.14 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 ?

Configuring efficient MySQL Logrotate

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

Will IO Size Affect your RDS Performance?​

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?​

Database Objects migration to RDS/ Aurora (AWS)

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)

ProxySQL Series: Handling resource expensive(bad) Queries in MySQL

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

Presentation : MySQL Timeout Variables Explained

MySQL has multiple timeout variables these slides helps to give an overview of the different  timeout variables and their purposes briefly.