SSD Deployment Strategies for MySQL

Presentation: external link
Average rating: ****.
(4.75, 4 ratings)

This session is all about SSDs.
In the first half of the session, I’ll show basic performance numbers
of HDD, Intel X25-E and Fusion I/O. Basic performance means
(concurrent) random reads, random writes, sequential writes, fsyncs,
ext3 vs xfs, etc. SSD specific issues such as write performance
deterioration will also be covered.
In the second half of the session, I’ll present about SSD deployment
strategies for MySQL, for example:

  • Which should I spend, RAM or SSD?
  • Is it fine to store all files on SSD or is it faster to store some
    files (i.e. InnoDB log files) on HDD?
  • Does Nehalem CPU perform well against older Xeon on Fusion I/O? How
    performance differs on disk i/o bound workloads?
  • How redundancy overhead matters, such as H/W RAID, S/W RAID, DRBD?
    Is RAID 5 SSD fast enough? Do traditional H/W raid cards perform well
    for many(4-8) SSDs?
Photo of Yoshinori Matsunobu

Yoshinori Matsunobu

DeNA

Yoshinori Matsunobu is a Principal MySQL Consultant at Sun Microsystems, living in Tokyo. Yoshinori leads MySQL consulting services in Japan and APAC. He has experience in all aspect of MySQL consulting, especially Performance Tuning, High Availability, Scaling Out, MySQL Cluster, and I18N. Yoshinori joined MySQL KK as a Senior MySQL Consultant in September 2006. Before joining MySQL, Yoshinori worked for SONY for 5.5 years as a solution architect. Yoshinori has written eight MySQL related technical books so far and has published technical articles about MySQL, Linux, and Java for a monthly database magazine since 2004.

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.