Specify Source and Target Endpoints

While your replication instance is being created, you can specify the source and target data stores. The source and target data stores can be on an Amazon Elastic Compute Cloud (Amazon EC2) instance, an Amazon Relational Database Service (Amazon RDS) DB instance, or an on-premises database.

We will create 8 endpoints. A MySQL source and target for the Wordpress application and a PostgreSQL source and target for the OFBiz application. Note that OFBiz application uses 3 different databases in the same EC2 (ofbiz, ofbizolap and ofbiztenant) and will be migrated to a single Aurora Postgres instance.

Engine Source Target Database Name
MySQL/MariaDB EC2 wordpress-db MariaDB RDS Aurora MySQL wordpressdb
PostgreSQL EC2 ofbiz-db PostgreSQL RDS Aurora PostgreSQL ofbiz
PostgreSQL EC2 ofbiz-db PostgreSQL RDS Aurora PostgreSQL ofbizolap
PostgreSQL EC2 ofbiz-db PostgreSQL RDS Aurora PostgreSQL ofbiztenant