Clustering solution ?

On Jul 9, 2020, at 15:53, Laurent FAILLIE <l_faillie@yahoo.com> wrote:

if possible free or not too expensive.

Like all of us.

Hi Laurent,

take a look at Patroni: https://github.com/zalando/patroni

It's free and reliable.

Cheers,
Paul

For high availability, for load sharing or for disaster recovery?

On 7/9/20 8:53 AM, Laurent FAILLIE wrote:

Hello,

I've been asked by one of my customer to know which are the possible
clustering solution for PostgreSQL ?

Active/passive ?
Active/active ?

if possible free or not too expensive.

Thanks

Laurent

--
Angular momentum makes the world go 'round.

Mainly for HA and DR but it can help also for the future if a load balancing is possible. But it's not mandatory yet.

Thanks
Le jeudi 9 juillet 2020 à 17:30:35 UTC+2, Ron <ronljohnsonjr@gmail.com> a écrit :

For high availability, for load sharing or for disaster recovery?

On 7/9/20 8:53 AM, Laurent FAILLIE wrote:

Hello,
I've been asked by one of my customer to know which are the possible clustering solution for PostgreSQL ?
Active/passive ? Active/active ?
if possible free or not too expensive.
Thanks
Laurent

--
Angular momentum makes the world go 'round.

On Thu, 9 Jul 2020 13:53:46 +0000 (UTC)
Laurent FAILLIE <l_faillie@yahoo.com> wrote:

Hello,
I've been asked by one of my customer to know which are the possible
clustering solution for PostgreSQL ? Active/passive ?Active/active ?
if possible free or not too expensive.

Start first by setting up safe and indestructible backups. Look at PITR
backups. Look at pg_backrest to help.

As soon as you have correct backups, you have DR.

Dig some more, optimize, and your PITR backup will be quite fast to restore.

If your RTO is not met with that, dig some more and then, we can talk about
HA, patroni and friends.

Regards,

Hello all,
thanks all for your replies : I started to learn Patroni.Anyway, any alternative with my customer want's also LoadBalancing ?
Thanks
Laurent

Le jeudi 9 juillet 2020 à 17:47:23 UTC+2, Laurent FAILLIE <l_faillie@yahoo.com> a écrit :

Mainly for HA and DR but it can help also for the future if a load balancing is possible. But it's not mandatory yet.

Thanks
Le jeudi 9 juillet 2020 à 17:30:35 UTC+2, Ron <ronljohnsonjr@gmail.com> a écrit :

For high availability, for load sharing or for disaster recovery?

On 7/9/20 8:53 AM, Laurent FAILLIE wrote:

Hello,
I've been asked by one of my customer to know which are the possible clustering solution for PostgreSQL ?
Active/passive ? Active/active ?
if possible free or not too expensive.
Thanks
Laurent

--
Angular momentum makes the world go 'round.

On Wed, 15 Jul 2020 15:54:03 +0000 (UTC)
Laurent FAILLIE <l_faillie@yahoo.com> wrote:

Hello all,
thanks all for your replies : I started to learn Patroni.Anyway, any
alternative with my customer want's also LoadBalancing ? Thanks
Laurent

Same comment than my previous one here. Climb one step at a time.

First, create relevant benchmarks as close as possible from the target
application. Optimize your queries, setup, and lastly your hardware. If your
architecture does not keep up with the load, then you can consider load
balancing. And really, load balancing is hard to achieve for SGBD. It often
requires some changes on application side...or even dealing with it on
application side all together.

I've seen too many complex architectures, with too many layers, hard to
administer...for nothing. Keep it simple as long as you can.

Good luck.

Regards,

--
Jehan-Guillaume de Rorthais
Dalibo