Friday, May 15, 2020

[google-cloud-sql-discuss] Replication mode for Postgres CloudSQL Read Replica

Hello
I'd like to know the data consistency guarantee of Postgres CloudSQL read replicas during normal operations.
According to the documentation here: https://cloud.google.com/sql/docs/postgres/replication "A read replica is a copy of the master that reflects changes to the master instance in almost real time."

My question is: 
1) Is the read replica configured for Cascading (only asynchronous) or Streaming replication?
2) If it is Streaming Replication, is it configured to be Asynchronous or Synchronous streaming replication?
3) If it is Synchronous Streaming replication, what is the synchronous_commit flag set to: off, local, on, remote_write, or remote_apply? These values are described here https://www.postgresql.org/docs/11/warm-standby.html#SYNCHRONOUS-REPLICATION

Thanks!

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/c564e454-5dd7-4352-aa15-126b5bc26be2%40googlegroups.com.

No comments:

Post a Comment