Oracle^® Solaris Cluster Data Replication Guide for Oracle GoldenGate

Configuring the First Replication Direction

1. Configure extract 1 on cluster nyc.

   GGSCI (pnycb) 9> edit param mysqlex1
   EXTRACT mysqlex1
   DBOptions Host nyc-gg
   SourceDB golden UserID gg Password gg
   TranLogOptions AltLogDest /mys/data/logs/bin-log.index  
   TranLogOptions filtertable mysql.checkpoint
   DISCARDFILE /gg/mysqlex1.dsc, PURGE
   RMTHOST sfo-gg, MGRPORT 7909
   RMTTRAIL /gg/dirdat/XX
   TABLE golden.*;

2. Add extract 1 on cluster nyc.

   GGSCI (pnycb) > Add Extract MySQLEX1 TranLog Begin now

3. Add remote trail 1 on cluster nyc.

   GGSCI (pnycb) > Add RmtTrail /gg/dirdat/XX extract MySQLEX1

4. Configure replicat 1 on cluster sfo.

   GGSCI (psfob) 11> edit param mysqlre1
   REPLICAT mysqlre1
   DBOptions Host sfo-gg
   TargetDB golden USERID gg PASSWORD gg
   DISCARDFILE /gg/mysqlre1.dsc, PURGE
   REPERROR DEFAULT, ABEND
   AssumeTargetDefs
   Map golden.*, Target golden.*;

5. Add replicat 1 on cluster sfo.

   GGSCI (psfob) 11> Add Replicat MySQLRE1 exttrail /gg/dirdat/XX checkpointtable mysql.checkpoint