Configure extract 2 on cluster sfo.
GGSCI (psfob) 9> edit param mysqlex2 EXTRACT mysqlex2 DBOptions Host sfo-gg SourceDB golden UserID gg Password gg TranLogOptions AltLogDest /mys/data/logs/bin-log.index TranLogOptions filtertable mysql.checkpoint DISCARDFILE /gg/mysqlex2.dsc, PURGE RMTHOST nyc-gg, MGRPORT 7809 RMTTRAIL /gg/dirdat/YY TABLE golden.*;
Add extract 2 on cluster sfo.
GGSCI (psfob) > Add Extract MySQLEX2 TranLog Begin now
Add remote trail 2 on cluster sfo.
GGSCI (psfob) > Add RmtTrail /gg/dirdat/YY extract MySQLEX2
Configure replicat 2 on cluster nyc.
GGSCI (pnycb) 11> edit param mysqlre2 REPLICAT mysqlrep2 DBOptions Host nyc-gg TargetDB golden USERID gg PASSWORD gg DISCARDFILE /gg/mysqlre2.dsc, PURGE REPERROR DEFAULT, ABEND AssumeTargetDefs Map golden.*, Target golden.*;
Add replicat 2 on cluster nyc.
GGSCI (psfob) 11> Add Replicat MySQLRE2 exttrail /gg/dirdat/YY checkpointtable mysql.checkpoint
Start the manager on both clusters.
Cluster nyc GGSCI (pnycb) > start mgr Cluster sfo GGSCI (psfob) > start mgr
Start the extract and replicat processes on both clusters.
Cluster nyc
GGSCI (pnycb) > start er *
Cluster sfo
GGSCI (psfob) > start er *
Check if everything is running on both clusters.
Cluster nyc
GGSCI (pnycb) > info all
Cluster sfo
GGSCI (psfob) > info all
Stop the extract and replicat processes on both clusters.
Cluster nyc
GGSCI (pnycb) > stop er *
Cluster sfo
GGSCI (psfob) > stop er *
Stop the manager process on both clusters.
Cluster nyc
GGSCI (pnycb) > stop mgr !
GGSCI (pnycb) > exit
Cluster sfo
GGSCI (psfob) > stop mgr !
GGSCI (psfob) > exit
Assuming the root role, kill the server process on both clusters.
Cluster nyc
pnycb # pkill -f server
Cluster sfo
psfob # pkill -f server
Assuming the root role, create the Oracle GoldenGate resources.
Cluster nyc
pnycb # clrs create -d -g mys-rg \
-t GoldenGate \
-p user=gg \
-p Basepath=/gg \
-p port=7809 \
-p parameter_file=/gg/dirprm/mgr.prm \
-p database_resource=mys-rs \
-p resource_dependencies=mys-rs,nyc-gg \
-p resource_dependencies_offline_restart=mys-hsp-rs,gg-hsp-rs \
gg-rs
Cluster sfo
psfob # clrs create -d -g mys-rg \
-t GoldenGate \
-p user=gg \
-p Basepath=/gg \
-p port=7909 \
-p parameter_file=/gg/dirprm/mgr.prm \
-p database_resource=mys-rs \
-p resource_dependencies=mys-rs,sfo-gg \
-p resource_dependencies_offline_restart=mys-hsp-rs,gg-hsp-rs \
gg-rs
On both clusters, enable the Oracle GoldenGate resource.
pnycb # clresource enable gg-rs psfob # clresource enable gg-rs