Postgres Pro
Downloads
Home   >   mailing lists

Thread: Clustering solution ?

Clustering solution ?

From
Laurent FAILLIE
Date:
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

Re: Clustering solution ?

From
Petite Abeille
Date:

> 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.

Re: Clustering solution ?

From
Paul Förster
Date:
Hi Laurent,

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

It's free and reliable.

Cheers,
Paul


> On 09. Jul, 2020, at 15:53, 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.
>
> Thanks
>
> Laurent

Re: Clustering solution ?

From
Ron
Date:
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.

Re: Clustering solution ?

From
Laurent FAILLIE
Date:
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.

Re: Clustering solution ?

From
Jehan-Guillaume de Rorthais
Date:
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,

Re: Clustering solution ?

From
Laurent FAILLIE
Date:
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.

Re: Clustering solution ?

From
Jehan-Guillaume de Rorthais
Date:
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