MongoDB Process List In MySQL Way

MongoDB Processlist: As a DBA from MySQL background. I always wanted to quickly visualise what process / queries running inside my MongoDB server just like i do “show processlist” in MySQL. db.currentOp(): https://docs.mongodb.com/manual/reference/method/db.currentOp/ MongoDB command “db.currentOp()” can be used for this purpose. But the command returns a lengthy JSON which is hard to quickly grasp … More MongoDB Process List In MySQL Way

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 … More Mydbops Delighted to be part of Open Source India -2017

Xtrabackup for handling Encrypted Tablespace

      ​In this post, we are going to see how we can backup encrypted tables using Xtrabackup. InnoDB supports data encryption for InnoDB tables stored in file per table tablespaces. For the application to access encrypted tablespace, InnoDB will use master encryption key to decrypt the tablespace key. The master encryption key is stored … More Xtrabackup for handling Encrypted Tablespace

Scale With Maxscale – Part 3 (Replication)

This blog post is continuation of series of blog post on Maxscale, Part-1 which provides detailed introductory to Maxscale, Part-2 deals about the operation and administration of Maxscale. In this we will discusses, How Maxscale can be efficiently used for read scaling with mysql replication (Master – Slave). Replication is a great feature which is … More Scale With Maxscale – Part 3 (Replication)

Read MySQL Binlogs better with rows query log events

Introduction :  In MySQL the replication is logical. And the DB changes were written to mysqlbinlog. This mysqlbinlog is pulled (IO Thread) and applied ( SQL Thread) by the slave servers. Binlog is the key for MySQL Replication. Binary logging format is of three types. Statement ROW Mixed ROW based replication benefits the smaller writes … More Read MySQL Binlogs better with rows query log events

Virtual Columns in MySQL and Use cases.

Introduction: MySQL 5.7 introduces a new feature called virtual/generated column. It is called generated column because the data of this column is computed based on a predefined expression or from other columns. What is Virtual Column ? In general virtual columns appear to be normal table columns, but their values are derived rather than being … More Virtual Columns in MySQL and Use cases.