With following kinds of keywords, it is possible to find / search for cloud native (SQL) implementations e.g. with google:
cloud native sql database
E.g. CockroachDB, YugaByteDB.
I do not know are you planning to do it by other means (by yourself).
I myself would be interested, has someone had experiences with such? Is HA provided "ready made? Is HA working fine and does it recover/handle all situations well, or is additional algorithms needed to be implemented in addition on top e.g. for automatic recovery (by "myself").
I could start an other email chain, if this chain is meant more for something else.
Best Regards
Sam
On to, maalisk. 28, 2019 at 12:10, Mariel Cherkassky<mariel.cherkassky@xxxxxxxxx> wrote:Hey,I was searching for a solution to scale my postgresql instance in the cloud. I'm aware of that that I can create many read only replicas in the cloud and it would improve my reading performance. I wanted to hear what solution are you familiar with ? Are there any sharding solution that are commonly used (citus ? pg_shard ?) My instance has many dbs (one per customer) and big customers can generate a load of load on others..Thanks.