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

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
Towards Transactional Buffering of CDC Events @ Flink Forward 2025 Barcelona Spain
Avatar for Hans-Peter Grahsl hpgrahsl
0
120
Pythonに漸進的に型をつける
Avatar for Nealle nealle
1
140
퇴근 후 1억이 거래되는 서비스 만들기 | 내가 AI를 사용하는 방법
Avatar for Seungmin 마량 maryang
2
170
Webサーバーサイド言語としてのRustについて
Avatar for kaza kouyuume
1
5k
コードとあなたと私の距離 / The Distance Between Code, You, and I
Avatar for YAMAOKA Hiroyuki hiro_y
0
210
Vue 3.6 時代のリアクティビティ最前線 〜Vapor/alien-signals の実践とパフォーマンス最適化〜
Avatar for Shingo Hiranuma hiranuma
2
340
The Past, Present, and Future of Enterprise Java
Avatar for ivargrimstad ivargrimstad
0
450
Ktorで簡単AIアプリケーション
Avatar for Keita Tsukamoto tsukakei
0
120
業務でAIを使いたい話
Avatar for hnw hnw
0
220
contribution to astral-sh/uv
Avatar for Shunsuke Tsuchiya shunsock
0
570
iOSでSVG画像を扱う
Avatar for Kishikawa Katsumi kishikawakatsumi
0
180
Designing Repeatable Edits: The Architecture of . in Vim
Avatar for Satoru Kitaguchi satorunooshie
0
200

Featured

See All Featured
A better future with KSS
Avatar for Kyle Neath kneath
239
18k
The World Runs on Bad Software
Avatar for Brandon Keepers bkeepers
PRO
72
11k
It's Worth the Effort
Avatar for 3n 3n
187
28k
Building an army of robots
Avatar for Kyle Neath kneath
306
46k
The Language of Interfaces
Avatar for Des Traynor destraynor
162
25k
ピンチをチャンスに：未来をつくるプロダクトロードマップ #pmconf2020
Avatar for Aki / @LoveIdahoBurger aki_iinuma
127
54k
The Myth of the Modular Monolith - Day 2 Keynote - Rails World 2024
Avatar for Eileen M. Uchitelle eileencodes
26
3.1k
How to Create Impact in a Changing Tech Landscape [PerfNow 2023]
Avatar for Tammy Everts tammyeverts
55
3k
Documentation Writing (for coders)
Avatar for Carmen Chung carmenintech
76
5.1k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
Avatar for Marc Duiker marcduiker
34
2.3k
Designing for humans not robots
Avatar for Tammie Lister tammielis
254
26k
How To Stay Up To Date on Web Technology
Avatar for Chris Coyier chriscoyier
791
250k

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!