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.

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 !