Use Case – Your PRIMARY region contains multiple VPCs. So does your BACKUP region.  You would like to create a read replica of from a VPC in your PRIMARY region to a VPC in your BACKUP region.

While you can do this easily, the minute you want ANOTHER read replica in the BACKUP region (or PRIMARY region), you encounter an AWS restriction. That restriction is basically that, WITHIN the same region, your replicas must  belong to the same VPC.

So – what do you do?

There are two ways (CLI and API) you can address this problem.

CLI – Run the following CLI command

aws rds create-db-instance-read-replica ^ –db-instance-identifier myreadreplica ^ –source-db-instance-identifier mydbinstance

API – Calling the API ?

https://rds.amazonaws.com/ ?Action=CreateDBInstanceReadReplica &DBInstanceIdentifier=myreadreplica &SourceDBInstanceIdentifier=mydbinstance &Version=2012-01-15 &SignatureVersion=2 &SignatureMethod=HmacSHA256 &Timestamp=2012-01-20T22%3A06%3A23.624Z &AWSAccessKeyId=<AWS Access Key ID> &Signature=<Signature>

 

Contact Anuj Varma for your high level cloud strategy

Anuj holds professional certifications in Google Cloud, AWS as well as certifications in Docker and App Performance Tools such as New Relic. He specializes in Cloud Security, Data Encryption and Container Technologies.

Initial Consultation

Anuj Varma – who has written posts on Anuj Varma, Hands-On Technology Architect, Clean Air Activist.