Column Level Masking on MySQL

Data is an invaluable asset to any organisation and every data should not be viable to all DB users. I had a requirement from one of our Support client to hide (mask) a few columns to the end user. Those columns contains sensitive information like payment details and mobile numbers. In this blog post I … Continue reading Column Level Masking on MySQL

Advertisements

Flashback Recovery in MariaDB/MySQL Servers

In this blog, we will see how to do a flashback recovery or rolling back the data in MariaDB, MySQL and Percona. As we know the saying  "All humans make mistakes", following that in Database environment the data modified accidentally can bring havoc to any organisations. Recover the lost data The data can be recovered … Continue reading Flashback Recovery in MariaDB/MySQL Servers

ProxySQL Series : ProxySQL Backup Startegies

Introduction             We are well aware that ProxySQL is one of the leading SQL aware proxy for MySQL. In this blog I am going to explain the backup & restore strategies of the ProxySQL . I think, still there is not well structured blog about this topic . If you … Continue reading ProxySQL Series : ProxySQL Backup Startegies

Hot Backup For MyRocks(Rocksdb) using Percona Xtrabackup

Xtrabackup now supports Hotbackup for Myrocks!! yes you heard me right, this is one of the most awaited features with xtrabackup. With the latest release of percona xtrabackup 8.0.6 this is enabled and is supported only for Percona Server version 8.0.15-6 or higher, you can see detailed released notes here. Myrocks is getting much of … Continue reading Hot Backup For MyRocks(Rocksdb) using Percona Xtrabackup

Mysqldump​ vs Mysqlpump vs Mydumper

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

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

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

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

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

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.