Setting Up Group Replication in MySQL

Setup Group Replication

Write a MySQL commands to set up Group Replication for MySQL.

Solution:

-- On all servers, install the group replication plugin:
INSTALL PLUGIN group_replication SONAME 'group_replication.so';

-- Create a replication user for group replication:
CREATE USER 'gr_user'@'%' IDENTIFIED BY 'password';
GRANT REPLICATION SLAVE ON *.* TO 'gr_user'@'%';

-- Configure group replication on each server:
SET GLOBAL group_replication_bootstrap_group=ON;
START GROUP_REPLICATION;
SET GLOBAL group_replication_bootstrap_group=OFF; -- Only on the first server

-- On subsequent servers:
START GROUP_REPLICATION;

Explanation:

• Purpose of the Query:
• Establishes a multi-master replication setup with automatic failover using Group Replication.
• Key Components:
• Plugin installation, user setup for replication, and initiating the replication group.
• Real-World Application:
• Provides high availability and automatic failover within MySQL setups.

Notes:

• Ensure all servers are configured similarly to avoid issues in group formation.

For more Practice: Solve these Related Problems:

• Write MySQL to configure Group Replication with a custom group name and different communication ports.
• Write MySQL commands to set up Group Replication with a specific conflict resolution policy.

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous MySQL Exercise: Convert Semi-Sync to Full Sync.
Next MySQL Exercise: Monitor Group Replication Status.