RDS

Restore RDS Database

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-1a 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 Customer 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 Security Group

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.