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
3k
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
160
Other Decks in Technology
See All in Technology
CI/CD/IaC 久々に0から環境を作ったらこうなりました
kaz29
1
160
PHP開発者のためのSOLID原則再入門 #phpcon / PHP Conference Japan 2025
shogogg
4
720
Liquid Glass革新とSwiftUI/UIKit進化
fumiyasac0921
0
200
Observability в PHP без боли. Олег Мифле, тимлид Altenar
lamodatech
0
340
第9回情シス転職ミートアップ_テックタッチ株式会社
forester3003
0
220
~宇宙最速~2025年AWS Summit レポート
satodesu
1
1.8k
Witchcraft for Memory
pocke
1
270
ローカルLLMでファインチューニング
knishioka
0
150
監視のこれまでとこれから/sakura monitoring seminar 2025
fujiwara3
11
3.9k
AIの最新技術&テーマをつまんで紹介&フリートークするシリーズ #1 量子機械学習の入門
tkhresk
0
130
UIテスト自動化サポート- Testbed for XCUIAutomation practice
notoroid
0
130
Snowflake Summit 2025全体振り返り / Snowflake Summit 2025 Overall Review
mtpooh
2
390
Featured
See All Featured
Mobile First: as difficult as doing things right
swwweet
223
9.7k
jQuery: Nuts, Bolts and Bling
dougneiner
63
7.8k
Build The Right Thing And Hit Your Dates
maggiecrowley
36
2.8k
Optimizing for Happiness
mojombo
379
70k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
35
2.3k
BBQ
matthewcrist
89
9.7k
Designing for humans not robots
tammielis
253
25k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
252
21k
GitHub's CSS Performance
jonrohan
1031
460k
The Pragmatic Product Professional
lauravandoore
35
6.7k
Making Projects Easy
brettharned
116
6.3k
Rebuilding a faster, lazier Slack
samanthasiow
81
9.1k
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/