pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDowntime
3+ messages / 2 participants
[nested] [flat]
* Downtime
@ 2009-02-16 19:52 Rafael Domiciano <rafael.domiciano@gmail.com>
2009-02-16 20:01 ` Re: Downtime Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Rafael Domiciano @ 2009-02-16 19:52 UTC (permalink / raw)
To: pgsql-admin
Hello for all,
Our bussiness do not tolerate anymore downtime (the downtime is estimate at
10 hour / year - that involves upgrade of hardware, crash of hardware), and
using Slony-I 1.2.15 I have waste time to put the slave node on production.
So I'm studying some replications softwares, like pgpool, pg_cluster,
pg_replicator.
Pgpool has a good idea, I can connect at 2 servers or more at the same time.
But I have some limitations, like Replication, Datas generated by the
servers (CURRENT_DATE, CURRENT_TIME, serial, oid); so I discarded it.
I tryed pg_cluster, but the documentation is very poor, and the installation
was unsuccesfull.
I would like to know from you what solution you uses for avoiding downtime,
so I could choose the solution that is best to my scenario and for others
that is begining in Postgres and is a little lost in replication.
Thnks for all,
Rafael Domiciano
DBA Postgres
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Downtime
2009-02-16 19:52 Downtime Rafael Domiciano <rafael.domiciano@gmail.com>
@ 2009-02-16 20:01 ` Scott Marlowe <scott.marlowe@gmail.com>
2009-02-19 13:51 ` Re: Downtime Rafael Domiciano <rafael.domiciano@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Scott Marlowe @ 2009-02-16 20:01 UTC (permalink / raw)
To: Rafael Domiciano <rafael.domiciano@gmail.com>; +Cc: pgsql-admin
On Mon, Feb 16, 2009 at 12:52 PM, Rafael Domiciano
<rafael.domiciano@gmail.com> wrote:
> Hello for all,
>
> Our bussiness do not tolerate anymore downtime (the downtime is estimate at
> 10 hour / year - that involves upgrade of hardware, crash of hardware), and
> using Slony-I 1.2.15 I have waste time to put the slave node on production.
> So I'm studying some replications softwares, like pgpool, pg_cluster,
> pg_replicator.
What exactly was not good enough about slony? We use it for automated
failover which is initiated by the application if it detects the
master go down. Works pretty well. Our downtime for unscheduled
maintenance is well under an hour a year with this setup.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Downtime
2009-02-16 19:52 Downtime Rafael Domiciano <rafael.domiciano@gmail.com>
2009-02-16 20:01 ` Re: Downtime Scott Marlowe <scott.marlowe@gmail.com>
@ 2009-02-19 13:51 ` Rafael Domiciano <rafael.domiciano@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Rafael Domiciano @ 2009-02-19 13:51 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: pgsql-admin
Hi, Scott
Slony is a good software at all, we are using it now to replicate real data
to a dedicate report server and to a data center and works very well.
But when we have some downtime like crash hardware, the time to put the
slave node running, even as of less of 1 minute is too long for the company
bussiness, loosing a great amount of sales authorizations.
So we need a solution that in the time of crash another server right in the
moment could be working, receiving connections and transactioning.
This week I installed and used pg_cluster. I liked the idea of the software,
and is that what i'm looking for. But pg_cluster seems that is no more
upgraded, and there is a lot of bugs and errors.
I'm trying now the CyberCluster from CyberTech, developed under pgcluster.
I hope that you could understand the scenario.
Thnks,
Rafael Domiciano
On Mon, Feb 16, 2009 at 5:01 PM, Scott Marlowe <scott.marlowe@gmail.com>wrote:
> On Mon, Feb 16, 2009 at 12:52 PM, Rafael Domiciano
> <rafael.domiciano@gmail.com> wrote:
> > Hello for all,
> >
> > Our bussiness do not tolerate anymore downtime (the downtime is estimate
> at
> > 10 hour / year - that involves upgrade of hardware, crash of hardware),
> and
> > using Slony-I 1.2.15 I have waste time to put the slave node on
> production.
> > So I'm studying some replications softwares, like pgpool, pg_cluster,
> > pg_replicator.
>
> What exactly was not good enough about slony? We use it for automated
> failover which is initiated by the application if it detects the
> master go down. Works pretty well. Our downtime for unscheduled
> maintenance is well under an hour a year with this setup.
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2009-02-19 13:51 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-02-16 19:52 Downtime Rafael Domiciano <rafael.domiciano@gmail.com>
2009-02-16 20:01 ` Scott Marlowe <scott.marlowe@gmail.com>
2009-02-19 13:51 ` Rafael Domiciano <rafael.domiciano@gmail.com>
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