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

Automatic Database Failovers with Kubernetes

Sponsored · Ship Features Fearlessly Turn features on and off without deploys. Used by thousands of Ruby developers. →
Avatar for Jordan Wheeler Jordan Wheeler
April 24, 2018
Programming
0
210

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
Fragmented Architectures
Avatar for Denys Poltorak denyspoltorak
0
160
IFSによる形状設計／デモシーンの魅力 @ 慶應大学SFC
Avatar for がむ gam0022
1
300
Rust 製のコードエディタ “Zed” を使ってみた
Avatar for NearMeの技術発表資料です nearme_tech
PRO
0
180
Best-Practices-for-Cortex-Analyst-and-AI-Agent
Avatar for ryotaro.ikeda@finatext.com ryotaroikeda
1
110
HTTPプロトコル正しく理解していますか？ 〜かわいい猫と共に学ぼう。ฅ^•ω•^ฅ ﾆｬ〜
Avatar for ♛Heitor Hirose hekuchan
2
690
今こそ知るべき耐量子計算機暗号(PQC)入門 / PQC: What You Need to Know Now
Avatar for mackey0225 mackey0225
3
380
15年続くIoTサービスの SREエンジニアが挑む 分散トレーシング導入
Avatar for Melonps melonps
2
200
Package Management Learnings from Homebrew
Avatar for Mike McQuaid mikemcquaid
0
220
AgentCoreとHuman in the Loop
Avatar for Har1101 har1101
5
240
フロントエンド開発の勘所 -複数事業を経験して見えた判断軸の違い-
Avatar for Yoichiro Kubo heimusu
7
2.8k
責任感のあるCloudWatchアラームを設計しよう
Avatar for アキキー akihisaikeda
3
170
疑似コードによるプロンプト記述、どのくらい正確に実行される？
Avatar for kokuyouwind kokuyouwind
0
390

Featured

See All Featured
Digital Ethics as a Driver of Design Innovation
Avatar for Per Axbom axbom
PRO
1
180
Building a Scalable Design System with Sketch
Avatar for Laura Van Doore lauravandoore
463
34k
Thoughts on Productivity
Avatar for Jon Yablonski jonyablonski
74
5k
JavaScript: Past, Present, and Future - NDC Porto 2020
Avatar for David Neal reverentgeek
52
5.8k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
Avatar for Irina Nazarova irinanazarova
9
1.2k
jQuery: Nuts, Bolts and Bling
Avatar for Doug Neiner dougneiner
65
8.4k
How to Get Subject Matter Experts Bought In and Actively Contributing to SEO & PR Initiatives.
Avatar for Liv Day livdayseo
0
66
The B2B funnel & how to create a winning content strategy
Avatar for Katarina Dahlin katarinadahlin
PRO
1
270
What the history of the web can teach us about the future of AI
Avatar for Ines Montani inesmontani
PRO
1
430
SEO Brein meetup: CTRL+C is not how to scale international SEO
Avatar for Linda Hogenes lindahogenes
0
2.3k
Utilizing Notion as your number one productivity tool
Avatar for Mfonobong Umondia mfonobong
3
220
Avoiding the “Bad Training, Faster” Trap in the Age of AI
Avatar for Mike Taylor tmiket
0
76

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!