Results 1 to 8 of 8
-
01-09-2005, 11:15 PM #1Junior Guru Wannabe
- Join Date
- Dec 2002
- Posts
- 82
Massive Mysql Usage - Recommendations
Our site currently uses InvisionPowerBoard and have around 550+ users on at peak times in a 60 minute interval. The site and forums are integrated together and the server load buckles at times.
We have already looked at using other software, but choose not to go that route because we have spent months working on the different codings using InvisionPowerBoard.
We have a 2.8 ghz server with hyperthreading and 1024 ram.
We are going to be expanding soon and using the same database we are planning on adding a different site of the same size.
So in essence, we will double the use of this one single mysql database if not more. What is recommended to handle such a load? What type of server upgrade or load balacing?
Thanks much.
-
01-09-2005, 11:18 PM #2Web Hosting Master
- Join Date
- Feb 2003
- Location
- Potsdam, NY
- Posts
- 648
just throw your database on another server, a dual xeon 2.8 would be good. SCSI would also be a very good idea.
Leave the server you have now for simple HTTP requests.
-
01-10-2005, 12:17 AM #3Web Hosting Master
- Join Date
- Nov 2004
- Location
- Dallas
- Posts
- 740
Load balancing may be useful or like 2uantuM said, 2 servers, one for the database may be useful too
-
01-10-2005, 12:48 AM #4Web Hosting Master
- Join Date
- Jan 2003
- Posts
- 1,715
Forums are read-mostly. Adding enough RAM (probably another gig) to hold the whole database in disk cache would go a long way.
Game Servers are the next hot market!
Slim margins, heavy support, fickle customers, and moronic suppliers!
Start your own today!
-
01-10-2005, 04:19 AM #5Newbie
- Join Date
- Jan 2005
- Posts
- 17
Try MySQL's builtin query caching as well for read-intensive applications.
HTH,
Brian
-
01-11-2005, 12:58 AM #6Aspiring Evangelist
- Join Date
- Nov 2003
- Posts
- 385
definitely use SCSI
-
01-11-2005, 02:21 AM #7Newbie
- Join Date
- May 2003
- Posts
- 9
It would be a far better investment, as hiryuu suggested, for memory. A gigabyte of additional memory will yield a much better return than adding SCSI hard drives.
-
01-11-2005, 03:28 AM #8Junior Guru Wannabe
- Join Date
- Dec 2002
- Posts
- 82
Thanks for the reply guys, will consider.