Upgrade to Pro — share decks privately, control downloads, hide ads and more …

MySQL and SSD

MySQL and SSD

COSCUP 2008

8327d09b0bd5ac97409aa10f927b3c30?s=128

Gea-Suan Lin

October 11, 2011
Tweet

More Decks by Gea-Suan Lin

Other Decks in Technology

Transcript

  1. MySQL and SSD Gea-Suan Lin gslin@pixnet.tw PIXNET Digital Media Corporation

  2. Outline  Introduction to MySQL and SSD  SSD Spec

     Comparsion in Speed and Price  Something interesting...  Conculsion
  3. MySQL and SSD  MySQL  Open source database 

    Very popular to Web-based company  SSD  Solid-state drive  2006~2007  Very fast random access (in theory)  Fit database characteristic
  4. Conculsion First!  Don't Use SSD to run database 

    At least MySQL...  Unless  I/O bound  Enough Budget
  5. SSD Spec  Mtron  MSP 7000, MSD 3000, MSD

    1000  Memoright  MR25.2  RiData  Ultra-S, Ultra S-Plus  Transcend  TS32GSSD25S-M
  6. SSD Spec Type Read (MB/s) Write (MB/s) Seek time (ms)

    SLC 120 90 0.1 MLC 100 80 0.1 MLC 100 40 0.1 SLC 120 120 SLC 118 74 MLC 128 80 Transcend TS32GSSD25S-M MLC 26 14 Mtron MSP-7000 Mtron MSD-3000 Mtron MSD-1000 Memoright MR25.2 RiData Ultra-S RiData Ultra-S Plus
  7. Test in real environment  Linux 2.6.18 (Debian, testing) 

    XFS, noatime, nodiratime  MySQL 5.1.{21,22,23}, MyISAM  Replication (Slave)  Data size: my boss said we cannot talk about real database size, so don't ask.
  8. Test  Warm up speed  Write speed (Replication write)

     Read speed (Query)
  9. Comparsion  Mtron MSP-7000, Memoright MR25.2  RAID1+0 15KRPM SAS

    (4 disks)  RAID0 15KRPM SAS (2 disks)  Mtron MSD-3000  Mtron MSD-1000  RAID0 10KRPM SATA (2 disks)  Others... (RiData and Transcend)
  10. Something interesting...  No, these won't appear in this slide.

  11. Suggestion Again!  Don't use SSD in Master server. 

    Don't use SSD in Slave servers unless need.  I/O bound that RAID cannot solve  In most cases, you need to buy books to optimize your query statements, not buy SSD.  In some cases, you need to reconstruct your architecture.  Budget
  12. Q&A  Any Question ?