a powerful feature that enables a cluster of servers to function as a single entity, ensuring high availability and fault tolerance. Within a group replication setup, each server replicates data to one another, allowing for redundancy and distributed workload management.

One of the key components of a group replication arrangement is the primary node, which serves as the primary source for data updates and manages the replication process. In the event that the primary node becomes unavailable, it’s crucial to switch to a new primary node to maintain the continuity of data replication and minimize downtime.

In this blog post, I’ll explore the process of promoting a subsidiary node to the primary node in a MySQL group replication setup.

Common reasons for switching the primary node

There are various situations where it may be necessary to switch the primary node in a MySQL group replication setup. Here are some of the typical reasons for this behavior:

• Performing OS or MySQL maintenance tasks that require the primary node to be offline temporarily.

• Applying patches or updates to the host system that may impact the performance or availability of the primary node.

• Upgrading the MySQL server to a new version or making significant changes to the configuration that require a new primary node.

• The current primary server experiences an issue or goes down unexpectedly, making it necessary to promote a new primary node to maintain data replication and minimize downtime.

Primary Promotion and its importance

In the event of a primary node failure, it’s important to select a new primary node to ensure the continuity of data replication and minimize downtime. This process is known as primary promotion.

With primary promotion, the group replication cluster can continue to function and handle requests even when a primary node fails.

Methods for switching the primary node

There are several methods available for switching the primary node in MySQL group replication, including:

1. Auto-switch
2. Auto-switch by weight of the node
3. Manual Primary Promotion