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?

laurent
  • 179
  • 3
  • 12
  • 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 ( https://aws.amazon.com/about-aws/whats-new/2023/01/amazon-rds-multi-az-readable-standbys-rds-postgresql-inbound-replication/ ). – Tim Jul 07 '23 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" – laurent Jul 09 '23 at 17:11

1 Answers1

1

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

Tim
  • 31,888
  • 7
  • 52
  • 78