Обсуждение: pgpool versus which tool?

Поиск
Список
Период
Сортировка

pgpool versus which tool?

От
Pierre Ochsenbein
Дата:
Hi Guy's,

Which best of tool you recommend to replace pgpool?

Cheers,

Re: pgpool versus which tool?

От
Thomas Kellerer
Дата:
Pierre Ochsenbein schrieb am 15.10.2018 um 09:38:
> Which best of tool you recommend to replace pgpool?
What's wrong with pgPool that you think you need to replace it? 

And what is you requirement for such a tool? 


Re: pgpool versus which tool?

От
Prince Pathria
Дата:
Hey Pierre,

go for pgBouncer if you want transaction based pooling and if your sole aim to use pgPool is for pooling then better go for pgBouncer.
pgBouncer performs 3x better than pgpool-II in benchmarking results.

Thanks!

Prince Pathria
Systems Architect Evive +91 9478670472 goevive.com


On Mon, Oct 15, 2018 at 1:52 PM Thomas Kellerer <spam_eater@gmx.net> wrote:
Pierre Ochsenbein schrieb am 15.10.2018 um 09:38:
> Which best of tool you recommend to replace pgpool?
What's wrong with pgPool that you think you need to replace it?

And what is you requirement for such a tool?

Re: pgpool versus which tool?

От
Achilleas Mantzios
Дата:
In the case of PAM authentication (the only way to do LDAP authentication) pgbouncer is haunted by some nasty bug(s) : https://github.com/pgbouncer/pgbouncer/issues/285

I don't know if pgpool handles PAM better under stress.

On 15/10/18 1:00 μ.μ., Prince Pathria wrote:
Hey Pierre,

go for pgBouncer if you want transaction based pooling and if your sole aim to use pgPool is for pooling then better go for pgBouncer.
pgBouncer performs 3x better than pgpool-II in benchmarking results.

Thanks!
Prince Pathria
Systems Architect Evive +91 9478670472 goevive.com


On Mon, Oct 15, 2018 at 1:52 PM Thomas Kellerer <spam_eater@gmx.net> wrote:
Pierre Ochsenbein schrieb am 15.10.2018 um 09:38:
> Which best of tool you recommend to replace pgpool?
What's wrong with pgPool that you think you need to replace it?

And what is you requirement for such a tool?



-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt

Re: pgpool versus which tool?

От
Pierre Ochsenbein
Дата:
Nothing it's wrong with pgPool.

I would like to try with a new Middelware software to compare mechanism and relation with Load Balancing, HA, Failover..ect

Le lun. 15 oct. 2018 à 10:22, Thomas Kellerer <spam_eater@gmx.net> a écrit :
Pierre Ochsenbein schrieb am 15.10.2018 um 09:38:
> Which best of tool you recommend to replace pgpool?
What's wrong with pgPool that you think you need to replace it?

And what is you requirement for such a tool?



--
Cordialement,

Pierre Ochsenbein
Mobile: +33668295394