Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 56915633298 for ; Thu, 19 Feb 2009 10:09:39 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 55371-03 for ; Thu, 19 Feb 2009 10:09:30 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gx0-f176.google.com (mail-gx0-f176.google.com [209.85.217.176]) by mail.postgresql.org (Postfix) with ESMTP id BF15F6332CD for ; Thu, 19 Feb 2009 09:51:38 -0400 (AST) Received: by gxk24 with SMTP id 24so1327430gxk.19 for ; Thu, 19 Feb 2009 05:51:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=WEX6JJYt+MssZhY8+EWUN4Q4umkoUUeiD7QLX1BbKNk=; b=WUq4ZQ4nOy0qaEoEgoLzC+LCcczl1BwU1g85j5jrp+lGuNw+6AKX09CER28n14KRyh dIE3d/ky84pdbyly3YnEVpP66XHM5xdG5xkjpfrAj6aAL3Hr2FaWydFuLF5Ae5h7tedW vpqrm2LT5RwPI6gFWKFdKlfsqHpCr47DkmuV0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=leEvlh32ZhwdcPPCPV1/VhnjlHndwh296Z3/zClEQUqGmkWFz5t3E6ttHQJ5JVWd6a 8hQ5CLiqXOjkrs/glXL5Cdwg0J5qYDNKPcR3LpXVIXdDXPHgL0U2IkPiVzJE5MTeVqDW VUl++W1BSpCU6uMK6YbTjCCBHR2IoIVDPuvns= MIME-Version: 1.0 Received: by 10.150.12.5 with SMTP id 5mr1013943ybl.23.1235051495371; Thu, 19 Feb 2009 05:51:35 -0800 (PST) In-Reply-To: References: <3a0028490902161152l13cc82eva6b26c013776cbcf@mail.gmail.com> Date: Thu, 19 Feb 2009 10:51:35 -0300 Message-ID: <3a0028490902190551k1a49fe2dy7f64083e7ee65940@mail.gmail.com> Subject: Re: Downtime From: Rafael Domiciano To: Scott Marlowe Cc: "pgsql-admin@postgresql.org" Content-Type: multipart/alternative; boundary=000e0cd6b17ca9348f046345d581 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200902/144 X-Sequence-Number: 31365 --000e0cd6b17ca9348f046345d581 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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 wrote: > On Mon, Feb 16, 2009 at 12:52 PM, Rafael Domiciano > 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. > --000e0cd6b17ca9348f046345d581 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi, Scott

Slony is a good software at all, we are using it now to re= plicate real data to a dedicate report server and to a data center and work= s very well.
But when we have some downtime like crash hardware, the tim= e to put the slave node running, even as of less of 1 minute is too long fo= r 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 mor= e upgraded, and there is a lot of bugs and errors.
I'm trying now the CyberCluster from CyberTech, developed under pgclust= er.

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.co= m> wrote:
> Hello for all,
>
> Our bussiness do not tolerate anymore downtime (the downtime is estima= te 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 produc= tion.
> So I'm studying some replications softwares, like pgpool, pg_clust= er,
> pg_replicator.

What exactly was not good enough about slony?  We use it for aut= omated
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.

--000e0cd6b17ca9348f046345d581--