Slony geeignet?

From: Christian Voelker <C(dot)Voelker(at)gmx(dot)net>
To: pgsql-de-allgemein(at)postgresql(dot)org
Subject: Slony geeignet?
Date: 2007-09-19 08:53:49
Message-ID: 070FB527-95A2-43D8-A69C-D718D1D68028@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-de-allgemein

Hallo,

ich habe gerade diesen relativ aktuellen Vergleich
(Februar 2007) zu verschiedenen Möglichkeiten des
Postgres Clusterings gelesen und frage mich, ob
die miserable Bewertung von Slony zutreffend ist.
Eine richtige Version History konnte ich auf der
Slony Seite nicht finden.

<http://wiki.dspace.org/index.php/HOWTO_Clustering#PostgreSQL>
<http://slony.info/>

Gruß, Christian

Zitat:

PostgreSQL

Slony-I

Slony-I is a "master to multiple slaves" replication system.
Unfortunately, it lacks support for many key features I would
consider necessary for clustering:

* No automatic failover or node promotion
* Trigger-based update propogation means that (eg)
schema changes cannot be automatically propogated
across nodes, and it is unable to replicate large
objects
* It is unable to detect node failure
* No support for a multi-master replication topology
(ie: there will always be a single point of failure)
* No support for connection brokering

All of these things combined mean that I will not be looking
into using Slony-I. If anyone has any positive experiences
with using it, please update this section.

Sequoia

Sequoia (formerly C-JDBC) is a drop-in replacement for JDBC.
No code changes are required for DSpace to use Sequoia
in place of the current Postgres or Oracle JDBC drivers.
It is released under an Apache license.

Sequoia claims to support lots of really useful features,
such as RAIDb (think RAID for databases).
(...)

Responses

Browse pgsql-de-allgemein by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2007-09-19 09:05:09 Re: Slony geeignet?
Previous Message Tatsuo Ishii 2007-09-18 14:10:40 Re: Change the name