Results 1 to 4 of 4
Thread: Which server for mysql only?
-
07-07-2009, 12:38 AM #1Newbie
- Join Date
- Jun 2009
- Posts
- 22
Which server for mysql only?
Which server for mysql only?
Hello,
This is sort of a continuation to this thread here
Based upon the screenshots I provided below. What server would best suit my needs. I need this server to be able to handle the mysql usage and server load.
This server will be only for mysql. The rest of the site (html, videos) will be hosted on a different server.
If you think these servers are not enough for this please let me know any suggestions you have pertaining to server specifications.
Server 1:
Dual Core
Core 2 Duo E4500 2.2Ghz 2MB Cache
500 GB SATA II Hard Drive
2 GB DDR2 SDRAM
Server 2:
Dual Core
Core 2 Duo E8400 3.0Ghz 6MB Cache
500 GB SATA II Hard Drive
4 GB DDR2 SDRAM
Server 3:
Quad Core
Core 2 Quad Q9300 2.5Ghz 6MB Cache
500 GB SATA II Hard Drive
4 GB DDR2 SDRAM
Thank you for your time.
-
07-07-2009, 12:46 AM #2WHT Addict
- Join Date
- Sep 2003
- Location
- Chicago, IL
- Posts
- 165
MySQL needs three things:
1) CPU Horse Power
2) Lots of Memory
3) Fast disk access.
Server 3 would be your best bet. Though if you could get a 15,000RPM SCSI hard drive in there it would make it that much better.
The other two servers are great for file stores not much CPU or memory needed for serving files just a good network to transfer them over.
-
07-07-2009, 01:08 AM #3Newbie
- Join Date
- Jun 2009
- Posts
- 22
Winstyn,
Are those three things listed in order of importance?
Thanks for your time.
-
07-07-2009, 07:23 PM #4Temporarily Suspended
- Join Date
- Jul 2009
- Location
- SLASH ROOT
- Posts
- 26
Well, in the above three configurations you have the same HDD, so disk access can be left out of the question temporarily.
The other two factors entirely depend on the kind of applications that you would be using. Applications like forums etc. would need a bit more CPU processing power and RAM too. This is because it going to have a lot of write cycles(new forum searches)...and also searches(that would take up more memory).
----------------------------
Sr. Systems Engineer
WHRSS
We grow by helping you grow.
Similar Threads
-
Clustered VPS w/ FREE mySQL SLAVE SERVER - HIGH CPU - mySQL, Forums and Wikis
By imountain in forum VPS Hosting OffersReplies: 3Last Post: 08-01-2007, 03:51 PM -
Mysql Failed error after setting up Remote MySQL server in Cpanel
By ReB in forum Dedicated ServerReplies: 13Last Post: 03-28-2007, 12:50 PM -
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
By manisha_khtri in forum Hosting Security and TechnologyReplies: 2Last Post: 06-05-2006, 10:05 AM -
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
By stickygoblin in forum Programming DiscussionReplies: 2Last Post: 06-18-2004, 10:36 AM -
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.
By atul in forum Hosting Security and TechnologyReplies: 5Last Post: 05-11-2004, 12:24 AM