[google-cloud-sql-discuss] Re: Cloud SQL Postgres Maintainence challenges

You choose a location when you first create the instance. The location can't be changed after the instance is created. Multi-regional backup locations may be chosen, but only for backup purposes. 

The option to choose your maintenance window is offered: you schedule maintenance at a selected day of the week and time, and the order that your instances are updated.

This discussion group is oriented more towards general opinions, trends, and issues of general nature touching the app engine. For coding and program architecture, as well as re-architecting your solution, you may be better served in dedicated forums such as stackoverflow, where experienced programmers are within reach and ready to help. 

On Tuesday, 20 October 2020 at 12:12:06 UTC-4 kishore Rvln wrote:

Current challenges: We are currently using Cloud SQL Postgres for Catalog, Promotions, Business configurations etc. Our back end application has dependency on Postgres stems from the fact that we have some tables which supports JSONB to support our discount structures. But Postgres has a serious drawback of having maintenance slots which are managed by Google and we never know when the maintenance will be performed. Even with read replicas this problem could not be averted. So we created another master, which is a clone of primary instance and weekly we do a manual backup restore to the clone. The master, master-replicas and the clone are load balanced with a ha-proxy.  

I am looking for a help and advise to address on the below use cases:

1. Realtime data sync from one system  to another system.  Business users will be able to use these systems from multiple timezones. 
2. Move existing catalog data, business config data, mapping tables and other general configuration tables to single data source
3. Rearchitect solution to get over PostgresSQL maintenance period issue and ensure higher availability. 

 Thanks

Kishore

--
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/3fc986f2-38a4-45e5-8d7d-b05d0c28f1d9n%40googlegroups.com.