MySQL and SSD

COSCUP 2008

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 ?