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)
In this post, We’re going share the details about Operation and Administration part of the MaxScale. To view Installation and Configuration of MaxScale checkout our previous blog. Before going through this week’s topic, I would highlight some recent change at MaxScale has went through. From Version 2.0, MaxScale license changed from GPLv2 to MariaDB BSL. MariaDB … More Scale With MaxScale – Part 2
In this post, I ‘ m going to cover my recent encounter with MaxScale. We had to help one of our client to load balance and split read / writes on their 3 node Percona XtraDB Cluster (PXC). List of available options were HaProxy MaxScale ProxySQL Implementation of HaProxy is ruled out as It’s doesn’t … More Scale With MaxScale – Part 1
At MyDBOPS we focus on faster database operations. So we have build our own set of our tools and also we use standard open source tools. Percona tool kit and Xtrabackup are some of the prominent tools we use. This is presentation about a few percona tool that every DBA should consider using it.
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 … More Faster Logical backup using MyDUMPER (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.