pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Pgpool-II, pgcluster, or pgbouncer?
5+ messages / 3 participants
[nested] [flat]

* Pgpool-II, pgcluster, or pgbouncer?
@ 2014-07-17 16:53  Joseph Mays <mays@win.net>
  0 siblings, 3 replies; 5+ messages in thread

From: Joseph Mays @ 2014-07-17 16:53 UTC (permalink / raw)
  To: pgsql-admin

I have a site that has a postgres database server. 24 hour availability is pretty critical to them, so I want to turn it into a redundant cluster for high availability. I currently have a streaming backup server, but we want to be able to make either server capable of accepting writes in the case one fails. The problem with streaming backup is that we can promote the backup when the master fails, but when the master comes backup you basically have to rebuild the entire database and reconfigure postgres on it to either make it the master or make it into a new streaming backup. We want something that’s much more dynamic, so writes can go either direction in the event of one or the failing, and so that things will automatically resync when a failed server in the cluster comes back online.

Given these goals – pgpool-II, pgcluster, pgbouncer? Some other tool that I haven’t even considered?

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Pgpool-II, pgcluster, or pgbouncer?
@ 2014-07-17 17:08  Jorge Fernandez <jorge.fernandez@openenglish.com>
  parent: Joseph Mays <mays@win.net>
  2 siblings, 0 replies; 5+ messages in thread

From: Jorge Fernandez @ 2014-07-17 17:08 UTC (permalink / raw)
  To: Joseph Mays <mays@win.net>; +Cc: pgsql-admin

repmgr may do the work, but you have to script the promote.sh to migrate
the hostname or elastic Ip to direct the request to the new master, after
the crash you have to manually do the failback: (clone-sync-failover)

pgpool II  with hot-stream mode is pretty sensitive to detect a failover
and promote the slave  , causing false-failover scenario.


2014-07-17 13:53 GMT-03:00 Joseph Mays <mays@win.net>:

>   I have a site that has a postgres database server. 24 hour availability
> is pretty critical to them, so I want to turn it into a redundant cluster
> for high availability. I currently have a streaming backup server, but we
> want to be able to make either server capable of accepting writes in the
> case one fails. The problem with streaming backup is that we can promote
> the backup when the master fails, but when the master comes backup you
> basically have to rebuild the entire database and reconfigure postgres on
> it to either make it the master or make it into a new streaming backup. We
> want something that’s much more dynamic, so writes can go either direction
> in the event of one or the failing, and so that things will automatically
> resync when a failed server in the cluster comes back online.
> Given these goals – pgpool-II, pgcluster, pgbouncer? Some other tool that
> I haven’t even considered?
>
>
>



-- 

*Jorge Daniel Fernandez*
Leader - DBA Team

S: elgaita99   |  t:@openenglish
w: www.openenglish.com

 <http://www.openenglish.com/;
Opensoft Argentina S.R.L
552 Suipacha , Piso 3to, Capital Federal
Argentina, (C1022AAR)

(*) The content of this electronic message may be privileged and
confidential.
(*) If you are not an intended recipient of this email, please delete it
and do not use it.
(*) The Open English name and the Open English logo are registered
trademarks.
(*) Opensoft Argentina S.R.L is a vendor company of Open English LLC.



<http://www.openenglish.com/;

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Pgpool-II, pgcluster, or pgbouncer?
@ 2014-07-17 17:33  Joseph Mays <mays@win.net>
  parent: Gilberto Castillo <gilberto.castillo@etecsa.cu>
  0 siblings, 0 replies; 5+ messages in thread

From: Joseph Mays @ 2014-07-17 17:33 UTC (permalink / raw)
  To: pgsql-admin

> Your need multi-Master?

I am assuming that will give us the highest availability with the most
dynamic failover and recovery, yes.


-----Original Message----- 
From: Gilberto Castillo
Sent: Thursday, July 17, 2014 2:00 PM
To: Joseph Mays
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Pgpool-II, pgcluster, or pgbouncer?



