Re: Performance and Clustering

On 29/04/2010 10:04 AM, Greg Smith wrote:
> Jaime Rodriguez wrote:
>> My customer requires that DBMS shall support 4000 simultaneous requests
>> Also the system to be deploy maybe a cluster, with 12 microprocessors
> [snip]
> If most connections are read-only, there are a few ways to design a
> cluster of systems to support the sort of design needed to scale up to
> where you're aiming at. Getting more than one node you can write to in a
> cluster is much harder.

If most of the connections are read-only then in addition to using a
connection pooler and/or read slave cluster, you can look into getting
the customer to using memcached as a midlayer. They should see a huge
performance boost if they're prepared to do the work.

--
Craig Ringer