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)

Scale With MaxScale – Part 2

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

Estimating records in index range and CPU Spike (MariaDB)

Recently we got paged by CPU spikes on one of our clients slave MySQL ( MariaDB ) server under MyDBOPS Remote DBA Team Support. Our MySQL Engineers started analysing the root cause of the issues and resolved it. This blog provides an overview of the troubleshooting and fix proposed. System Summary : Database server : 10.1.10-MariaDB-log … More Estimating records in index range and CPU Spike (MariaDB)

Integrating MariaDB Audit plugin in MySQL 5.7

Introduction: Basically, Auditing is the process of monitoring and recording the activity happens inside the Server. MariaDB Audit Plugin is works with MariaDB, MySQL and Percona Servers. It is used to log the database Operations like, SQL Statements, User informations, Connections. The informations are stored in a user defined log file or in Syslog. Available audit … More Integrating MariaDB Audit plugin in MySQL 5.7