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

Advertisements

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

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

Summary – Mydbops Database Meetup (Apr-2019)

Conglomeration, Collaboration and Celebration of Database Administrators Founders of Mydbops envisioned contributing knowledge back to the community. This vision is shaping up in its 3rd edition of the Meetup held on Saturday the 27th of April, 2019. This meetup edition had drawn a good amount of members from the Open Source Database Administrative Community, to … Continue reading Summary – Mydbops Database Meetup (Apr-2019)