1. Microservices Architecture Documentation
  2. Administer
  3. Data Management
  4. Using Oracle GoldenGate with MySQL Group Replication
  5. Requirements for Supporting Group Replication

Requirements for Supporting Group Replication

This topic describes the requirements for using Oracle GoldenGate with MySQL Group Replication database clusters.

  • Oracle GoldenGate for MySQL Group Replication supports MySQL version 8.0 or higher.

  • Only Group Replication configured in Single-Primary Mode is supported for Extract.

  • The MySQL database setting gtid_mode must be enabled.

Limitations of Group Replication with Oracle GoldenGate for MySQL

Here are the limitations of support when running group replication with Oracle GoldenGate for MySQL:

  • Oracle GoldenGate GTID-based capture does not support tags.

  • Oracle GoldenGate Extract with MySQL Group Replication does not support multi-primary Group Replication mode.

  • Oracle GoldenGate Extract with MySQL Group Replication does not support writing to remote trails. If using RMTTRAIL with an Extract, the Extract will abend with the following error: 

    "Trail file ea is remote. Only local trail allowed for this extract."

    In this example, ea is the remote trail file name.

    Use the DISTPATH process to transport remote trails. See Manage Distribution Paths.