This blog discusses how you can configure Oracle GoldenGate to perform a real-time data capture from the AWS MySQL RDS database.The described approach creates a MySQL slave database on AWS EC2 first, and then configures Oracle GoldenGate for MySQL to capture from the MySQL slave database. To enable Oracle GoldenGate to capture from the master database, you need to set log_slave_updates=1 in my.cnf file of the slave database. The same approach can be used to capture from Amazon Aurora Database on AWS RDS. [Read More] for the detailed steps.
While working on this, I hit some errors as follows:
- Why do I get the following error when setting up GoldenGate for MySQL on EC2?
2016-03-20 04:54:31 ERROR OGG-06551 Oracle GoldenGate Manager for MySQL, mgr .prm: Could not translate host name ip-172-30-0-198 into an Internet address. 2016-03-20 04:54:31 ERROR OGG-01668 Oracle GoldenGate Manager for MySQL, mgr .prm: PROCESS ABENDING.
Answer: You need to edit the /etc/hosts file to provide the public IP of this machine so that GoldenGate Manager can connect to it.
[ec2-user@ip-172-30-0-198 gg]$ more /etc/hosts 127.0.0.1 localhost localhost.localdomain ip-172-30-0-198 - Why do I get the following error when connect to EC2 MySQL DB from Oracle GoldenGate?
GGSCI (ip-172-30-0-198) 5> dblogin sourcedb ggdemo@localhost, userid root password mysql
2016-03-20 05:21:34 WARNING OGG-00769 MySQL Login failed: .
SQL error (2002). Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
ERROR: Failed to connect to MySQL database engine for HOST localhost, DATABASE ggdemo, USER root, PORT 3306.
Answer: Please refer to this blog post Why I get the "Can't connect to local MySQL Server through socket..." error? - Why do I get the "ERROR: opening port for MGR MGR (Connection timed out)." error?
Answer: Please refer to this blog: Why do I get the "ERROR: opening port for MGR MGR (Connection timed out)." error?
Hope these are helpful.
Tag: Oracle GoldenGate for MySQL, AWS RDS, AWS EC2, AWS Aurora