Skip to content

Create MySQL MGR Instance

MySQL Group Replication (MGR) is a solution for achieving consistent synchronization between different nodes in a distributed database system, providing a fault-tolerant and highly available cluster environment. It uses state updates from all servers in the replication group to achieve high-speed and reliable data redundancy.

Prerequisites

Before setting up an MGR cluster, ensure the following prerequisite is met:

  • The MySQL-Operator has been deployed in the target cluster and is in a running state.

Steps

  1. In the instance list, click the dropdown button Create MGR Instance.

  2. Fill in Basic Information of the instance, and select the deployment cluster and namespace.

    The system will check the installation prerequisites for the selected deployment locations. If the check fails, please follow the system prompts to install the necessary components.

  3. Fill in Spec Settings for the deployment instance and click Next.

    • Version: Currently, only version 8.0.31 is supported.
    • Replicas: The replicas range for MGR single-master mode is 3 - 9. It is recommended to use an odd number of replicas.

  4. Configure the instance's Service Settings and click Next.

    • Access Type: Choose the type of access service exposed by the instance.
    • Management Tool: Enable this option to manage MySQL using the phpMyAdmin management tool.

  5. After confirming that the instance configuration is correct, click OK to complete the creation and return to the alarm template list.

Comments