Re: Scale out postgresql

From: "Sam R(dot)" <samruohola(at)yahoo(dot)com>
To: "mariel(dot)cherkassky(at)gmail(dot)com" <mariel(dot)cherkassky(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Scale out postgresql
Date: 2019-03-28 16:10:26
Message-ID: 2064609649.12651682.1553789426776@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(dot)cherkassky(at)gmail(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mariel Cherkassky 2019-03-28 16:19:00 Re: Scale out postgresql
Previous Message Mariel Cherkassky 2019-03-28 10:10:05 Scale out postgresql