3 ms·
We use PostreSQL. We ran into the issue with Google Cloud SQL (PostreSQL-flavored) that we can not make it multi-region, only multi-zone. With Google Cloud SQ
by bhouston 7y ago
We use PostreSQL. We ran into the issue with Google Cloud SQL (PostreSQL-flavored) that we can not make it multi-region, only multi-zone. With Google Cloud SQL (MySQL-flavored) you can do multi-region.
I would feel much better if we had multi-region failover with PostreSQL just in case a Google Data Center region (which contains the multi-zones) goes completely down (as it did in early June 2019.)
We have some manual solutions to this, but I would have prefered one that just worked with Google Cloud SQL out of the box. I think I am not the only one in this situation with this problem.
- bdcravens 7y agoAWS Aurora also lags Postgresql behind its MySQL offerings.
- bobviolier 7y agoYou also can't do multi-region on Google Cloud SQL (MySQL). The only thing you can do is run your replica on your own VM and configure it to read from the Master in Google Cloud SQL. (Or I am completely missing something)
- laurencerowe 7y ago> Cloud SQL for PostgreSQL does not yet support replication from an external master or external replicas for Cloud SQL instances. https://cloud.google.com/sql/docs/postgres/replication/ https://cloud.google.com/sql/docs/postgres/replication/
- merb 7y agoyou can't do multi-region failover with mysql either. btw. multi-region postgres is also not that easy either. i think the easiest solution would probably to maintain multiple clusters and put something in front of them, like pgpool and write to them simulatiously. if one write fails rollback all clusters. and hope the read replica of cluster x will take over. probably something like pgpool + postgres cluster on k8s(zalando, crunchy). at the moment there is no ledger that can span multiple regions. so your on your own for that. if people really need multi-region they should probably just buy citus data.