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

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
35. Thank you!