lundi 9 mai 2011

Install and forget a story of stability...

Are you rebooting your MySQL server at night?

I'de like to share input send to me by a leading MySQL provider, mostly deploying ecommerce and telco applications on Linux.

One instance is up since 1414 days not bad ....

 
18:13:02 up 355 days,  4:50,  0 users,  load average: 0.00, 0.00, 0.00
18:13:03 up 594 days,  5:04,  0 users,  load average: 1.20, 1.25, 1.26
18:13:03 up 48 days, 22:10,  0 users,  load average: 0.48, 0.38, 0.29
18:13:03 up 936 days,  7:50,  0 users,  load average: 0.00, 0.00, 0.00
18:13:03 up 173 days,  2:39,  0 users,  load average: 1.90, 1.79, 1.79
18:13:04 up 244 days,  3:25,  0 users,  load average: 3.96, 3.66, 3.90
18:13:04 up 643 days, 15:50,  0 users,  load average: 0.09, 0.08, 0.07
18:13:04 up 642 days,  5:15,  0 users,  load average: 0.06, 0.02, 0.00
18:13:05 up 311 days,  1:57,  1 user,  load average: 0.01, 0.03, 0.00
18:13:05 up 329 days,  4:43,  0 users,  load average: 1.07, 0.55, 0.34
18:13:05 up 95 days, 11:34,  0 users,  load average: 2.27, 1.74, 1.64
18:13:06 up 436 days, 23:42,  0 users,  load average: 0.09, 0.10, 0.13
18:13:06 up 188 days,  2:35,  0 users,  load average: 0.10, 0.19, 0.14
18:13:12 up 347 days, 12:57,  0 users,  load average: 0.08, 0.16, 0.22
18:13:12 up 81 days, 11:32,  0 users,  load average: 0.04, 0.19, 0.28
18:13:12 up 81 days, 11:24,  0 users,  load average: 0.33, 0.40, 0.43
18:13:12 up 81 days, 11:13,  0 users,  load average: 0.28, 0.35, 0.36
18:07:39 up 21 days,  6:40,  0 users,  load average: 0.12, 0.14, 0.10
18:13:13 up 643 days, 16:11,  0 users,  load average: 0.36, 0.19, 0.11
18:13:13 up 643 days, 16:10,  0 users,  load average: 0.09, 0.07, 0.02
18:13:13 up 139 days, 35 min,  0 users,  load average: 0.38, 0.35, 0.29
18:13:14 up 179 days, 11:41,  0 users,  load average: 0.12, 0.07, 0.01
18:13:14 up 634 days,  4:40,  0 users,  load average: 0.00, 0.00, 0.00
18:13:14 up 343 days,  3:33,  0 users,  load average: 0.02, 0.05, 0.00
18:13:14 up 441 days,  2:37,  0 users,  load average: 0.13, 0.31, 0.31
18:13:19 up 160 days,  8:19,  0 users,  load average: 0.01, 0.05, 0.01
18:13:20 up 83 days, 22:34,  0 users,  load average: 0.07, 0.10, 0.09
18:13:25 up 602 days,  1:50,  0 users,  load average: 0.01, 0.03, 0.00
18:13:25 up 1414 days,  6:07,  0 users,  load average: 0.00, 0.03, 0.00
18:13:26 up 7 days,  6:32,  0 users,  load average: 0.11, 0.17, 0.20
18:13:26 up 17 days,  2:38,  0 users,  load average: 0.61, 0.49, 0.40
18:13:26 up 17 days,  2:42,  0 users,  load average: 0.10, 0.31, 0.35
18:13:32 up 284 days,  5:03,  0 users,  load average: 1.12, 0.78, 0.67
18:13:32 up 599 days, 40 min,  0 users,  load average: 0.00, 0.00, 0.00
18:13:32 up 320 days,  7:44,  0 users,  load average: 0.06, 0.07, 0.02
18:13:33 up 28 days,  7:00,  3 users,  load average: 0.04, 0.05, 0.01
18:13:33 up 12 days,  8:52,  2 users,  load average: 0.31, 0.07, 0.02
18:13:33 up 68 days,  8:33,  0 users,  load average: 0.00, 0.02, 0.00
18:13:33 up 265 days,  6:36,  0 users,  load average: 0.00, 0.00, 0.00
18:13:34 up 515 days,  3:03,  0 users,  load average: 0.00, 0.00, 0.00
18:13:34 up 97 days, 22:44,  0 users,  load average: 0.06, 0.10, 0.09
18:13:34 up 118 days,  3:38,  1 user,  load average: 0.02, 0.02, 0.00
18:13:35 up 12 days, 17:07,  0 users,  load average: 0.01, 0.07, 0.04
18:13:35 up 18 days,  1:25,  0 users,  load average: 0.39, 0.37, 0.30
18:13:35 up 97 days,  6:02,  0 users,  load average: 0.00, 0.26, 0.31
18:13:36 up 410 days,  7:48,  0 users,  load average: 0.00, 0.00, 0.00
18:13:36 up 538 days, 11:38,  0 users,  load average: 0.01, 0.01, 0.00
18:13:36 up 207 days,  6:56,  0 users,  load average: 0.49, 0.52, 0.54
18:13:37 up 332 days,  8:49,  0 users,  load average: 0.01, 0.02, 0.00
18:13:37 up 263 days,  3:25,  0 users,  load average: 0.01, 0.02, 0.00
18:13:38 up 469 days, 23:05,  0 users,  load average: 0.02, 0.01, 0.00
18:13:38 up 927 days,  2:51,  0 users,  load average: 0.00, 0.01, 0.00
18:13:39 up 350 days, 17:01,  0 users,  load average: 0.01, 0.01, 0.00
18:13:39 up 782 days,  5:27,  0 users,  load average: 0.00, 0.00, 0.00
18:13:40 up 329 days,  3:50,  0 users,  load average: 0.00, 0.00, 0.00
18:13:40 up 192 days,  1:28,  0 users,  load average: 0.44, 0.36, 0.28
18:13:40 up 203 days,  4:04,  0 users,  load average: 0.10, 0.16, 0.11
18:13:41 up 200 days,  3:14,  0 users,  load average: 0.07, 0.06, 0.01
18:13:41 up 200 days,  3:14,  0 users,  load average: 0.13, 0.14, 0.16
18:13:41 up 200 days,  3:14,  0 users,  load average: 0.06, 0.08, 0.08
18:13:42 up 104 days,  6:52,  0 users,  load average: 0.02, 0.01, 0.00
18:13:42 up 752 days,  3:37,  0 users,  load average: 0.00, 0.00, 0.00
18:20:04 up 94 days,  5:56,  0 users,  load average: 0.06, 0.03, 0.01
18:18:43 up 94 days,  5:54,  0 users,  load average: 0.00, 0.00, 0.00
18:20:40 up 11 days,  7:01,  0 users,  load average: 0.04, 0.10, 0.04
18:13:43 up 26 days,  8:50,  0 users,  load average: 0.01, 0.01, 0.00
18:13:43 up 581 days,  8:54,  0 users,  load average: 0.00, 0.00, 0.00
18:13:43 up 430 days,  2:08,  0 users,  load average: 0.01, 0.06, 0.02
18:13:49 up 215 days,  3:56,  0 users,  load average: 0.01, 0.04, 0.10
18:13:49 up 354 days,  4:17,  0 users,  load average: 0.00, 0.00, 0.00
18:13:49 up 523 days,  2:55,  0 users,  load average: 0.00, 0.00, 0.00
18:13:50 up 301 days,  2:12,  0 users,  load average: 0.00, 0.00, 0.00
18:13:50 up 259 days,  9:03,  0 users,  load average: 3.93, 4.07, 4.06
18:13:50 up 47 days,  2:46,  0 users,  load average: 0.00, 0.00, 0.00
18:13:51 up 17 days,  7:42,  0 users,  load average: 0.00, 0.00, 0.00
18:18:10 up 363 days,  4:19,  0 users,  load average: 0.13, 0.26, 0.34
18:13:52 up 145 days,  8:33,  0 users,  load average: 0.23, 0.17, 0.10
18:13:52 up 581 days,  8:34,  0 users,  load average: 0.00, 0.00, 0.00
18:13:52 up 431 days,  1:41,  0 users,  load average: 0.00, 0.01, 0.00
18:13:54 up 396 days,  2:21,  0 users,  load average: 0.00, 0.14, 0.24

Conclusion : It also takes time to be proved a possible next generation database.
 
So let's make a point on the last community work to continue tradition of stability :

  • There have been some effort in that direction in MySQL@Sun-Oracle that goes back to the source code 
  • MariaDB and Drizzle today compile with -Werror, which means that any compiler error is a just considered a failure.  
  • Buildbot is used for all MariaDB pushes, run for major OS, hardware, distribution including windows the test suite run on valgrind for debug and optimized builds to test all flavor. Number of test raise from 2236 to 2642, number of test lines from 567898 to 656864.
  • Buildbot is using test suite to stress for hight number of retry for better transient failures detection
In that area, competition raising quality , minimizing risks for the users.