It is very important for every DBA’s to backup their data frequently so that they can recover data if any problems occur such as Hardware failure, System crashes, Human mistakes. There are several ways to backup MySQL data. They are 1) Physical Backup 2) Logical Backup Physical Backup: It is also called Raw Backup. It … Continue reading Mysqldump vs Mysqlpump vs Mydumper
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
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
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
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
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.
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