Configuring efficient MySQL Logrotate

I am a Junior DBA at Mydbops. This is my first blog professionally, I would like to brief my encounter with Log-rotate in first few weeks of my work,  Hope it will help other beginners as well. This Blog will cover the following sections. Introduction to Log-rotate Issues FacedSolutions (Fix for the above issues)Best practicesHow … Continue reading Configuring efficient MySQL Logrotate

How To design a better Ansible Role for MySQL Environment ?

In our earlier stage of Ansible, we just wrote simple playbook and ad-hoc command with very long ansible hosts file. When we plan to use Ansible extensively in our daily production use case, we understand that simple playbooks don't help to scale up to our expectation. Even though we had options for separate variables, handlers and template … Continue reading How To design a better Ansible Role for MySQL Environment ?

Ansible Best Practices

Managing Heterogeneous environment without automation can be tricky. We are using Ansible as an automation tool for install, configure and manage DB infra for Mydbops. Using Ansible, we overcome a lot of obstacle's and we would like to share our learning with the community ( Our Presentation on Ansible )   Best Practices to write … Continue reading Ansible Best Practices

Handling long duration SST(timeout) in PXC with systemd

In this blog post, We will be explaining about the timeouts in SST on systemd implementation which we faced recently in Percona XtraDB Cluster  during our Consulting with a client. State Snapshot Transfers (SST) refers to complete data sync from one of the nodes from the cluster to the joining node. SST will happen for one or … Continue reading Handling long duration SST(timeout) in PXC with systemd

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 )

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​​​

InnoDB and Linux mount point.

In this blog we are going to share my recent experience with an issue which we faced during migration between two Ubuntu servers. The activity was pretty simple, the client had bought a new machine with enhanced memory and faster disk, so the data has to be transferred to the new server and live MySQL replication … Continue reading InnoDB and Linux mount point.

Faster Logical backup using MyDUMPER (Presentation).

Backups are crucial for any organization. At MyDBOPS our clients need both logical and hot backup. We use mydumper for faster logical backups. We have made a blog on mysqlpump ( 5.7) to make faster logical backup. But mysqlpump do not have rich set of features. mydumper has rich set of features which makes most of … Continue reading Faster Logical backup using MyDUMPER (Presentation).

Linux Monitoring and Troubleshooting ( Presentation)

This presentation by MyDBOPS team shows the various monitoring commands and tools in Linux for the effective operation of DBA's. As more than 90% of MySQL servers runs on Linux OS it becomes mandatory for DBA's or DevOPS to team to be efficient in Linux monitoring and Troubleshooting.