On Thu, Sep 25, 2008 at 06:14:44PM +0200, Jérôme Jouanin wrote:
> Why it seems a good idea to have 10 replicas at the "main" site ? Because
> our production consists of several octocore / 24Go to serve 1000 queries /
> sec and we have lag time constraint to replicate data <10sec. And obviously
> we have backup databases at our main site.

I find it hard to believe that the overhead of 10 databases isn't
cancelling out some of the benefit you see.  Just a couple such
machines ought easily to stand up to the 1000 qps you mention, unless
the queries are much more complicated than I imagine.

A

-- 
Andrew Sullivan
ajs at commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/