Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
MySQL System design for high availability with ...
Search
Takeshi Yako
November 26, 2014
Technology
0
3.1k
MySQL System design for high availability with MHA and HAproxy
Takeshi Yako
November 26, 2014
Tweet
Share
More Decks by Takeshi Yako
See All by Takeshi Yako
how-to-packing-novelty-goods-yapc-asia-tokyo-2015
takeshiyako
0
130
How to pack Novelty goods YAPC::Asia Tokyo 2015
takeshiyako
3
560
Nested JSON into Google BigQuery by Fluentd
takeshiyako
0
6.5k
CloudFront、RedshiftなどAWSが支える動画広告の舞台裏~インフラのイノベーションがもたらす動画広告のイノベーション~
takeshiyako
0
170
Other Decks in Technology
See All in Technology
AWSで推進するデータマネジメント
kawanago
1
1.3k
Webアプリケーションにオブザーバビリティを実装するRust入門ガイド
nwiizo
6
730
BPaaSにおける人と協働する前提のAIエージェント-AWS登壇資料
kentarofujii
0
130
Skrub: machine-learning with dataframes
gaelvaroquaux
0
120
Platform開発が先行する Platform Engineeringの違和感
kintotechdev
4
540
生成AI時代のデータ基盤設計〜ペースレイヤリングで実現する高速開発と持続性〜 / Levtech Meetup_Session_2
sansan_randd
1
150
【初心者向け】ローカルLLMの色々な動かし方まとめ
aratako
7
3.4k
実践!カスタムインストラクション&スラッシュコマンド
puku0x
0
340
AI時代に非連続な成長を実現するエンジニアリング戦略
sansantech
PRO
3
1.2k
データアナリストからアナリティクスエンジニアになった話
hiyokko_data
2
440
フルカイテン株式会社 エンジニア向け採用資料
fullkaiten
0
8.7k
新アイテムをどう使っていくか?みんなであーだこーだ言ってみよう / 20250911-rpi-jam-tokyo
akkiesoft
0
140
Featured
See All Featured
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
36
2.5k
Mobile First: as difficult as doing things right
swwweet
224
9.9k
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
kevinliebholz
34
6k
How GitHub (no longer) Works
holman
315
140k
What's in a price? How to price your products and services
michaelherold
246
12k
Practical Orchestrator
shlominoach
190
11k
Designing for Performance
lara
610
69k
Navigating Team Friction
lara
189
15k
VelocityConf: Rendering Performance Case Studies
addyosmani
332
24k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
29
2.9k
Designing Experiences People Love
moore
142
24k
Fashionably flexible responsive web design (full day workshop)
malarkey
407
66k
Transcript
MySQL System design for high availability with MHA and HAproxy
2014/11/26 Takeshi Yako
Servers app1 app2 mysql1 mysql2 mysql3 HAproxy App App HAproxy
MySQL Master MySQL Slave MySQL Slave MHA Node MHA Node MHA Node MHA Manager
Read and Write Jeff Kubina Hard Disk
Read HAproxy App App HAproxy MySQL Master MySQL Slave MySQL
Slave 127.0.0.1:3307 127.0.0.1:3307 mysql1:3306 mysql2:3306 mysql3:3306
Write HAproxy HAproxy MySQL Master MySQL Slave MySQL Slave 127.0.0.1:3308
127.0.0.1:3308 mysql1:3306 App App
Health Checks opensource.com Open Health: stethoscope
HAproxy HAproxy HAproxy MySQL Master MySQL Slave MySQL Slave HAproxy
checks MySQL read
MHA MySQL Master MySQL Slave MySQL Slave MHA Manager MHA
checks MySQL Master
Read Failover Simon Cocks Reading a book at the beach
Read Failover step1 HAproxy HAproxy MySQL Master MySQL Slave MySQL
Slave Health Check Fail
Read Failover step2 HAproxy App App HAproxy MySQL Master MySQL
Slave HAproxy detaches down server 127.0.0.1:3307 127.0.0.1:3307 mysql1:3306 mysql3:3306
Write Failover Erin Kohlenberg writing in the journal
Write Failover step1 MySQL Master MySQL Slave MySQL Slave MHA
Manager Health Check Fail
Write Failover step2 MySQL Master MySQL Master MySQL Slave MHA
Manager MHA changes MySQL Master
Write Failover step3 MySQL Master MySQL Master MySQL Slave MHA
Manager MHA changes HAproxy config HAproxy HAproxy
Write Failover step4 HAproxy HAproxy MySQL Slave MySQL Slave 127.0.0.1:3308
127.0.0.1:3308 App App MySQL Master mysql2:3306 HAproxy detaches down server
Thank you
Bibliography mysql-master-ha MHA for MySQL: Master High Availability Manager and
tools for MySQL https://code.google.com/p/mysql-master-ha/ HAproxy The Reliable, High Performance TCP/HTTP Load Balancer http://www.haproxy.org/