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 .

Advertisements

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.

Save Space on MySQL data with Column Compression

                                   Recently, One of our client reached our Remote DBA team with a requirement to reduce the size of the table as it is having many text columns with huge number of records. At preliminary check , I have … Continue reading Save Space on MySQL data with Column Compression

Get the most IOPS out of your physical volumes using LVM.

Hope everyone aware about known about LVM(Logical Volume Manager) an extremely useful tool for handling the storage at various levels. LVM basically functions by layering abstractions on top of physical storage devices as mentioned below in the illustration. Below is a simple diagrammatic expression of LVM sda1 sdb1 (PV:s on partitions or whole disks) \ … Continue reading Get the most IOPS out of your physical volumes using LVM.

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

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

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

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

Summary – Mydbops Database meetup 2

Mydbops database meetup was held on 26-01-2019 and 48 members from open source database community has attended this event. We had talks on MySQL and MongoDB databases. Open source database enthusiastic from companies like OLA Cabs, Searce Inc, PayTm, Quikr, Zensar, Grab, SAP labs, Travel Yarri, Meddiff and a few has travelled from other cities … Continue reading Summary – Mydbops Database meetup 2

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 ?