Oracle Cloud Infrastructure Documentation

Add a Replicat for MySQL

Learn to add and configure a Replicat process for a MySQL target.

Add a Replicat (23ai)

Before you begin

Ensure that you add a Checkpoint table for the Replicat to restart without recapturing reapplying transactions should a discruption occur.

  1. In the OCI GoldenGate deployment console, expand DB Connections, and select your target database.
  2. Click Add Checkpoint (plus icon).
  3. For Checkpoint Table, enter the target schema name, and then click Submit.
To add a Replicat for MySQL in GoldenGate 23ai:
  1. In the Administration Service navigation menu, click Replicats.
  2. On the Replicats page, click Add Replicat (plus icon).
  3. The Add Replicat form consists of four pages. Complete the form as needed:
    1. On the Replicat Information page:
      1. Select a Replicat type:
        • Classic Replicat
        • Coordinated Replicat
        • Parallel Replicat
        Note

        Learn about different Replicat types.
      2. Click Next.
    2. On the Replicat Options page:
      1. Enter the Replicat trail details:
        • Name (can only be two characters)
        • Subdirectory
      2. Select the Target Credentials:
        • Domain
        • Alias
        • Checkpoint Table
        • (Optional) When to Begin
      3. Enter the Trail Position Sequence Number and RBA Offset.
      4. Click Next.
    3. On the Managed Options page, complete the optional fields as needed:
      1. Select a Profile Name.
      2. Enable Critical to deployment health.
      3. Enable Auto Start.
      4. Enable Auto Restart.
      5. Click Next.
    4. On the Parameter File page, you can configure how the Replicat maps the source and target tables. For example:
      MAP table.*, TARGET table.*;
  4. Click Create and Run to start the Replicat. If you click Create, you can manually start the Replicat later on the Replicats page.
You return to the Replicats page, where you can select the Replicat to view its details.

Add a Replicat (21c)

Before you add a Replicat, create a checkpoint table to ensure the Replicat can restart without reapplying transactions should a disruption occur.

  1. In the OCI GoldenGate deployment console navigation menu, click Configuration.
  2. On the Database tab, click the database connect icon for the target database.
  3. Click Add Checkpoint (plus icon).
  4. For Checkpoint Table, enter the target schema name, and then click Submit.
To add a Replicat for MySQL:
  1. In the OCI GoldenGate deployment console, on the Administration Service Overview page, click Add Replicat (plus icon).
  2. On the Add Replicat page, under Replicat type, select from the following options, and then click Next:
    • Classic Replicat
    • Coordinated Replicat
    • Parallel Replicat
    Note

    See Decide which apply method to use to learn more about Replicat types.
  3. On the Replicat Options page, under Basic Information, complete the following fields as needed:
    1. For Process Name, enter a name for the Replicat
    2. (Optional) For Description, enter a brief description to distinguish this Replicat from others.
    3. For Intent, select the Replicat's purpose:
      • High Availability
      • Disaster Recovery
      • Unidirectional (default)
      • N-Way
    4. For Credential Domain and Credential Alias, select the target database domain and alias, or create a new credential.
    5. For Source, select the source of data to process, either Trail or File.
    6. If the source is Trail, then for Trail Name, enter the name of the Extract trail.
    7. If the source is Trail and you expect the trail file to be in a location other than the default, then enter the location for Trail Subdirectory.
    8. For Begin, select the starting point for data processing:
      • Position in Log
      • Now
      • Custom Time
    9. For Trail Sequence Number, leave the default value or enter a trail sequence number.
    10. For Trail RBA Offset, leave the default value or enter a trail offset.
    11. For Checkpoint Table, leave the default selection or select the checkpoint table you created for the target deployment.
  4. Click Next.
  5. For Parameter File, you can add parameters to further configure the Replicat process.
    Note

    GoldenGate uses Greenwich Mean Time (GMT) by default. Use SETENV to override the default setting. For example:
    setenv (TZ="US/Eastern")
setenv (TZ="GMT+5")

    Learn more about SETENV.

  6. Click Create and Run. If you click Create, then you can manually start the Replicat later from the Administration Service Overview page.
You're returned to the Administration Service Overview page where you can view the creation of the Replicat process and access Replicat Actions.