Investigating a MySQL dead lock

I was involved in one of the development support for MySQL. Here is an interesting case The application needs a Sequence generator as it was not present inbuilt with MySQL ( MariaDB will have it in 10.3 ) they have made sequence generator function with 'select for update' statement. But it tends to cause more locking … Continue reading Investigating a MySQL dead lock

Advertisements

Maxscale Data Archiving with filters Mq & Tee ( Mirror)

Introduction -           Maxscale is an excellent Proxy from Mariadb Corporation, which providing the High Availability, Realtime RW split with replication Glaera cluster Amazon RDS Amazon Aurora, binlog streaming and many more advanced features, here in this blog we will discuss one such feature,  In this blog post, i am going to share my … Continue reading Maxscale Data Archiving with filters Mq & Tee ( Mirror)

Making Maxscale/ProxySQL Highly Available ( 2 > 1 )

As Mydbops we are implementing Load Balancer using Maxscale or ProxySQL ( Our presentation ) for lot our client,  but these load balancers will become a SPOF (Single Point of failure) .  We have tried to explore services like HAProxy, Nginx, and Keepalived etc. Except Keepalived, all the services need to run on the standalone instance … Continue reading Making Maxscale/ProxySQL Highly Available ( 2 > 1 )

Replication Will not Start On AWS RDS for MariaDB 10.2

AWS recently announced the release of MariaDB 10.2 for RDS. One of customer needs this release for GIS indexing .The recent encounter on a Replication issue with RDS MariaDB 10.2 is briefed here . Problem Statement: After the upgrade of replicas to MariaDB 10.2 on RDS, Once replication is stopped manually through “call mysql.rds_stop_replication;” or … Continue reading Replication Will not Start On AWS RDS for MariaDB 10.2

Presentation: Highly efficient backup with Xtrabackup

  Xtrabackup is the most widely open source hot backup tool for MySQL. Xtrabackup support InnoDB and MyISAM engines.It supports both MySQL Server , Percona Server and MariaDB. This presentation covers some of the important features in Xtrabackup. Pic Courtesy : https://www.flickr.com/photos/robbiewendt/8108744459/

Disabling Multi-Source Replication in MySQL 5.7

Multi-channel replication is one of the  great feature shipped with MySQL 5.7, With allowed the capability of slave to have many masters, having a channel for each master by which they replicate. Each channel id has a unique “channel_name” In the above DB Architecture “channel_1, channel_2 and channel_3” represent the channel_name used for replication from … Continue reading Disabling Multi-Source Replication in MySQL 5.7

Ulimit conflict with PAM and Systemd​​​

As a part of the MySQL Support, we had a support request from a client.The issue is DB server runs out of open files limit, though it is configured. It causes the DB hang and crash at times. Sometimes they can't able to fix. So we plan to write our experience with configuring. We believe this … Continue reading Ulimit conflict with PAM and Systemd​​​

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 … Continue reading 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 … Continue reading 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 … Continue reading Xtrabackup for handling Encrypted Tablespace