By Eric Reid-ISV Engineering-Oracle on Mar 11, 2009
No, really, this isn't a Marketing or Sales FluffPiece! I promise!
Today, Sun announces SSD drives for our servers. One of the proof points we used in support of this was the Drupal CMS. While Drupal 6 doesn't always stress the I/O subsystems themselves (or maybe because of it!), we went ahead to test some pseudo-real-world workloads against Drupal/PHP/Apache/MySQL/Solaris/ZFS. The results are posted today here in the Drupal-on-Sun Wiki site.
What did we find?
- As predicted, more performance benefits were observed with Read-only or Read-Write loads than Write-only (we populated a Drupal MySQL database from script)
- Up to 50% performance improvement was seen in complex Drupal workloads when using SSDs compared to traditional hard disks
- A most cost-effective ZFS Hybrid Storage Pool (utilizing both technologies) provides more modest performance gains for less money
Expected, yes, but still good when it proves out!
Intelligent site and database architectures will be able to take advantage of this technology in ways we've not yet envisioned, especially in a tiered approach that localized most-accessed data in the faster tiers (main memory, Flash/SSD, hard disk).