How to Switch Replica Master of a non-GTID Slave in Percona Cluster ?

Introduction - Recently i worked on a production issue for one of our client under support .They have a architecture of a three node Galera cluster with one asynchronous slave . Node1 - 172.10.2.11Node2 - 172.10.2.12Node3 - 172.10.2.13Replica - 172.10.2.14 Architecture - The slave(replica) was configured with node3 as replica master. Unfortunately the node 3 was … Continue reading How to Switch Replica Master of a non-GTID Slave in Percona Cluster ?

Advertisements

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