Create a Replication Instance

Your first task in migrating a database is to create a replication instance that has sufficient storage and processing power to perform the tasks you assign and migrate data from your source database to the target database. The required size of this instance varies depending on the amount of data you need to migrate and the tasks that you need the instance to perform.

1. MySQL Database

  1. In the AWS Console, open Services, Migration & Transfer, Database Migration Service.

  2. In the navigation pane, click Replication instances, then select Create Replication Instance. Create MySQL replication instance

  3. On the Create replication instance page, specify the following settings:

    1. Replication instance configuration

      • Name: MID-REPINST-WP
      • Description: Migration Immersion Day - Rep Inst WordPress
      • Instance class: dms.t2.medium
      • VPC: Target
      • Publicly accessible: Uncheck

      Select MySQL replication instance 1

    2. Advanced security and network configuration

      • Replication subnet group: WP-SubnetGroup
      • Availability zone: the one that ends with a
      • VPC Security groups: select default and the one that contains TargetSecurityGroup

    All other settings can be used as the default values.

  4. Click on Create

Select MySQL replication instance 1

2. PostgreSQL Database

  1. In the AWS Console, open Services, Migration & Transfer, Database Migration Service.

  2. In the navigation pane, click Replication instances, then select Create Replication Instance. Create PostgreSQL replication instance

  3. On the Create replication instance page, specify the following settings:

    1. Replication instance configuration

      • Name: MID-REPINST-OFBIZ
      • Description: Migration Immersion Day - Rep Inst OFBiz
      • Instance class: dms.t2.medium
      • VPC: Target
      • Publicly accessible: Uncheck

      Select PostgreSQL replication instance 1

    2. Advanced security and network configuration

      • Replication subnet group: OFBiz-SubnetGroup
      • Availability zone: the one that ends with a
      • VPC Security groups: select default and the one that contains TargetSecurityGroup

    All other settings can be used as the default values.

  4. Click on Create

Select PostgreSQL replication instance 2

Now, wait for status “Available” in both Replication instances that you just created:

Select PostgreSQL replication instance 2