Kris Saw writes: > We have been using mysql for some time to run and administer our dynamic > content sites. During this time we have run mysql on low end intel > hardware (dual PIII 900 with a gig of RAM) on linux and have discovered > that a single mysql server in this configuration could not handle all > the traffic from our websites. > > To this end we have been forced to run a single central DB that > replicated to slaves running on each webserver. This however limits the > ability of the webservers to serve content, as they have to use > resources for running the DB. > > Right now I am exploring all our options to bring the DB back to one > central location, and want to know what sort of Intel based hardware I > would need to handle this. > > My requirements would be to handle a minimum of 5000 simultaneous > connections/transactions (So my first assumption is that mysql is > capable of that). Can anyone let me know what sort of hardware i need to > be looking at to reach these levels of performance. > > Kris
Hi! The above is a very complex issue. It truly depends on your schema, queries and even application. If you plan to have 5000 users simultaneously connected, you will have to tune up kernel and thread libs a bit. In any case, at least 4 fast CPU's, RAID 1+0 and as much memory as possible. -- Consider taking our support. Visit : https://order.mysql.com Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
