Reading Amazon RDS MySQL/Aurora log file from terminal.

Introduction: At Mydbops we support a good number of clients on AWS cloud (Aurora and RDS). Amazon Relational Database Service (RDS) is providing the cloud based database service. It is the cost-efficient, resize able & ease to manage. As in any other DBaaS, If you need to analyse the log files (Error log / Slow … Continue reading Reading Amazon RDS MySQL/Aurora log file from terminal.

Advertisements

Scale with Maxscale part-4 (Amazon Aurora)

This is part-4 of the Maxscale Blog series Maxscale and Galera Maxscale Basic Administration Maxscale for Replication Maxscale started supporting Amazon Aurora lately from its version 2.1 which comes with a BSL license, we are good until we use only 3 nodes, Amazon Aurora (Our Previous blog ) is a brilliant technology built by AWS team which … Continue reading Scale with Maxscale part-4 (Amazon Aurora)

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)

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

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

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

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)

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 … Continue reading Integrating MariaDB Audit plugin in MySQL 5.7