Re: Postgresql Replication High Availability

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxx

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@xxxxxxxxxxxxxx>:
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@xxxxxxxxxxxxxx

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


Attachment: smime.p7s
Description: S/MIME cryptographic signature


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux