At 12:56 AM 10/25/2010, you wrote:
>We are a company for gaming.
>Our main db is mysql 5.1 installed on Linux.
>Currently the hardware for mysql is 2*4 CPU, 16G memory, Raid 10 (four disks).
>Now we have the plan to replace the disks with SSD for better performance.
>Do you think is it right for the SSD solution for mysql?
If you have the money, you can also try Hyperdrive 5 which is a RAM
drive device. It comes in an enclosure similar to a hard drive and looks
like a SATA drive. Each device supports up to 32GB (64GB with 8GBM DIMMS)
of ram and can be raided together to form a larger drive. It has battery
backup and impressive specs: 175MB/s read, 145MB/s write. It has no moving
parts so there is nothing to wear out. It can also be backed up to a hard