Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
MySQL System design for high availability with ...
Search
Takeshi Yako
November 26, 2014
Technology
3.1k
0
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
MySQL System design for high availability with MHA and HAproxy
Takeshi Yako
November 26, 2014
Transcript
18 slides
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/
More Decks by Takeshi Yako
See All by Takeshi Yako
how-to-packing-novelty-goods-yapc-asia-tokyo-2015
takeshiyako
0
160
How to pack Novelty goods YAPC::Asia Tokyo 2015
takeshiyako
3
630
Nested JSON into Google BigQuery by Fluentd
takeshiyako
0
6.6k
CloudFront、RedshiftなどAWSが支える動画広告の舞台裏~インフラのイノベーションがもたらす動画広告のイノベーション~
takeshiyako
0
200
Other Decks in Technology
See All in Technology
データから見る AI時代のエンジニア転職と採用
junya_okura
4
1.3k
New Relicのアラート対応をClaude Codeで自動修正するワークフローを作った話
manabuseki
2
620
認知負荷の減らし方 ~開発にも日常業務にも活かせるノウハウ~
minorun365
PRO
17
10k
おうち環境でも「なるべく止めたくない!」 ― おうち環境の機器冗長化の理想と現実
yuutosi
1
700
kubellの最新データ分析環境
kubell_hr
2
260
業務の傍らで進める改善ループエンジニアリング
bengo4com
1
240
認知の質も文化醸成も。数年取り組んで見えてきた技術広報のKPI設計 / Tech PR KPIs: Lessons on Awareness Quality and Culture After Several Years
bitkey
PRO
0
210
AIエージェントのアーキテクチャ設計
nsatoh
0
540
NutanixへのSSHアクセスの今後について
shadowhat
0
170
成長するID管理基盤における運用もコストも犠牲にしないオブザーバビリティ向上の実践 / Improving Observability for a Growing Identity Platform Without Adding Operational Burden or Cost
kaminashi
1
130
【Oracle AI SPOTLIGHT ウェビナー】AI時代、狙われるデータと止められない業務をどう守るか?
oracle4engineer
PRO
1
140
共通基盤の実装に Kotlin - Quarkus を選定した理由と採用したアーキテクチャ
nealle
1
160
Featured
See All Featured
Building Flexible Design Systems
yeseniaperezcruz
330
41k
Lightning talk: Run Django tests with GitHub Actions
sabderemane
0
330
Why You Should Never Use an ORM
jnunemaker
PRO
61
10k
Faster Mobile Websites
deanohume
310
32k
Thoughts on Productivity
jonyablonski
76
5.5k
Music & Morning Musume
bryan
48
7.5k
New Earth Scene 8
popppiees
5
2.9k
The browser strikes back
jonoalderson
0
2k
The innovator’s Mindset - Leading Through an Era of Exponential Change - McGill University 2025
jdejongh
PRO
1
400
Embracing the Ebb and Flow
colly
88
5.2k
sira's awesome portfolio website redesign presentation
elsirapls
0
520
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
soudai
PRO
203
77k