Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Refresh MySQL endpoints without the application restart

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

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
What is the engineering organization that LINE DevRel is aiming for
Be4518b119b8eb017625e0ead20f8fe7?s=48 line_devday2019
3
2k
The IoT technology inside LINE DEVELOPER DAY 2019
Be4518b119b8eb017625e0ead20f8fe7?s=48 line_devday2019
6
760
How to reduce Android app launch time by scoping your dependencies using Koin DI
Be4518b119b8eb017625e0ead20f8fe7?s=48 line_devday2019
3
560
Efficient integrating data from multiple data providers
Be4518b119b8eb017625e0ead20f8fe7?s=48 line_devday2019
0
330
Now supporting Dark Mode on LINE messenger
Be4518b119b8eb017625e0ead20f8fe7?s=48 line_devday2019
0
1.1k
LIFF v2, the latest Webview SDK lets you leverage LINE
Be4518b119b8eb017625e0ead20f8fe7?s=48 line_devday2019
0
1.1k
Modern Web Testing with Cypress.io
Be4518b119b8eb017625e0ead20f8fe7?s=48 line_devday2019
0
460
Speed up iOS Development with LLDB Code Injection and Framework Live Preview
Be4518b119b8eb017625e0ead20f8fe7?s=48 line_devday2019
1
280
Faster iOS Builds with Bazel
Be4518b119b8eb017625e0ead20f8fe7?s=48 line_devday2019
0
1.1k

Other Decks in Technology

See All in Technology
個人的に使って良かったUiPathアクティビティ
0f4a27389318ca7087ae12b1593171c1?s=48 saoritakita
0
280
IDOLY PRIDEにおけるAssetBundleビルドパイプラインについて
8192a3d22a844b926f2e1bd7aef5fb25?s=48 qualiarts
0
350
長年運用されてきたモノリシックアプリケーションをコンテナ化しようとするとどんな問題に遭遇するか？ / SRE NEXT 2022
3e77f9dbec6a87756d1dbdddab283aee?s=48 nulabinc
PRO
15
8.2k
我々はなぜテストをするのか？
A64ac825509279a770c13c6fc517f11a?s=48 kawaguti
PRO
0
630
スポーツ・エンタメにおける映像伝送技術の実装と挑戦 〜車載カメラ、5G〜
B16717ef4b7aab0b253d933c3934f280?s=48 mixi_engineers
PRO
0
160
Scrum Fest Niigata 2022 開発エンジニアに聞いてみよう！
478bd912a17b65fa0ab8c1d81912b9b1?s=48 moritamasami
1
680
SRENEXT2022 組織にSREを実装していくまでの道のり
9cd2d753636f4849c881ccf2381228ee?s=48 marnie0301
1
870
モダンデータスタックとかの話(データエンジニアのお仕事とは)
95be3c1812a3ae53c2d81cc7ea2eeb3d?s=48 foursue
0
500
srenext2022-skaru
B16717ef4b7aab0b253d933c3934f280?s=48 mixi_engineers
PRO
1
1.1k
アルプでのAgile Testing / Alp Agile Testing
1b7098127bb4872f5fa10415d88479b7?s=48 nametake
0
340
プロダクション環境の信頼性を損ねず観測する技術
3baceb46dfe36422370df30b8eab61d1?s=48 egmc
4
940
NestJS + Prisma2 で歩む RLS の世界
3c6726d117aabeca68ccd7340c9204df?s=48 ynaka81
1
110

Featured

See All Featured
Designing for Performance
245cee81a9c424266e5e401d844ea881?s=48 lara
596
63k
Optimizing for Happiness
25c7c18223fb42a4c6ae1c8db6f50f9b?s=48 mojombo
365
63k
Happy Clients
C51b39fa3c79ccb99dcb8a076bc98287?s=48 brianwarren
89
5.6k
The Cult of Friendly URLs
Ded01cdab114abe4ec13511e4c25b9bb?s=48 andyhume
68
4.7k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
3d4519fd34b76fb265fc0237f3792bd4?s=48 danielanewman
212
20k
Ruby is Unlike a Banana
6804f1775cb4babfcc3851298566fbce?s=48 tanoku
91
9.2k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
B3ace07412a5178ea778e7eec161fc0a?s=48 jcasabona
12
900
StorybookのUI Testing Handbookを読んだ
50fc0fdc2327ecbe7350645812de52e3?s=48 zakiyama
4
2k
JavaScript: Past, Present, and Future - NDC Porto 2020
3ab1249be442027903e1180025340b3f?s=48 reverentgeek
37
3.2k
A better future with KSS
5f2da528927a2ec9ba4fec2069cbc958?s=48 kneath
225
15k
In The Pink: A Labor of Love
E837d2996f52008ace055a08fbfff992?s=48 frogandcode
130
21k
Why Our Code Smells
20bfe76b3d6105641f879fe45cfc9272?s=48 bkeepers
PRO
324
54k

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!