Currently, Google Cloud SQL for PostgreSQL does not support logical replication.
However, I need to build a sync service between two databases (one Cloud SQL instance and one External Database instance).
Some of the tables of the External Database must work as a master table and some as slave tables. The same applies to the Cloud SQL instance.
Also, I don't necessarily need to stream the changes. It could be run in a batch.
I need to use CloudSQL and not GCE for this.
Is there an alternative way to do logical replication leveraging PostgreSQL's WAL in CloudSQL? The only option I can see to gather the CDC is by using triggers, but that implies in overhead in both databases and other issues as well.
I don't know if Google Cloud Dataflow would be an overkill for this situation.
Thanks in advance. I would be really grateful if someone could help me on this.
-- However, I need to build a sync service between two databases (one Cloud SQL instance and one External Database instance).
Some of the tables of the External Database must work as a master table and some as slave tables. The same applies to the Cloud SQL instance.
Also, I don't necessarily need to stream the changes. It could be run in a batch.
I need to use CloudSQL and not GCE for this.
Is there an alternative way to do logical replication leveraging PostgreSQL's WAL in CloudSQL? The only option I can see to gather the CDC is by using triggers, but that implies in overhead in both databases and other issues as well.
I don't know if Google Cloud Dataflow would be an overkill for this situation.
Thanks in advance. I would be really grateful if someone could help me on this.
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/5df870d7-0cec-489a-bec5-b632b3d1b22c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment