MySQL / PostgreSQL limitation

[Shachar Shemesh]

On 08/23/2011 02:46 AM, Hetz Ben Hamo wrote:On 08/23/2011 02:46 AM, Hetz
Ben Hamo wrote:

> Hi,
>
> I'm thinking about some project, and I was wondering about something:
> lets say I'm setting up a really-big-web site. Something in the scale
> of Walla or Ynet.
> My question is about the DB: Where are exactly my limitations that I
> need to go master/slave, replications etc.
> Is it related to memory? processor? I know that many uses replication
> etc due to shortage or RAM and/or CPU power.
>
> Lets say I have a machine with 512GB RAM, 20 cores, 20TB disks. Such a
> machine should handle a huge load without any issue. With such a
> machine, theoretically, can a single MySQL / PostgreSQL handle such a
> load? (few hundred thousands connected users at once).
>
Please note that there is a difference between the CPU and number of
clients scaling of MySQL and PostgreSQL. Also, questions that have to do
with the usual answers when comparing the two (such as the need for
ACID) also affect your question.
> Thanks,
> Hetz
>
> -- 
On an unrelated side note, the standard way to denote a signature is
with a sequence of "-- ", or dash-dash-space-newline. If you add a space
after the two dashes, most mailers will automatically detect the rest of
your mail as signature.

Shachar

-- 
Shachar Shemesh
Lingnu Open Source Consulting Ltd.
http://www.lingnu.com