Cloud SQL Postgres Maintainence challenges

26 views
Skip to first unread message

kishore Rvln

unread,
Oct 20, 2020, 12:12:06 PM10/20/20
to Google Cloud SQL discuss
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

George (Cloud Platform Support)

unread,
Oct 21, 2020, 10:48:43 AM10/21/20
to Google Cloud SQL discuss
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. 
Reply all
Reply to author
Forward
0 new messages