Allow user gg to modify the /gg directory.
pnycb # chown -R gg:dba /gg psfob # chown -R gg:dba /gg
As user gg, untar the Oracle GoldenGate binaries in /gg on psfob and /gg on pnycb, assuming they have shared storage.
gg@pnycb:/gg$ tar xvf /var/tmp/ggs_Solaris_sparc_MySQL_64bit.tar gg@psfob:/gg$ tar xvf /var/tmp/ggs_Solaris_sparc_MySQL_64bit.tar
Create the sub-directories.
Cluster nyc gg@psfob:/gg$ ./ggsci GGSCI (psfob) 1> create subdirs GGSCI (psfob) 1> exit Cluster sfo gg@pnycb:/gg$ ./ggsci GGSCI (pnycb) 1> create subdirs GGSCI (pnycb) 1> exit
Configure the manager on cluster nyc.
gg@pnycb:/gg$ ./ggsci GGSCI (pnycb) 3> edit params mgr PORT 7809 DYNAMICPORTLIST 7810-7820 AUTORESTART ER *, RETRIES 4, WAITMINUTES 4 STARTUPVALIDATIONDELAY 5 PURGEOLDEXTRACTS /gg/dirdat/mm*, USECHECKPOINTS, MINKEEPHOURS 2 GGSCI (pnycb) 3>
Configure the manager on cluster sfo.
gg@psfob:/gg$ ./ggsci GGSCI (psfob) 3> edit params mgr PORT 7909 DYNAMICPORTLIST 7910-7920 AUTORESTART ER *, RETRIES 4, WAITMINUTES 4 STARTUPVALIDATIONDELAY 5 PURGEOLDEXTRACTS /gg/dirdat/mm*, USECHECKPOINTS, MINKEEPHOURS 2
Add the checkpoint table on both clusters.
Cluster nyc GGSCI (pnycb) 10> dblogin sourcedb golden userid gg GGSCI (pnycb DBLOGIN as gg) 11> add checkpointtable mysql.checkpoint Cluster sfo GGSCI (psfo) 10> dblogin sourcedb golden userid gg GGSCI (psfo DBLOGIN as gg) 11> add checkpointtable mysql.checkpoint
Define the IPv6 policy on both Oracle GoldenGate installations and also specify the checkpoint table.
Cluster nyc GGSCI (pnycb) > edit params ./GLOBALS USEIPV6 CHECKPOINTTABLE mysql.checkpoint Cluster sfo GGSCI (psfob) > edit params ./GLOBALS USEIPV6 CHECKPOINTTABLE mysql.checkpoint