Refresh MySQL endpoints without the application restart

Be4518b119b8eb017625e0ead20f8fe7?s=47 LINE DevDay 2019
November 20, 2019
Technology
0
140

Refresh MySQL endpoints without the application restart

Julie Kim
LINE Plus Openchat Service Dev Backend Software Engineer
https://linedevday.linecorp.com/jp/2019/sessions/S1-06

Be4518b119b8eb017625e0ead20f8fe7?s=128

LINE DevDay 2019

November 20, 2019
Tweet

More Decks by LINE DevDay 2019

See All by LINE DevDay 2019
Be4518b119b8eb017625e0ead20f8fe7?s=48 line_devday2019
3
1.4k
Be4518b119b8eb017625e0ead20f8fe7?s=48 line_devday2019
6
480
Be4518b119b8eb017625e0ead20f8fe7?s=48 line_devday2019
3
210
Be4518b119b8eb017625e0ead20f8fe7?s=48 line_devday2019
0
190
Be4518b119b8eb017625e0ead20f8fe7?s=48 line_devday2019
0
340
Be4518b119b8eb017625e0ead20f8fe7?s=48 line_devday2019
0
540
Be4518b119b8eb017625e0ead20f8fe7?s=48 line_devday2019
0
200
Be4518b119b8eb017625e0ead20f8fe7?s=48 line_devday2019
1
130
Be4518b119b8eb017625e0ead20f8fe7?s=48 line_devday2019
0
360

Other Decks in Technology

See All in Technology
5b392dc79d5b6d1dab580bf60e26fb7c?s=48 nitya
0
180
9e7a653ed313b3da4b263a772bfc5026?s=48 clustervr
0
200
664b6e8ebe272fcfa5dbd6070eaf3cd4?s=48 wadayusuke
2
610
79dcb04101764d7bf66f898dd446838e?s=48 tsukubachallenge
0
200
Cd891a89dfec6ca7bd278b5f5bd87c90?s=48 tzkoba
16
4.6k
48a351a06897d7cc9721e2ddb7198e8a?s=48 dougpuob
0
110
0251532f4fb413ea1a026efe6eb16b87?s=48 stajima
0
230
44b799f91cc48e38c5fe9f5d9c5ecc61?s=48 takaichi00
28
11k
66fabad28b40a99387ab582cd0e94a2d?s=48 hiromaaa03
1
100
470bbf16e3547a17e40c34da937be921?s=48 kikmysy4
0
130
332f89cc697355902a817506b6995f2b?s=48 ytaka23
7
1.6k
53850955f15249a1a9dc49df6113e400?s=48 line_developers
0
130

Featured

See All Featured
Dafc4723e9a1c067796c0fec6f509774?s=48 lemiorhan
620
40k
Af6a12710770ad9a7cfd08c97efd40d3?s=48 pedronauck
648
110k
A60068bce2e73de3a37ca9d2dbe36092?s=48 bryan
28
3.1k
1519587b1a0febb658c36c94f6272b0d?s=48 roundedbygravity
84
7.6k
24fc194843a71f10949be18d5a692682?s=48 gr2m
82
11k
5f2da528927a2ec9ba4fec2069cbc958?s=48 kneath
218
14k
Aebc2d07a50011e2a30d38435fde564a?s=48 jrom
113
6.8k
245cee81a9c424266e5e401d844ea881?s=48 lara
168
9.1k
8081b26e05bb4354f7d65ffc34cbbd67?s=48 chriscoyier
681
180k
1519587b1a0febb658c36c94f6272b0d?s=48 roundedbygravity
240
20k
48c098b6579220a67a6ba949be6e4b5a?s=48 revolveconf
195
9.4k
D8fc2580cfaca035f666d9e4ee79a7f7?s=48 mongodb
23
3.7k

Transcript

  1. 2019 DevDay Refresh MySQL Endpoints Without the Application Restart >

    Julie Kim > LINE Plus Openchat Service Dev Backend Software Engineer

  2. Agenda > Problem Definition > Technical Design > Use Cases

    > Q&A

  3. Aug. 2019 THAILAND INDONESIA JAPAN

  4. 1st Jan. 2019

  5. 1st Jan. 2019 ~x3

  6. New Year Preparation icons made by freepick Linear G row

    th

  7. Destiny icons made by freepick, smashicons

  8. Destiny Time to Scale out Totally Unavailable icons made by

    smashicons

  9. What Are You Supposed To Do?

  10. Update MySQL endpoints icons made by smashicons > New Servers

    > Update properties > Deploy > Restart > Wait… > Monitor > Wait

  11. Update MySQL endpoints icons made by smashicons > New Servers

    > Update properties > Deploy > Restart > Wait… > Monitor > Wait

  12. Update MySQL endpoints icons made by freepick Linear G row

    th

  13. icons made by smashicons Conclusion

  14. Update MySQL endpoints icons made by smashicons > New Servers

    > Update properties > Deploy > Restart > Wait… > Monitor > Wait

  15. Update MySQL endpoints icons made by smashicons > New Servers

    > Update properties > Deploy > Restart > Wait… > Monitor > Wait

  16. Technical Design

  17. Naive Approach Application Servers Remote Coordinator Database watch

  18. Technical Design Application Servers Remote Coordinator Database watch

  19. Technical Design Application Servers Remote Coordinator Database watch

  20. Update MySQL Endpoints

  21. Update MySQL Endpoints Update!

  22. Update MySQL Endpoints Watcher Update Connection Pool

  23. Update MySQL Endpoints Create/Close the pool

  24. (revisit) Update MySQL endpoints icons made by smashicons > New

    Servers > Update properties > Deploy > Restart > Wait… > Monitor > Wait

  25. (revisit) Update MySQL endpoints icons made by smashicons > New

    Servers > Update properties > Monitor

  26. Use Cases

  27. Use Cases Master Failover icons made by smashicons

  28. Use Cases Master Failover Shard Extension icons made by smashicons

  29. Use Cases Master Failover Shard Extension icons made by smashicons

    Dynamic Slaves

  30. Conclusion

  31. Update MySQL Endpoints Update! Watcher > Update Connection pool

  32. Update MySQL Endpoints Update! Watcher > Update Connection pool For

    all things 5 mins

  33. Conclusion For all things 5 mins

  34. None

  35. Thank you!