Oracle GoldenGate for MySQL 12.2 is now certified on delivering to Amazon Aurora database [1]. With this certification, you can use Oracle GoldenGate for MySQL to deliver real-time data to Amazon Aurora databases, including the Aurora DB Cluster.
The followings are the steps to configure the data delivery.
1. Install Oracle GoldenGate for MySQL on AWS EC2
Oracle GoldenGate for MySQL supports remote apply. With the remote apply, you can install Oracle GoldenGate on a machine outside the database server and connect to the MySQL database to apply the replicated data. For the data delivery to Amazon Aurora databases, the remote apply can be configured in an Oracle GoldenGate instance running on an EC2 machine or any machine which you provides the access to the Aurora database endpoints.
2. Configure the Database Connection
After Oracle GoldenGate for MySQL is installed, you can then set up the database connection as follows:
Oracle GoldenGate for MySQL supports remote apply. With the remote apply, you can install Oracle GoldenGate on a machine outside the database server and connect to the MySQL database to apply the replicated data. For the data delivery to Amazon Aurora databases, the remote apply can be configured in an Oracle GoldenGate instance running on an EC2 machine or any machine which you provides the access to the Aurora database endpoints.
2. Configure the Database Connection
After Oracle GoldenGate for MySQL is installed, you can then set up the database connection as follows:
replicat aurep01 targetdb ogg@aws-aurora-cluster.cluster-cserhpfzdaax.us-east-1.rds.amazonaws.com:3306 userid oracle password AACAAAAAAAAAAAJAWDSBDHKHMBMGVBXAUHWHFAMJVIWGRCSE ENCRYPTKEY default
In this example, ogg is the MySQL database name. The aws-aurora-cluster.cluster-cserhpfzdaax.us-east-1.rds.amazonaws.com:3306 is the cluster endpoint of the Aurora database. The login username is oracle and the password can be provided with AES encryption, or you can create connection USERALIAS in the Oracle GoldenGate Credential Store.
3. Configure the Replicat
With the connection established, the rest of the replication configuration is the same as remote apply configuration for MySQL databases.
3. Configure the Replicat
With the connection established, the rest of the replication configuration is the same as remote apply configuration for MySQL databases.