Re: replication/redundancy

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sunday 29 June 2003 01:28, Toni Schlichting wrote:
> weigelt@metux.de wrote:
> It seems pgreplication will be the tool you are looking. it is under way
> but it is
> not here yet. It looks as if pgreplication will do much more than just
> enabling a
> hot standby. What I have read up to now looks more like a
> quorum-facility. I hope,
> I didn't get this wrong, because I would have use for something like this.
>

Yes, replication is going to be the next BIG thing in the database world.
Right now, no one (not even Oracle, and I've experience with their system)
has a good solution out there. The stuff that pgreplication is doing is
earth-shatteringly huge. Read through the research paper and see for yourself
what I mean.

    http://www.cs.mcgill.ca/~kemme/papers/vldb00.html

What the original poster is looking for is called "peer-to-peer eager
replication". "peer-to-peer" because there is no master server, "eager"
because the two databases are always exactly the same.

The really cool thing about pgreplication will be that it is hot-swappable. If
one of the servers goes down, the whole thing will still work. You can also
add databases to the system on-the-fly. That way, you can always keep one (or
two or three) extra stand-by databases.

- --
Jonathan Gardner <jgardner@jonathangardner.net>
(was jgardn@alumni.washington.edu)
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/AFe9WgwF3QvpWNwRAvRxAKClx8twjsSyQ0uwqr1ukSUYeQtkuACgxxz3
tsl8mOP53S8PRwMPOMPPy24=
=yDXw
-----END PGP SIGNATURE-----