From: | Jonathan Gardner <jgardner(at)jonathangardner(dot)net> |
---|---|
To: | Toni Schlichting <toni(at)schlichting(dot)net>, weigelt(at)metux(dot)de |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: replication/redundancy |
Date: | 2003-06-30 15:31:09 |
Message-ID: | 200306300831.10498.jgardner@jonathangardner.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Sunday 29 June 2003 01:28, Toni Schlichting wrote:
> weigelt(at)metux(dot)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(at)jonathangardner(dot)net>
(was jgardn(at)alumni(dot)washington(dot)edu)
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE/AFe9WgwF3QvpWNwRAvRxAKClx8twjsSyQ0uwqr1ukSUYeQtkuACgxxz3
tsl8mOP53S8PRwMPOMPPy24=
=yDXw
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | weigelt | 2003-06-30 16:17:04 | Re: replication/redundancy |
Previous Message | Daniel Seichter | 2003-06-29 17:44:50 | postgreSQL users = LDAP users? |