Scale With MaxScale – Part 1

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 … Continue reading Scale With MaxScale – Part 1

Advertisements

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 … Continue reading Estimating records in index range and CPU Spike (MariaDB)