Quote Originally Posted by Sandin0 View Post
Don't mean to get off topic.
But the server only has 1 Disk?
if you have even just a few VPS's on that 1 server, the I/O will be VERY slow.
Writing to the disk will take ages, or even querying MySQL for sites.

You should consider having more than 1 disk =/ or atleast raptors or some fast hdd's
Tell me how many hoster out there use raid 0+1 as raid 5 is considered vulnerable than raid 1 (interleave parity is suitable for mysql but not for data which has been improved on raid 0+1. also single hdd failure on raid 5 means you need to replace/rebuilt the faulty hdd before the server can be booted again). Also we are not using software raid but rather a hardware raid. Why bother to get software raid 10 (performance here similar to raid 0) while performance of hardware raid 1 can match it (obviously mirroring data doesnt affect cpu performance read write is normal, and but in any case of failure you still have your data).

Again we are not using software raid or fake raid.

Regarding the MySQL process you mention above. Unless you have sites like myspace (where million/billion of user accessing it every time), active forum like DPF (I still think non raid hdd is enough it just you need dedicated server to handle it. Remember raid 1 is only for mirroring so if you need performance data safety you need raid 0+1 here) ONLY then you should worry about data transfer performance.

So conclusion here is if you only have 1k or 500 user active at 1 time don't even bother to get a dedicated sql server. (in this case, sql is needed for active forum where large amount of data is always updated every single minute)