Restore RDS Database

If you are running this workshop as part of an instructor led workshop, the RDS has already been restored to the N. California (us-west-1) region due to time constraints. Please review the steps in this section so you understand how the restore should work and then continue with the Configure Security Group Section below.

1.1 Click AWS Backup to navigate to the dashboard in the N. California (us-west-1) region.

1.2 Click the Backup Vaults link, then click the Default link.

1.3 In the Backups section. Select the backup. Click Restore under the Actions dropdown.

If you don’t see your backup, check the status of the Copy Job. Click AWS Backup to navigate to the dashboard in N. Virginia (us-east-1) region. Click the Jobs link, then click the Copy jobs link. Verify the Status of your backup is Completed.

1.4 In the Settings section, enter backupandrestore-secondary-region as the DB Instance Identifier. Under Network & Security section, select us-west-xx as the Availability zone.

1.5 Click the Restore backup button.

Configure Security Group

2.1 Click VPC to navigate to the dashboard in the N. California (us-west-1) region.

2.2 Click the Security Groups link, then click the Create security group button.

2.3 In the Basic details section, enter backupandrestore-us-west-rds-SG as the Security group name and Description.

2.4 in the Inbound Rules section, click the Add rule button. Select MYSQL/Aurora as the Type. Select Custom as the Source and choose backupandrestore-us-west-ec2-SG. This will allow the communication between your EC2 instance and your RDS instance. Click the Create security group button.

Modify RDS

3.1 Click RDS to navigate to the dashboard in the N. California (us-west-1) region.

3.2 Click the DB Instances link.

3.3 Select backupandrestore-secondary-region, then click the Modify button.

The database must have a Status of Available.

3.4 In the Connectivity section, select backupandrestore-us-west-rds-SG as the Security group. Click the Continue button.

3.5 Select Apply immediately and then click the Modify DB instance button..

3.6 Click the backupandrestore-secondary-region link.

Copy the name of the endpoint and port. You will need this in a later step.