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

Hi Rodrigo,

So where did you install sequoia? On your application servers? On  
your database servers? Or on dedicated servers running only sequoia?

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

On Dec 4, 2005, at 11:41 AM, Rodrigo Hjort wrote:

> 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
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

Attachments:

  smime.p7s (application/pkcs7-signature, 2.3K) download

view thread (6+ messages)  latest in thread

Message-ID: <8D02A94B-8E41-41BB-B9DB-8C5D29DC143D@clickspace.com>
Permalink:  ../8D02A94B-8E41-41BB-B9DB-8C5D29DC143D@clickspace.com/
Also on:    postgresql.org/message-id/8D02A94B-8E41-41BB-B9DB-8C5D29DC143D@clickspace.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: brendan@clickspace.com, rodrigo.hjort@gmail.com
  Subject: Re: Postgresql Replication High Availability
  In-Reply-To: <8D02A94B-8E41-41BB-B9DB-8C5D29DC143D@clickspace.com>
  References: <731083980512021932v7b3236cdg@mail.gmail.com> <8C2FC712-48C3-41BA-8596-3052B2B75A25@clickspace.com> <731083980512041041o27e363a0s@mail.gmail.com> <8D02A94B-8E41-41BB-B9DB-8C5D29DC143D@clickspace.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