0

I setup a replica in a different region for my RDS instance. It seems to be working except that the status is always "Replicating". How can I know that the instances are fully in sync? Eventually I would like to promote the replica to master but I want to make sure, first, that all data is on it.

Any idea how to check this?

Improve this question
2
  • There are multiple different types of RDS replication. Please let us know exactly what database you're using, and what replication type. eg read replica, standard multi-AZ, Multi-AZ deployments with two readable standbys ( aws.amazon.com/about-aws/whats-new/2023/01/… ). Commented Jul 7, 2023 at 21:45
  • This is an RDS Postgres database, and the replica is a simple read read replica in a different region. I've just checked again and it still says "Replicating" Commented Jul 9, 2023 at 17:11

1 Answer 1

Reset to default
2

Monitor the Cloudwatch metric "ReplicaLag" (link). If it's zero your replica is up to date.

Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.