pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rodrigo Hjort <rodrigo.hjort@gmail.com>
To: Brendan Duddridge <brendan@clickspace.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgresql Replication High Availability
Date: Sun, 4 Dec 2005 16:41:33 -0200
Message-ID: <731083980512041041o27e363a0s@mail.gmail.com> (raw)
In-Reply-To: <8C2FC712-48C3-41BA-8596-3052B2B75A25@clickspace.com>
References: <731083980512021932v7b3236cdg@mail.gmail.com>
	<8C2FC712-48C3-41BA-8596-3052B2B75A25@clickspace.com>

Brendam,

We started testing Sequoia last week, and it reached our expectatives
of High Availability and Load Balance. We still need to verify if the
performance is not so degradated due to multiple clusters updating.

What is the difference between Sequoia and p/cluster? I mean, the
latter is a commercial solution offered by Continuent, the same
producer of Sequoia.

Our applications are based on JBoss, connecting to a PostgreSQL via
JDBC. One of the greatest features we found on Sequoia is the URL
style:

"jdbc:sequoia://first_node:port,second_node:port/database"

When a Sequoia Controller is down (eg: first_node), the JDBC tries
another one (ie, second_node), and it occurs transparently to the
application! The JDBC Driver handles it all alone! I don't know if
with a pure PostgreSQL JDBC Driver and the Slony I + Heartbeat joint
solution the application would perform the same behavior...

2005/12/3, Brendan Duddridge <brendan@clickspace.com>:
> Hello Rodrigo,
>
> Have you (or anyone else on this list) had great success with
> Sequoia? I've been reading a bit about it. It looks like it might
> work for us for a high-availability solution. Do you think it's just
> as good as using p/cluster? We're deploying to Mac OS X Server and it
> looks like p/cluster only supports Linux on x86.
>
> Thanks,
>
> ____________________________________________________________________
> Brendan Duddridge | CTO | 403-277-5591 x24 |  brendan@clickspace.com
>
> ClickSpace Interactive Inc.
> Suite L100, 239 - 10th Ave. SE
> Calgary, AB  T2G 0V9
>
> http://www.clickspace.com

Regards,

Rodrigo Hjort
http://www.pr.gov.br



view thread (6+ messages)  latest in thread

Message-ID: <731083980512041041o27e363a0s@mail.gmail.com>
Permalink:  ../731083980512041041o27e363a0s@mail.gmail.com/
Also on:    postgresql.org/message-id/731083980512041041o27e363a0s@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: rodrigo.hjort@gmail.com, brendan@clickspace.com
  Subject: Re: Postgresql Replication High Availability
  In-Reply-To: <731083980512041041o27e363a0s@mail.gmail.com>
  References: <731083980512021932v7b3236cdg@mail.gmail.com> <8C2FC712-48C3-41BA-8596-3052B2B75A25@clickspace.com> <731083980512041041o27e363a0s@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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