Friday, May 15, 2020

[google-cloud-sql-discuss] What is the replication mode for Postgres Cloud SQL read replicas?

I think Google Groups ate up my first post, so here's another try:

For Postgres CloudSQL, can someone enlighten me as to how replication to Read Replicas is configured?
The documentation is pretty vague. It simply states: "A read replica is a copy of the master that reflects changes to the master instance in almost real time." The link is https://cloud.google.com/sql/docs/postgres/replication/create-replica

1) Is the replication mode cascading replication or streaming replication?
2) If it is streaming, is it asynchronous or synchronous?
3) If it is synchronous streaming, is it possible to know the value of the synchronous_commit flag? Is it off, local, on, remote_write, or remote_apply? This is as described here: https://www.postgresql.org/docs/11/warm-standby.html#STREAMING-REPLICATION

Thanks in advance!

--
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/5ae51408-48de-4e61-b1bf-7bb04ba537a9%40googlegroups.com.

No comments:

Post a Comment