1. Oracle GoldenGate Microservices Documentation
  2. Instantiate
  3. Precise Instantiation for MySQL to MySQL Using MySQL Shell Utilities and Oracle GoldenGate
  4. Precise Instantiation for MySQL non-GTID-based Capture

Precise Instantiation for MySQL non-GTID-based Capture

The following steps describe precise instantiation in the non-gtid based capture:

  1. To test the precise instantiation on non-gtid-based capture, make sure either the gtid_mode is not enabled in the database server or _DISABLEGTIDRECOVERY true is specified in the Extract parameter file.

  2. After completing the initial load, use the instance dump.

  3. Read the @.json file and get the values of binlogFile and binlogPosition from the @.json file. Use these values as lognum and logpos.

  4. Add Extract using lognum and logpos in Oracle GoldenGate Microservices Architecture, using Admin Client or web interface, as shown in the following example:
    OGG (https://databasede3phx.oraclevcn.com:9011 GTIDMAIN) 32> ADD EXTRACT extpos tranlog lognum 5 logpos 1289

  5. Perform the DML operations and verify that there are no duplicate or missing transactions on the target side. Check the Extract report file for the initial position using lognum and logpos.