Mastering MySQL Group Replication Primary Promotion Techniques

Table of contents: IntroductionCommon reasons for switching the primary nodePrimary Promotion and its importanceMethods for switching the primary nodeSetting up a three-node MySQL group replication cluster for demonstrationAuto-switch method and its implementationAuto-switch by weight of the node method and its implementationManual Primary Promotion method and its implementationConclusion Introduction MySQL's group replication is a powerful feature …

Advertisement

PostgreSQL automatic failover with pg_auto_failover

PostgreSQL is a powerful, open-source relational database with a strong reputation for reliability, robustness, and performance. It supports replication to achieve high availability for a very long. But it lacks an important feature on its own, that is the concept of automated failover. Of course, there are a lot of open-source tools available to do …

Major SST methods In XtraDB / MariaDB Cluster and its supporting files.

Galera replicates the data across the cluster in a virtually synchronous fashion. Based on the availability of cluster nodes the type of data transfer can vary. The important factor which decides the type of data transfer required here is the existing write set in gcache. Galera Cluster stores write-sets in a special cache called the …

ProxySQL Series : ProxySQL Native Cluster

ProxySQL supports a feature called clustering from version 1.4.2 .while planning for setting up a  cluster ensure to have a version greater than 1.4.2 ( latest is better) . This is still an experimental feature but works well. This blog would be a continuation of our proxysql series of blogs. MySQL replication Read-Write Split up …