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 Binlog server with Maxscale

This is the our next blog in Maxscale series, Below is a list of our previous blogs, which provides deep insight for Maxscale and its use cases for different architectures. Scale with Maxscale part – 1 (Intro & Galera Cluster) Scale with Maxscale part – 2 (Administration, Installation & operation) Scale with Maxscale part – … Continue reading MySQL Binlog server with Maxscale

5th Mydbops Database Meetup (Saturday, 2nd of Nov. 2019)

We are fueled and energized by the inquisitiveness and eagerness of Database Administrators as a community, reminding us of conducting the next edition of Mydbops Database Meetup. The regular attendees are now looking forward to this quarterly meetup organized by Mydbops, for the benefit of its participants, with the latest hands-on knowledge being shared by … Continue reading 5th Mydbops Database Meetup (Saturday, 2nd of Nov. 2019)

Mydbops @ Open Source India, 2019

Open Source India 2019 has been a showcase event for Mydbops IT Solutions during all the years of its association. This year it has been a very special occasion, as Mydbops has introduced a "Global-First-Industry-First" framework for the Database Administrative world. Global-First-Industry-First Any issue/requirement with Database Servers can be clubbed within this framework of S-E-P-S … Continue reading Mydbops @ Open Source India, 2019

Setting up a High Availability for PMM

We have been working with PMM for quite a long time, we do most of the performance analysis with PMM for most of our clients. It also provides the flexibility that we have built our own custom dashboard. PMM has many advantages Easy to deploy (docker based) Flexible Customizable Query Analytics One-stop solution for MySQL,Mongo,ProxySQL … Continue reading Setting up a High Availability for PMM

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.

Open Source India(OSI) 2019 & Mydbops

Since three years of our entity's progression, Mydbops IT Solutions, Bangalore, have been an active participant of Open Source India (OSI) conference, conducted by Open Source For You Magazine which is part of EFY Group, New Delhi. This annual event is an attempt by the team at Open Source For You magazine in partnership with … Continue reading Open Source India(OSI) 2019 & Mydbops

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

MDLC – Internship offerings

Conceptualized and Created by Mydbops Database Learning Center Mydbops is in the process of taking interns for its next round of recruitment, training and development. This is a great news for the DBA Community, as hands-on-experience and training is the best in the industry only at Mydbops. This is an opportunity, never to be missed … Continue reading MDLC – Internship offerings