New GTID functions in Galera 4

Galera 4 came up with the lot of new features , which helps to effectively handle the cluster . In this blog I am going to explain in detail about the Galera 4 functions which were introduced for Global Transaction ID ( GTID ) . GTID functions in Galera 4 wsrep_last_written_gtid()wsrep_last_seen_gtid()wsrep_sync_wait_upto_gtid() Actually i have planned … Continue reading New GTID functions in Galera 4

MySQL Clone Plugin Speed Test

In my previous blog, I have explained how the MySQL clone plugin works internally. In this blog, I am going to do a comparison of  Backup and Recovery speed of MySQL clone plugin with other available mysql open source backup tools. Below tools are used for speed comparison of Backup and Recovery, Clone-Plugin Xtrabackup mysqldump … Continue reading MySQL Clone Plugin Speed Test

MySQL load data infile made faster .

Loading any large file into MySQL server using the LOAD DATA INFILE is a time consuming process , because it is single threaded and it is a single transaction too. But with modern hardwares system resource is not a bottle neck. At Mydbops we focus on improving the efficiency of process as we value performance … Continue reading MySQL load data infile made faster .

MySQL 8.0 Clone Plugin and its internal process.

MySQL 8 has recently released clone plugin which makes DBA's task of rebuilding the DB servers more easy. Cloning is a process of creating an exact copy of the original. In technical terms cloning alias to (Backup + Recovery), MySQL database cloning requires a sequence of actions to be performed manually or in a scripted fashion … Continue reading MySQL 8.0 Clone Plugin and its internal process.

MySQL 8.0 Flow Control in Group Replication

We are well aware that MySQL Group Replication is one of the faster evolving clustering Technology for MySQL. Flow Control plays a key factor in Group Replication performance and data integrity . In this blog I am going to explain about the Flow Control mechanism and How it has evolved in MySQL 8 ? What … Continue reading MySQL 8.0 Flow Control in Group Replication

Upcoming Mydbops Database Meetup -4 (03-08-2019)

Mydbops continues with its commitment to the open source community comprising of Database Administrators. After the successful conduct of three meet-ups in the past, we are now stepping ahead on to the 4th edition of Mydbops Database meet-up. First time, we are going to the new venue, thanks to the kind people of Zenefits Technologies … Continue reading Upcoming Mydbops Database Meetup -4 (03-08-2019)

MySQL Functional Index and use cases.

MySQL has introduced the concept of functional index in MySQL 8.0.13. It is one of the much needed feature for query optimisation , we have seen about histogram in my last blog. Let us explore the functional index and its use cases. For the below explanation, I have used a production scenario which has 16 … Continue reading MySQL Functional Index and use cases.

Histogram​ in MySQL 8.0

MySQL 8.0 introduces many new features. We will have a look at the exciting histogram  feature in MySQL 8.0 Histogram: What is Histogram? In General, a histogram is an accurate representation of the distribution of numerical data. In MySQL, It will be useful to collect data distribution for a specific column. What problem it solves? … Continue reading Histogram​ in MySQL 8.0

Presentation : JSON improvements in MySQL 8.0

MySQL User camp is one of the prestigious MySQL meetup happening in India for the past 6 years. Mydbops DBA's PonSuresh and Vignesh has presented about the "JSON functions and their improvements in MySQL 8.0" at MySQL User Camp Bangalore on 13-02-2019. JSON has been more improved a lot in MySQL 8.0 and improvements in … Continue reading Presentation : JSON improvements in MySQL 8.0

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