Go back to AWS Console, AWS Database Migration Service screen, click on Endpoints and Create endpoint button.
Create the source endpoint
Use the following parameters to configure the endpoint:
|Endpoint type||Source endpoint|
|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
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 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.
Create the target endpoint
Repeat all steps to create the target endpoint with the following parameter values:
|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)|
|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)|
|User name||(leave the pre-populated value)|
|Password||Enter password you used when you creating the RDS database|
In the Endpoint-specific settings -> Extra connection attributes copy-paste the following connection parameters:
parallelLoadThreads=1; initstmt=SET FOREIGN_KEY_CHECKS=0
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.