| From: | "Jim C(dot) Nasby" <jim(at)nasby(dot)net> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] Replication documentation addition |
| Date: | 2006-10-24 23:50:45 |
| Message-ID: | 20061024235045.GX26892@nasby.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-hackers |
On Mon, Oct 23, 2006 at 11:39:34PM -0400, Bruce Momjian wrote:
> Query Broadcast Replication
> ---------------------------
>
> This involves sending write queries to multiple servers. Read-only
> queries can be sent to a single server because there is no need for all
> servers to process it. This can be complex to setup because functions
> like random() and CURRENT_TIMESTAMP will have different values on
> different servers, and sequences should be consistent across servers.
> Pgpool implements this type of replication.
Isn't there another active project that does this besides pgpool?
It's probably also worth mentioning the commercial replication schemes
that are out there.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-10-24 23:58:14 | Re: [HACKERS] Replication documentation addition |
| Previous Message | Joshua D. Drake | 2006-10-24 23:24:41 | Re: [HACKERS] Replication documentation addition |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-10-24 23:58:14 | Re: [HACKERS] Replication documentation addition |
| Previous Message | Joshua D. Drake | 2006-10-24 23:24:41 | Re: [HACKERS] Replication documentation addition |