How to ensure replica is in sync between AWS RDS PSQL primary DB and Aurora RDS PSQL replica cluster?

0

I am migrating RDS PSQL 11.13 to Aurora PSQL 11.13 provisioned DB instance as a part of that I have created read replica of Auroa PSQL but I couldn't confirm replica status. Replica lag metric in Aurora doesn't show any data? where do I check to confirm sync is up-to-date ?

1 Risposta
0

Please contact AWS Support in case you are not seeing replication lag in your CloudWatch metric. You can also use the query documented here to check replication lag.

"Check the amount of ReplicaLag between source DB instance and replicas. Replica lag is the amount of time, in milliseconds, that a read replica lags behind its source DB instance. This metric reports the result of the following query."

SELECT extract(epoch from now() - pg_last_xact_replay_timestamp()) AS replica_lag
AWS
con risposta 2 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande