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 |