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

Advertisements

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

Mydbops Delighted to be part of Open Source India -2018

Mydbops has partnered with OSI days for the second consecutive year. OSI days is one of the Asia's leading  open source conference. Presentations on MySQL  Topic        : Evolution of DBA's in Cloud Presenter : Manosh Malai ,Senior Devops / DB Consultant Mydbops Kabilesh P R. Co-Founder / DB Consultant Mydbops   As Cloud … Continue reading Mydbops Delighted to be part of Open Source India -2018

Mydbops Delighted to be part of Open Source India -2017

Open Source India (OSI) is the premier Open Source conference in Asia targeted at nurturing and promoting the Open Source ecosystem in the subcontinent. Started as Linux Asia in 2004, OSI has been at the helm of bringing together the Open Source industry and the community since its inception. The objective of OSI is to convince … Continue reading Mydbops Delighted to be part of Open Source India -2017

MongoDB Index Usage Analysis

At MYDBOPS we have ventured into MongoDB recently. We have been exploring it deeply from Jan-2017. In most cases we see MongoDB and MySQL exists together as a part of DB Infra. We have been engaged as part of open source migration for a biggest retail in US.It involves MongoDB and MySQL as a datastore. … Continue reading MongoDB Index Usage Analysis

TokuDB hot Backup and Recovery.

TokuDB is a high compression Engine for MySQL. It uses Fractal tree pages and huge data pages to achieve the The Percona TokuBackup library intercepts system calls that write files and duplicates the writes on backup files. It does this while copying files to the backup directory. The TokuBackup library must be installed into the mysqld … Continue reading TokuDB hot Backup and Recovery.