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.*;
Add extract 1 on cluster nyc.
GGSCI (pnycb) > Add Extract MySQLEX1 TranLog Begin now
Add remote trail 1 on cluster nyc.
GGSCI (pnycb) > Add RmtTrail /gg/dirdat/XX extract MySQLEX1
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.*;
Add replicat 1 on cluster sfo.
GGSCI (psfob) 11> Add Replicat MySQLRE1 exttrail /gg/dirdat/XX checkpointtable mysql.checkpoint