Score:0

How to know if an AWS RDS instance is fully replicated?

tj flag

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?

Tim avatar
gp flag
Tim
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/ ).
laurent avatar
tj flag
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"
Score:1
gp flag
Tim

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

I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.