Golden Gate installation for MySQL

 

Topic: Golden Gate installation for MySQL  

 

Oracle Goldengate is used for real-time, heterogeneous data integration and replication, enabling near-zero downtime data migrations, high availability for enterprise systems, real-time data ingestion into big data platforms, and continuous data transformations and streaming data pipelines. It captures committed transactions in real-time from operational systems and delivers them to analytical systems, data lakes, and data warehouses across various platforms and databases, including Oracle, non-Oracle, and NoSQL databases.

Deployment Diagram:

 

Infrastructure Details:

Oracle DB Details
OS version	Red Hat Enterprise Linux release 7.6 (Maipo)
MySQL Version	8.0.43-commercial
GG Version	Version 19.1.0.0.0
Host Name	node01.example.com

 

In this QuickStart, we learn:

 

·         Validate MySQL Version

·         Download and stage Goldengate to MySQL Server

·         Create a directory for GG

·         Install and Configure GG

·         Configure the Manager Process and start it  

 

 

Step-1: Validate MySQL Version

 

 

Step-2: Download and stage Goldengate to MySQL Server

 

[root@Node01 tmp]# ls -ltr GG_19.1.0.0.0_MySQL_Linux_x86-64.zip

-rw-r--r--. 1 root root 70098487 Aug 27 12:55 GG_19.1.0.0.0_MySQL_Linux_x86-64.zip

[root@Node01 tmp]#

[root@Node01]# cd /tmp

[root@Node01 tmp]# unzip -q GG_19.1.0.0.0_MySQL_Linux_x86-64.zip

 

Step-3: Create a directory for GG

 

[root@Node01 tmp]# mkdir -p /u01/app/gg/product/19c

[root@Node01 tmp]# chown mysql:mysql -R /u01/app/gg

 

Step-4: Install and Configure GG

 

[root@Node01 tmp]# su – mysql

-bash-4.2$ cd /tmp

-bash-4.2$tar -xvf

ggs_Linux_x64_MySQL_64bit.tar -C /u01/app/gg/product/19c

-bash-4.2$ cd /u01/app/gg/product/19c/

 

Step-5: Configure the Manager Process and start it  

 

GGSCI (Node01.example.com) 2> edit param mgr