Quote:
Originally Posted by HivelocityLB
In my opinion you can't really compare a locally hosted mySQL service and a remotely hosted mySQL service.
Clearly accessing your databases directly from the same disk is going to be faster than accessing your databases from a remotely hosted mySQL service.
 |
As a blanket statement, I don't think so. Yes for minor databases, the lack of a network may be faster - provided the machine isn't underpowered and/or overloaded. However it is quite common to move databases to their own server in larger environments. For high transactional volume, the configuration of a web server and a database server will be radically different... In terms of the 'average website' you are probably correct. But for high tx work, probably not. It at least goes against the prevailing dba wisdom anyway.
For reliability and speed, a typical webserver will run RAID10 arrays. Most database servers run RAID5 or even 5+1 (RAID5 mirrored). The more spindles you can throw at a database the better. I admin a db server with 24 spindles - RAID1 boot, RAID10 os/apps, and RAID5+1 data.