> I have a site that has a postgres database server. 24 hour availability is
> pretty critical to them, so I want to turn it into a redundant cluster for
> high availability. I currently have a streaming backup server, but we want
> to be able to make either server capable of accepting writes in the case
> one fails. The problem with streaming backup is that we can promote the
> backup when the master fails, but when the master comes backup you
> basically have to rebuild the entire database and reconfigure postgres on
> it to either make it the master or make it into a new streaming backup. We
> want something that’s much more dynamic, so writes can go either direction
> in the event of one or the failing, and so that things will automatically
> resync when a failed server in the cluster comes back online.
>
> Given these goals – pgpool-II, pgcluster, pgbouncer? Some other tool that
> I haven’t even considered?

Your need multi-Master?

Saludos,
Gilberto Castillo
La Habana, Cuba






--- 
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running 
at host imx3.etecsa.cu
Visit our web-site: <http://www.kaspersky.com;, <http://www.viruslist.com;







-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin 



-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Pgpool-II, pgcluster, or pgbouncer?
@ 2014-07-17 17:35  Joseph Mays <mays@win.net>
  parent: Joseph Mays <mays@win.net>
  2 siblings, 0 replies; 5+ messages in thread

From: Joseph Mays @ 2014-07-17 17:35 UTC (permalink / raw)
  To: pgsql-admin

I only just now discovered postgres-xc. Is there anyone out there using it in a production environment who can comment on it?

From: Joseph Mays 
Sent: Thursday, July 17, 2014 12:53 PM
To: pgsql-admin@postgresql.org 
Subject: [ADMIN] Pgpool-II, pgcluster, or pgbouncer?

I have a site that has a postgres database server. 24 hour availability is pretty critical to them, so I want to turn it into a redundant cluster for high availability. I currently have a streaming backup server, but we want to be able to make either server capable of accepting writes in the case one fails. The problem with streaming backup is that we can promote the backup when the master fails, but when the master comes backup you basically have to rebuild the entire database and reconfigure postgres on it to either make it the master or make it into a new streaming backup. We want something that’s much more dynamic, so writes can go either direction in the event of one or the failing, and so that things will automatically resync when a failed server in the cluster comes back online.

Given these goals – pgpool-II, pgcluster, pgbouncer? Some other tool that I haven’t even considered?

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Pgpool-II, pgcluster, or pgbouncer?
@ 2014-07-17 18:00  Gilberto Castillo <gilberto.castillo@etecsa.cu>
  parent: Joseph Mays <mays@win.net>
  2 siblings, 1 reply; 5+ messages in thread

From: Gilberto Castillo @ 2014-07-17 18:00 UTC (permalink / raw)
  To: Joseph Mays <mays@win.net>; +Cc: pgsql-admin



> I have a site that has a postgres database server. 24 hour availability is
> pretty critical to them, so I want to turn it into a redundant cluster for
> high availability. I currently have a streaming backup server, but we want
> to be able to make either server capable of accepting writes in the case
> one fails. The problem with streaming backup is that we can promote the
> backup when the master fails, but when the master comes backup you
> basically have to rebuild the entire database and reconfigure postgres on
> it to either make it the master or make it into a new streaming backup. We
> want something that’s much more dynamic, so writes can go either direction
> in the event of one or the failing, and so that things will automatically
> resync when a failed server in the cluster comes back online.
>
> Given these goals – pgpool-II, pgcluster, pgbouncer? Some other tool that
> I haven’t even considered?

Your need multi-Master?

Saludos,
Gilberto Castillo
La Habana, Cuba
--- 
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
Visit our web-site: <http://www.kaspersky.com;, <http://www.viruslist.com;

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2014-07-17 18:00 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-07-17 16:53 Pgpool-II, pgcluster, or pgbouncer? Joseph Mays <mays@win.net>
2014-07-17 17:08 ` Jorge Fernandez <jorge.fernandez@openenglish.com>
2014-07-17 17:35 ` Joseph Mays <mays@win.net>
2014-07-17 18:00 ` Gilberto Castillo <gilberto.castillo@etecsa.cu>
2014-07-17 17:33   ` Joseph Mays <mays@win.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox