Create Source and Target Endpoints

Create source and target endpoints

Go back to AWS Console, AWS Database Migration Service screen, click on Endpoints and Create endpoint button.

  1. Create the source endpoint

    Use the following parameters to configure the endpoint:

    Parameter Value
    Endpoint type Source endpoint
    Endpoint identifier source-endpoint
    Source engine mysql
    Server name Source Environment - for self-paced lab use information (DBServerDNSName) from the Output section of the ApplicationMigrationWorkshop CloudFormation Template,
    for AWS Events - use Database Server IP from the Event Engine - Team Dashboard
    Port 3306
    SSL mode none
    User name wordpress-user
    Password AWSRocksSince2006

    source-endpoint

    Open Test endpoint connection (optional) section, then in the VPC drop-down select TargetVPC and click the Run test button to verify that your endpoint configuration is valid.

    test-source-endpoint

    Test will run for a minute and you should see successful message in the Status column. Click on the Create endpoint button to create the endpoint.

    In case of any errors - make sure you’ve configured the endpoint parameters correctly and that the Replication Instance was created with Publicly Accessible parameter checked.

  2. Create the target endpoint

    Repeat all steps to create the target endpoint with the following parameter values:

    Parameter Value
    Endpoint type Target endpoint
    Select RDS DB instance checked
    RDS Instance Select your RDS instance from the drop-down (if it’s not visible enter values manually)
    Endpoint Identifier target-endpoint
    Target Engine mysql (will be pre-populated)
    Server Name DNS name of your RDS database (leave the the pre-populated value)
    Port 3306 (will be pre-populated)
    SSL mode none
    User name (leave the pre-populated value)
    Password Enter password you used when you creating the RDS database
  3. In the Endpoint-specific settings -> Extra connection attributes copy-paste the following connection parameters:

    parallelLoadThreads=1; initstmt=SET FOREIGN_KEY_CHECKS=0
    
  4. Under Test endpoint connection (optional) select TargetVPC in the VPC drop down and click the Run test button to verify that your endpoint is valid.

    Test will run for a minute and in the end you should see successful message in the Status column. Click on the Create endpoint button to create the endpoint.

In case of any errors, make sure that the VPC security group of your RDS database allows for inbound traffic on port 3306 from the AWS DMS Replication Instance security group (or for example from the whole TargetVPC - 10.0.0.0/16).

Additional endpoint connection tests can be performed from Endpoints list by clicking the Actions button and then Test connection.