From: Sam R. <samruohola@yahoo.com>
To: mariel.cherkassky@gmail.com <mariel.cherkassky@gmail.com>
To: PostgreSQL mailing lists <pgsql-performance@postgresql.org>
Subject: Re: Scale out postgresql
Date: Thu, 28 Mar 2019 16:10:26 +0000 (UTC)
Message-ID: <2064609649.12651682.1553789426776@mail.yahoo.com> (raw)
In-Reply-To: <CA+t6e1nLGxZAGT0bPrGY1r7ag+nGfv+PGcYt1WKsEMNhNNkQrQ@mail.gmail.com>
References: <CA+t6e1nLGxZAGT0bPrGY1r7ag+nGfv+PGcYt1WKsEMNhNNkQrQ@mail.gmail.com>
Hi!
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 RegardsSam
On to, maalisk. 28, 2019 at 12:10, Mariel Cherkassky<mariel.cherkassky@gmail.com> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: samruohola@yahoo.com, mariel.cherkassky@gmail.com
Subject: Re: Scale out postgresql
In-Reply-To: <2064609649.12651682.1553789426776@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox