Context Variables demo presentation

Transcript

1. Welcome to my
2. Welcome to my Dope Ass Slides
3. Context Variable refactor – what is it? context_variables = our 2nd largest MySQL table
4. Context Variable refactor – what is it? context_variables = our 2nd largest MySQL table = Teh Suck
5. Context Variable refactor – what is it? context_variables = our 2nd largest MySQL table = Teh Suck Running out of disk space quickly
6. ➲ 1 Mysql DB: ➲ ➲ Total Used Available Use% ➲ 669G 480G 156G 76%
7. ➲ 1 Mysql DB: ➲ ➲ Total Used Available Use% ➲ 669G 480G 156G 76% ➲ ➲ Context Variables: ➲ 68G ➲ 1 Mysql DB: ➲ ➲ Total Used Available Use% ➲ 669G 480G 156G 76%
8. ➲ 1 Mysql DB: ➲ ➲ Total Used Available Use% ➲ 669G 480G 156G 76% ➲ ➲ Context Variables: ➲ 68G ➲ ➲ ➲ And growing at an increasing rate. ➲ ➲ Not Sustainable ➲ 1 Mysql DB: ➲ ➲ Total Used Available Use% ➲ 669G 480G 156G 76%
9. Solution Get rid of it! Store it in the cloud! ➲ ➲ 68GB+ 68GB+ 68GB+ 68GB+ < <
10. What do Context Variables do for us? http://www.change.org/admin/metrics/* ➲ ➲ ➲ And other reports
11. http://www.change.org/admin/metrics/* ➲ ➲ ➲ ➲ ~ 3 hours a day to generate. ➲ ➲ Heavy queries on the reporting db. ➲ ➲ And only getting slower/worse.
12. Solution Get rid of it! Store it in the cloud! ➲ ➲ 3 hours + 3 hours + Throw Throw machines a machines a it it < <
13. ➲Map Reduce on Amazon ➲ ➲ ➲EMR
14. Rotate out context_variables daily 68GB+ 68GB+ Much much Much much less less -> ->
16. Add more machines, decrease runtime
17. What's this mean to you?
18. What's this mean to you? No more SELECT's on context_variables table
19. What's this mean to you? No more UPDATE's on context_variables table
20. What's this mean to you? No DELETE's on context_variables table (not that there ever were)
21. What's this mean to you? You prob weren't doing this stuff anyway. Just sayin, don't start now.
23. Recommendation ➲ Recommend one or several strategies ➲ Give a summary of the expected results ➲ Name the next steps to be taken ➲ Delegate the various tasks