we have about 10 servers that host about 500 domains where we offer hosting service with Cpanel, now we have see that the cause of every down is always mysql that use a lot of resource so i would move only mysql o a separate server.
1)Do u think that 1 or 2 Dell Pe 6950 4 x Cpu Quad core cpu with 32Gb of ram can host all the database? each server make about 300query for second
2) or is better to move all on a storage solution with Vmware?
There are hundreds of "basic" guides out there, just ask Google and be prepared to do a lot of reading Generally they cover the most immediate and obvious things you can do to optimise MySQL and squeeze more out of it quickly. Have a search for something called "tuning-primer.sh" which is a shell script you can run to give you some immediate tips based on your current MySQL configuration.
Don't forget though, that they are server side optimisations. These may help, but will never be able to completely alleviate the problems of a poorly designed database schema to begin with. Poor indexing, for example, can really slow things down on large tables. Unfortunately in these cases unless you have a lot of time on your hands, you're pretty much at the mercy of client developers.