Oracle GoldenGate for MySQL supports remote apply. With the remote apply, you can you install Oracle GoldenGate on a remote machine outside the database and connect to MySQL database remotely to apply replicated data. For the data delivery to Amazon Aurora databases, the remote apply can be configured by installing Oracle GoldenGate on an EC2 machine or any machine which you grant the access to the Aurora database endpoints.
2. Configure the Database Connection
After Oracle GoldenGate for MySQL is installed on EC2, 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 password AACAAAAAAAAAAAJAWDSBDHKHMBMGVBXAUHWHFAMJVIWGRCSE ENCRYPTKEY default ...
With the connection established, the rest of the replication configuration is the same as remote apply configuration for MySQL databases.