From: Markus Schiltknecht <markus@bluegap.ch>
To: Bruce Momjian <bruce@momjian.us>
Cc: PostgreSQL-documentation <pgsql-docs@postgresql.org>
Subject: Re: High Availability, Load Balancing, and Replication Feature Matrix
Date: Sun, 18 Nov 2007 13:28:18 +0100
Message-ID: <47402FE2.5000707@bluegap.ch> (raw)
In-Reply-To: <200711161541.lAGFf0e29718@momjian.us>
References: <200711161541.lAGFf0e29718@momjian.us>
Hello Bruce,
Bruce Momjian wrote:
> Uh, I think of PgCluster as multi-master, but in a way it is a hybrid
> because there is a central server that gets all the queries.
Yes, PgCluster as well as Sequoia use statement based replication.
Sequoia is also clearly a middleware (no changes to Postgres needed).
Both suffer from the limitations you describe in "statement based
replication middleware". AFAICT Sequoia does quite well in circumventing
those. (Heck, it even tries to masquerade differences between database
systems, so you can keep a Postgres database in sync with a MySQL one.)
Depending on the RAIDb level you are using, Sequoia can be considered
multi-master (RAIDb-1) or single-master (RAIDb-0). Also note that
sequoia can run multiple controllers, thus it does not rely on one
central server.
So, at least Sequoia is clearly a hybrid, in between your definitions of
"statement based replication middleware" and "synchronous multi-master
replication". Depending on how "middleware" you consider PgCluster, it's
also a hybrid. Certainly it does statement based replication.
Regards
Markus
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 using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: markus@bluegap.ch, bruce@momjian.us
Subject: Re: High Availability, Load Balancing, and Replication Feature Matrix
In-Reply-To: <47402FE2.5000707@bluegap.ch>
* 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