Rate This Document
Findability
Accuracy
Completeness
Readability

Deploying MySQL Router+MGR (Multi-Primary Mode)

  1. Deploy MGR in multi-primary mode.

    The procedure for deploying MGR in multi-primary mode is basically the same as that for deploying MGR in single-primary mode. Additionally, you need to add the following content to the configuration files my.cnf-master-mgr, my.cnf-slave-mgr, and my.cnf-slave-2-mgr in Initializing the MySQL Database.

    group_replication_single_primary_mode=FALSE
    group_replication_enforce_update_everywhere_checks=TRUE

    For details about the other operations, see sections MySQL Router+MGR (Single-Primary) Deployment Architecture to Starting MGR.

  2. View group members.

    Log in to the three MySQL databases and start MGR. View the information about group members. You can view any member in the MGR group.