Nilesh , The best thing I would suggest considering a premises solution is to go with Multiple Master or Master-Slave replciation of database . This will make hazzle free synching. Make On-premises database as Master and cloud DB as slave. your GO Layer will talk to Mysql or Postgre layer which will be on premises and when there is a network avaibality it will auto sync. Similar you can also try MongoDB ( latest 4.X ) comes with Group replication , we have used in one of our project but i have no tried the same with this model. you can try this apprach if this works .

You can try dedicated server options as well , there are few companies like tier.net, contabo.com who offer great VPS and dedicated servers at great price point.

Let me know if you need any thing else.

Thanks and Regards Rupen www.voilacabs.com