From: | "Steve Wolfe" <steve(at)iboats(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Database cluster? |
Date: | 2000-11-30 22:13:48 |
Message-ID: | 002701c05b1a$d95b71e0$50824e40@iboats.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> The proxy monitors and forwards the requests from the clients to the
> database servers. If it is a read-only request the query is forwarded to
> the databaseserver currently experiencing the lowest load/most free
> memory, otherwise it is sent to all database servers.
>
> This approach obviously only performs well in systems with a high ratio of
> read-only queries, such as search engines and so on.
The tough part is syncronicity, should one of the machines drop out of the
cluster and need to be re-added without bringing the others down. In order
to get around that, each query needs to be logged on the master node with a
timestamp, so that the failed node can "catch up" in real-time. That brings
about other considerations, as well....
steve
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Korsgaard | 2000-11-30 22:15:31 | Re: Database cluster? |
Previous Message | Hancock, David (DHANCOCK) | 2000-11-30 21:18:05 | RE: Help with Database Recovery |