$30 off During Our Annual Pro Sale. View Details »

Automatic Database Failovers with Kubernetes

Avatar for Jordan Wheeler Jordan Wheeler
April 24, 2018
Programming
0
200

Automatic Database Failovers with Kubernetes

Some diagrams showing how we perform automatic database failovers at Shopify, using Orchestrator and ProxySQL running on Kubernetes.

These slides are from our presentation at Percona LIve 2018: https://www.percona.com/live/18/sessions/automatic-failovers-with-kubernetes-using-orchestrator-proxysql-and-zookeeper

Avatar for Jordan Wheeler

Jordan Wheeler

April 24, 2018
Tweet

Other Decks in Programming

See All in Programming
Integrating WordPress and Symfony
Avatar for Alexandre Salomé alexandresalome
0
160
re:Invent 2025 のイケてるサービスを紹介する
Avatar for maroon1st maroon1st
0
130
【Streamlit x Snowflake】データ基盤からアプリ開発・AI活用まで、すべてをSnowflake内で実現
Avatar for Ayumu Yamaguchi ayumu_yamaguchi
1
120
チームをチームにするEM
Avatar for hitode909 hitode909
0
350
Full-Cycle Reactivity in Angular: SignalStore mit Signal Forms und Resources
Avatar for Manfred Steyer manfredsteyer
PRO
0
150
愛される翻訳の秘訣
Avatar for Kishikawa Katsumi kishikawakatsumi
3
330
Tinkerbellから学ぶ、Podで DHCPをリッスンする手法
Avatar for Tomofumi Kondo tomokon
0
140
AIの誤りが許されない業務システムにおいて“信頼されるAI” を目指す / building-trusted-ai-systems
Avatar for Yuya Matsumura yuya4
6
3.7k
Findy AI+の開発、運用におけるMCP活用事例
Avatar for starfish719 starfish719
0
1.3k
バックエンドエンジニアによる Amebaブログ K8s 基盤への CronJobの導入・運用経験
Avatar for suna-big sunabig
0
160
C-Shared Buildで突破するAI Agent バックテストの壁
Avatar for po3rin po3rin
0
400
Cap'n Webについて
Avatar for Yusuke Wada yusukebe
0
140

Featured

See All Featured
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
Avatar for mongodb mongodb
48
9.8k
Hiding What from Whom? A Critical Review of the History of Programming languages for Music
Avatar for Tomoya Matsuura tomoyanonymous
0
280
Optimizing for Happiness
Avatar for Tom Preston-Werner mojombo
379
70k
YesSQL, Process and Tooling at Scale
Avatar for Rocio Delgado rocio
174
15k
Color Theory Basics | Prateek | Gurzu
Avatar for Gurzu gurzu
0
140
What’s in a name? Adding method to the madness
Avatar for Product Marketing Alliance productmarketing
PRO
24
3.8k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
Avatar for Vitaly Friedman smashingmag
254
22k
Claude Code のすすめ
Avatar for schroneko schroneko
65
200k
The Art of Programming - Codeland 2020
Avatar for Erika Heidi erikaheidi
56
14k
The Invisible Side of Design
Avatar for Vitaly Friedman smashingmag
302
51k
No one is an island. Learnings from fostering a developers community.
Avatar for Antonio thoeni
21
3.6k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
Avatar for Joe Casabona jcasabona
34
2.6k

Transcript

  1. Automatic failovers with Kubernetes using Orchestrator, ProxySQL and Zookeeper

  2. None
  3. None
  4. None
  5. None
  6. None
  7. None
  8. None
  9. None
  10. None
  11. None
  12. None
  13. None
  14. None
  15. None

  16. • Continuous monitoring • Holistic approach to failure detection •

    Smart recovery

  17. • Check Zookeeper Connectivity • Fencing Pre-Failover Hooks

  18. • Update Zookeeper • Master-master replication • Update DNS Post

    failover

  19. • Shared MySQL backend • Raft consensus protocol Orchestrator High

    Availability
  20. None
  21. None
  22. None
  23. None
  24. None
  25. None
  26. None
  27. None
  28. None

  29. Taiji Service Discovery

  30. None
  31. None
  32. None
  33. None
  34. None
  35. None
  36. None
  37. None
  38. None
  39. None
  40. None
  41. None
  42. None
  43. None
  44. None
  45. None
  46. None
  47. None
  48. None
  49. None
  50. None
  51. None
  52. None
  53. None
  54. None
  55. None

  56. • shopify.com/careers • Or talk to us We are hiring!