Date: Thu, 28 Mar 2019 16:10:26 +0000 (UTC)
From: "Sam R." <samruohola@yahoo.com>
Reply-To: "samruohola@yahoo.com" <samruohola@yahoo.com>
To: "mariel.cherkassky@gmail.com" <mariel.cherkassky@gmail.com>,
	PostgreSQL mailing lists <pgsql-performance@postgresql.org>
Message-ID: <2064609649.12651682.1553789426776@mail.yahoo.com>
In-Reply-To: 
 <CA+t6e1nLGxZAGT0bPrGY1r7ag+nGfv+PGcYt1WKsEMNhNNkQrQ@mail.gmail.com>
References: 
 <CA+t6e1nLGxZAGT0bPrGY1r7ag+nGfv+PGcYt1WKsEMNhNNkQrQ@mail.gmail.com>
Subject: Re: Scale out postgresql
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_12651681_843879007.1553789426774"
Content-Length: 4179
Precedence: bulk

------=_Part_12651681_843879007.1553789426774
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi!
With following kinds of keywords, it is possible to find / search for cloud=
 native (SQL) implementations e.g. with google:=C2=A0
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 sit=
uations well, or is additional algorithms needed to be implemented in addit=
ion on top e.g. for automatic recovery (by "myself").
I could start an other email chain, if this chain is meant more for somethi=
ng else.
Best RegardsSam

=20
=20
  On to, maalisk. 28, 2019 at 12:10, Mariel Cherkassky<mariel.cherkassky@gm=
ail.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 solut=
ion that are commonly used (citus ? pg_shard ?) My instance has many dbs (o=
ne per customer) and big customers can generate a load of load on others..


Thanks. =20

------=_Part_12651681_843879007.1553789426774
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi!<div id=3D"yMail_cursorElementTracker_1553788793985"><br></div><div id=
=3D"yMail_cursorElementTracker_1553788794353">With following kinds of keywo=
rds, it is possible to find / search for cloud native (SQL) implementations=
 e.g. with google:&nbsp;</div><div id=3D"yMail_cursorElementTracker_1553788=
844243"><br>cloud native sql database</div><div id=3D"yMail_cursorElementTr=
acker_1553788847928"><br></div><div id=3D"yMail_cursorElementTracker_155378=
8848427">E.g. CockroachDB, YugaByteDB.</div><div id=3D"yMail_cursorElementT=
racker_1553788973346"><br></div><div id=3D"yMail_cursorElementTracker_15537=
88973867">I do not know are you planning to do it by other means (by yourse=
lf).</div><div id=3D"yMail_cursorElementTracker_1553789037001"><br></div><d=
iv id=3D"yMail_cursorElementTracker_1553789037207">I myself would be intere=
sted, 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 addi=
tional algorithms needed to be implemented in addition on top e.g. for auto=
matic recovery (by "myself").</div><div id=3D"yMail_cursorElementTracker_15=
53789168891"><br></div><div id=3D"yMail_cursorElementTracker_1553789169449"=
>I could start an other email chain, if this chain is meant more for someth=
ing else.</div><div id=3D"yMail_cursorElementTracker_1553788938238"><br></d=
iv><div id=3D"yMail_cursorElementTracker_1553788956490">Best Regards</div><=
div id=3D"yMail_cursorElementTracker_1553788962317">Sam<br><div id=3D"ymail=
_android_signature"><br></div> <br> <blockquote style=3D"margin: 0 0 20px 0=
;"> <div style=3D"font-family:Roboto, sans-serif; color:#6D00F6;"> <div>On =
to, maalisk. 28, 2019 at 12:10, Mariel Cherkassky</div><div>&lt;mariel.cher=
kassky@gmail.com&gt; wrote:</div> </div> <div style=3D"padding: 10px 0 0 20=
px; margin: 10px 0 0 0; border-left: 1px solid #6D00F6;"> <div id=3D"yiv549=
4098850"><div dir=3D"rtl"><div style=3D"" dir=3D"ltr">Hey,</div><div style=
=3D"" dir=3D"ltr">I was searching for a solution to scale my postgresql ins=
tance in the cloud. I'm aware of that that I can create many read only repl=
icas 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 p=
er customer) and big customers can generate a load of load on others..</div=
><div style=3D"" dir=3D"ltr"><br></div><div style=3D"" dir=3D"ltr"><br></di=
v><div style=3D"" dir=3D"ltr"><br></div><div style=3D"" dir=3D"ltr">Thanks.=
</div></div></div> </div> </blockquote></div>
------=_Part_12651681_843879007.1553789426774--