MySQL System Stability

MySQL System Stability

Speaker: Gea-Suan Lin (@gslin), KKBOX Inc.
Topic: MySQL System Stability
Conference: COSCUP 2012 (in Taipei, Taiwan)

In this slide, we'll explain how to increase uptime, reduce downtime, and keep quality (latency) in MySQL system.

8327d09b0bd5ac97409aa10f927b3c30?s=128

Gea-Suan Lin

August 16, 2012
Tweet

Transcript

  1. MySQL System Stability Gea-Suan Lin KKBOX Inc.

  2. As usual, before we start...

  3. We’re hiring !

  4. Visit KKBOX’s Booth

  5. Let’s start this topic...

  6. MySQL System Stability

  7. Including...

  8. Uptime (Service Time)

  9. Latency (Response Time)

  10. Downtime (Recovery Time)

  11. You need to know something in advance...

  12. MySQL - The Old Way

  13. https://speakerdeck.com/ u/gslin/p/mysql-the-old- way

  14. Or, tinyurl.com/9pas6cf

  15. Which describe old and reliable ways to build MySQL service

  16. This slide will offer policies to:

  17. Increase Uptime

  18. Reduce Downtime

  19. 1st Policy

  20. Buy BIG Hardware

  21. It’s simplest way

  22. RAM

  23. RAM will be large enough to fit hot data

  24. If you don’t know “hot data”, then just “data”

  25. RAM is cheap

  26. 2nd Policy

  27. Use InnoDB

  28. Support transactions

  29. (Although we will avoid to use transactions in most cases)

  30. Write won’t block read (Almost)

  31. InnoDB supports compression

  32. Possible smaller than MyISAM

  33. Requirement of online schema changing (without downtime)

  34. And, after MySQL 5.6...

  35. Support memcached protocol

  36. Support fulltext search

  37. 3rd Policy

  38. Database Normalization

  39. Reduce data duplication

  40. Also reduce the need of ALTER TABLE

  41. 4th Policy

  42. Monitor Everything

  43. CPU Usage

  44. RAM Usage

  45. I/O Usage

  46. Network Usage

  47. Query Per Second

  48. Slow Query Log

  49. Last Policy

  50. Subscribe blogs about database

  51. MySQL Performance Blog www.mysqlperformanceblog.com

  52. MySQL at Facebook www.facebook.com/MySQLatFacebook

  53. That’s all...

  54. Thanks !