Refresh MySQL endpoints without the application restart

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

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!