I am currently looking into the dedicated server market, and would like to purchase a server to run the following. They will be reasonably high traffic sites, due to the size of the community they will have to serve, and the forums will be paticualarly heavily used.

Portal Site - Database driven news site, with links to content. PHP and MySQL driven.

League Site - Once again PHP and MySQL. Anything from 6 - 13 SQL queries per page.

Forums - Very high usage, should be able to support up to 100 concurrent users, with anything up to 2000 or more registered users.

As you can see, this community is very large, and has a very dedicated following so therefore needs a good dedicated server. If anyone could advise on system specifications to carry these sites, and possibly rough bandwidth then I would be most appreciative, and could start investigating pricing and locations.

Thanks in advanced.

not sure of exact specs but if you anticipate alot of mysql activity i'd divide it into 2 servers, 1 for web serving and 1 dedicated to mysql databases

dual p3 1000mhz with 1 - 2gb ram and fast scsi drives

eva2000.com,

Why would you need a seperate server if you're using a lot of mySQL?

For performance issues. If you're heavily dependent on MySQL it's usually a good idea to give its own server so that you reduce the load on the other web server and speed it up (so you basically spread the load around). MySQL can be a bit of a resource hog if you're not careful.

Originally posted by BC
For performance issues. If you're heavily dependent on MySQL it's usually a good idea to give its own server so that you reduce the load on the other web server and speed it up (so you basically spread the load around). MySQL can be a bit of a resource hog if you're not careful.

How do you get it to work then?

Originally posted by Fiber
Originally posted by BC
For performance issues. If you're heavily dependent on MySQL it's usually a good idea to give its own server so that you reduce the load on the other web server and speed it up (so you basically spread the load around). MySQL can be a bit of a resource hog if you're not careful.

How do you get it to work then?
You can simply change the hostname of your MySQL server from "localhost" to the server name (or IP address) of your mySQL database server. This option should be part of the general configuration of any program or script that uses a MySQL database to store data.

Best Regards,
Matt Lightner
mlightner@site5.com