MySQL / PostgreSQL limitation

[Hetz Ben Hamo]

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).

Thanks,
Hetz

-- 

*חץ בן חמו
חץ-ביז
*השכרה ואירוח של שרתים פיזיים
מעוניין להשתמש בשרותים שחסומים לגולש הישראלי? Hulu? NetFlix? Pandora? Google
Voice? אם כן, היכנס לכאן <http://vps.net.bz/?p=406>.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.cs.huji.ac.il/pipermail/linux-il/attachments/20110823/6c735dfd/attachment.html>