Executing the CloudEndure migration module is a requirement for executing the DMS module

AWS Database Migration Services

Now that you just finished to migrate your applications to AWS using CloudEndure, let’s migrate the databases to run in Amazon Aurora using the AWS Database Migration Service tool.

AWS Database Migration Service helps you migrate databases to AWS quickly and securely. The source database remains fully operational during the migration, minimizing downtime to applications that rely on the database. The AWS Database Migration Service can migrate your data to and from most widely used commercial and open-source databases.

AWS Database Migration Service supports homogeneous migrations such as Oracle to Oracle, as well as heterogeneous migrations between different database platforms, such as Oracle or Microsoft SQL Server to Amazon Aurora. With AWS Database Migration Service, you can continuously replicate your data with high availability and consolidate databases into a petabyte-scale data warehouse by streaming data to Amazon Redshift and Amazon S3.

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases.

Amazon Aurora is up to five times faster than standard MySQL databases and three times faster than standard PostgreSQL databases. It provides the security, availability, and reliability of commercial databases at 1/10th the cost. Amazon Aurora is fully managed by Amazon Relational Database Service (RDS), which automates time-consuming administration tasks like hardware provisioning, database setup, patching, and backups.

In this exercise, you perform the following tasks:

  • Create Amazon Aurora database
  • Migrate the existing databases (running in EC2 that you previously migrated using CloudEndure) to Aurora with AWS DMS
  • Update the DNS records to reflect the migration

Current Architecture

The current production environment running in AWS is composed by 2 applications and 4 servers. Wordpress application makes use of 1 database and OFBiz makes use of 3 databases. The focus will be to migrate the database to Aurora as per the following:

Application Hostname FQDN DB Name Platform
Wordpress wordpress-db wordpress-db.onpremsim.env wordpressdb MariaDB
OFBiz ofbiz-db ofbiz-db.onpremsim.env ofbiz PostgreSQL
OFBiz ofbiz-db ofbiz-db.onpremsim.env ofbizolap PostgreSQL
OFBiz ofbiz-db ofbiz-db.onpremsim.env ofbiztenant PostgreSQL