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

HotBackup 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 HotBackup 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)

Jinja2 for better Ansible

Jinja2 is a modern and designer-friendly templating language for Python frameworks. It is fast, reliable and widely used for dynamic file generation based on its parameter. In this blog, I like to share how and where jinja2 template language used in Ansible and how we can create better Ansible playbook. How it works The Jinja … Continue reading Jinja2 for better Ansible

MongoDB Aggregation Framework an Overview

          The MongoDB Aggregation Framework is a way to query the data from MongoDB. It helps us to break the complex logics into a simple set of sequential operations. Just like a waterfall model, Output from one stage is fed as an input for the next stage until the desired result … Continue reading MongoDB Aggregation Framework an Overview

Chose right SST method MariaDB Cluster 10.2

                In this blog post, I am going to explain an interesting issue which I faced in one of our client project . Few weeks back , I got an requirement from our support client to construct a new MariaDB Galera Cluster ( 10.2.21 ) and an async … Continue reading Chose right SST method MariaDB Cluster 10.2

Mysqldump​ vs Mysqlpump vs Mydumper

It is very important for every DBA’s to backup their data frequently so that they can recover data if any problems occur such as Hardware failure, System crashes, Human mistakes. There are several ways to backup MySQL data. They are 1) Physical Backup 2) Logical Backup Physical Backup:               It is also called Raw Backup. It … Continue reading Mysqldump​ vs Mysqlpump vs Mydumper

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