Automate MySQL 8.0 Installation with Ansible

Introduction : Ansible is an open-source IT automation engine which can remove drudgery from your work life, and will also dramatically improve the scalability, consistency, and reliability of your IT environment. Nowadays without automation to manage the Databases is very tricky. We are using Ansible as an infra automation tool to install, configure and manage … Continue reading Automate MySQL 8.0 Installation with Ansible

Advertisements

MySQL Partition pruning Explained

Partitioning is a process in which a single larger table is split into several smaller tables (physically) and still considered as a single table.It is generally a good idea for the tables whose size is in a few 100 GB's. While performing select,update,delete operations in a partitioned tables, we can notice a better performance in … Continue reading MySQL Partition pruning Explained

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

ProxySQL Series : Query Cache with ProxySQL

We know that MySQL query cache is deprecated as of MySQL 5.7.20 and removed in MySQL 8.0 and It has been recommended to use ProxySQL (or other) external query cache instead. In this blog post, we’ll present the ProxySQL query cache functionality and how does it help us. How to setup ProxySQL between client and database … Continue reading ProxySQL Series : Query Cache with ProxySQL

Common Table Expression (CTE) MySQL 8.0.

1.0. Introduction: MySQL 8.0 was released with awesome features. One of its most prominent features is CTE (Common Table Expression). The Common Table Expression can be used to construct complex queries in a more readable manner. In this blog, I have described how the CTE works with some useful examples. 1.1 What is CTE? A Common … Continue reading Common Table Expression (CTE) MySQL 8.0.

ProxySQL Series:​ Amazon Aurora (RDS) Read-Write Split.

In this blog we are going to see how to implement Proxysql for Amazon Aurora RDS, this would be next in series of ProxySQL blogs. Below is the list of our previous blogs on ProxySQL which provides deeper insights based on different use cases and different architecture. MySQL replication Read-Write Split up Replication Switchover using … Continue reading ProxySQL Series:​ Amazon Aurora (RDS) Read-Write Split.

Migrate MySQL data to RDS/Aurora Using Xtrabackup

In this blog, I will provide a step by step procedure to migrate from on-premise MySQL to Amazon RDS/Aurora using Percona-xtrabackup Both RDS and Aurora is a DBAAS provided by Amazon. To know more on DBAAS you can view our presentation here. When you are having a database in size of few GB, it would … Continue reading Migrate MySQL data to RDS/Aurora Using Xtrabackup

MySQL Partition Manager (Yahoo!) in a nutshell

Partitioning is a way of splitting the actual data down into separate .ibd files (data compartments) in the file system based on the defined ranges using the partitioning key. It can help us with maintaining the enormous amount of data in different partitions without much hassle. In this blog post, we are going to see how … Continue reading MySQL Partition Manager (Yahoo!) in a nutshell

Delayed Replication with Amazon RDS

"Delayed replication" is one of the important features which were being supported in MySQL from 5.6 for a very long time. This induces an intentional lag in the slave, making it lag by the defined time interval. For a long time this was not available with the RDS version of MySQL provided by AWS, Recently … Continue reading Delayed Replication with Amazon RDS

GH-OST for MySQL Schema Change.

Schema change is one of the crucial tasks in MySQL with huge tables. Schema change can cause locks. What is gh-ost?                          gh-ost is a triggerless online schema change for MySQL by Github Engineering .It produces light workload on the master during the schema changes . We need online schema change to alter a table … Continue reading GH-OST for MySQL Schema Change.