Setting up a High Availability for PMM

We have been working with PMM for quite a long time, we do most of the performance analysis with PMM for most of our clients. It also provides the flexibility that we have built our own custom dashboard. PMM has many advantages Easy to deploy (docker based) Flexible Customizable Query Analytics One-stop solution for MySQL,Mongo,ProxySQL … Continue reading Setting up a High Availability for PMM

Advertisements

Get the most IOPS out of your physical volumes using LVM.

Hope everyone aware about known about LVM(Logical Volume Manager) an extremely useful tool for handling the storage at various levels. LVM basically functions by layering abstractions on top of physical storage devices as mentioned below in the illustration. Below is a simple diagrammatic expression of LVM sda1 sdb1 (PV:s on partitions or whole disks) \ … Continue reading Get the most IOPS out of your physical volumes using LVM.

TaskMax limit affects MySQL connections

Recently we had been bitten by a Systemd limitation at the “Tasks” created per-unit ie., process. This includes both the kernel threads and user-space threads, with each thread counting individually. Am writing this blog as a reference for someone who might come across this limitation. We have been actively working on migration DB instances, from … Continue reading TaskMax limit affects MySQL connections

Hot Backup For MyRocks(Rocksdb) using Percona Xtrabackup

Xtrabackup now supports Hotbackup for Myrocks!! yes you heard me right, this is one of the most awaited features with xtrabackup. With the latest release of percona xtrabackup 8.0.6 this is enabled and is supported only for Percona Server version 8.0.15-6 or higher, you can see detailed released notes here. Myrocks is getting much of … Continue reading Hot Backup For MyRocks(Rocksdb) using Percona Xtrabackup

ProxySQL Series:​ Amazon Aurora (RDS) Read-Write Split.

In this blog we are going to see how to implement Proxysql for Amazon Aurora RDS, this would be next in series of ProxySQL blogs. Below is the list of our previous blogs on ProxySQL which provides deeper insights based on different use cases and different architecture. MySQL replication Read-Write Split up Replication Switchover using … Continue reading ProxySQL Series:​ Amazon Aurora (RDS) Read-Write Split.

Migrate MySQL data to RDS/Aurora Using Xtrabackup

In this blog, I will provide a step by step procedure to migrate from on-premise MySQL to Amazon RDS/Aurora using Percona-xtrabackup Both RDS and Aurora is a DBAAS provided by Amazon. To know more on DBAAS you can view our presentation here. When you are having a database in size of few GB, it would … Continue reading Migrate MySQL data to RDS/Aurora Using Xtrabackup

Delayed Replication with Amazon RDS

"Delayed replication" is one of the important features which were being supported in MySQL from 5.6 for a very long time. This induces an intentional lag in the slave, making it lag by the defined time interval. For a long time this was not available with the RDS version of MySQL provided by AWS, Recently … Continue reading Delayed Replication with Amazon RDS

ProxySQL Series : Percona Cluster/MariaDB Cluster (Galera) Read-write Split

ProxySQL is the most preferred and is widely used for load-balancing MySQL workload, thanks to Rene Cannon & Team for the great tool, and kudos on the recent release of ProxySQL 1.4.10, with a lot of bug fixes. ProxySQL is simple in design, lightweight, highly efficient and feature rich, We have been working with ProxySQL … Continue reading ProxySQL Series : Percona Cluster/MariaDB Cluster (Galera) Read-write Split

Database Objects migration to RDS/ Aurora (AWS)

The world of application and its related services are migrating more towards cloud, because of availability, Elasticity, Manageability etc. While moving the entire stack we need to be very cautious while migrating the database part. Migration of DB servers is not a simple lift and shift operation, Rather it would require a proper planning and … Continue reading Database Objects migration to RDS/ Aurora (AWS)

Scale-with-Maxscale-part5 (Multi-Master)

This is the 5th blog in series of Maxscale blog, Below is the list of our previous blogs, Which provides deep insight for Maxscale and its use cases for different architectures. Scale with Maxscale part -1 (Intro & Galera Cluster) Scale with Maxscale part - 2 (Administration, Installation & operation) Scale with Maxscale part - … Continue reading Scale-with-Maxscale-part5 (Multi-Master)