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
170
Other Decks in Technology
See All in Technology
Exadata Database Service on Dedicated Infrastructure セキュリティ、ネットワーク、および管理について
oracle4engineer
PRO
1
330
【OptimizationNight】数理最適化のラストワンマイルとしてのUIUX
brainpadpr
2
550
Delegate authentication and a lot more to Keycloak with OpenID Connect
ahus1
0
240
Amazon S3 Vectorsは大規模ベクトル検索を低コスト化するサーバーレスなベクトルデータベースだ #jawsugsaga / S3 Vectors As A Serverless Vector Database
quiver
2
990
Kiro と Q Dev で 同じゲームを作らせてみた
r3_yamauchi
PRO
1
120
形式手法特論:位相空間としての並行プログラミング #kernelvm / Kernel VM Study Tokyo 18th
ytaka23
3
1.5k
AI時代の大規模データ活用とセキュリティ戦略
ken5scal
1
260
20250818_KGX・One Hokkaidoコラボイベント
tohgeyukihiro
0
110
九州の人に知ってもらいたいGISスポット / gis spot in kyushu 2025
sakaik
0
200
結局QUICで通信は速くなるの?
kota_yata
8
7.5k
JAWS-UG のイベントで使うハンズオンシナリオを Amazon Q Developer for CLI で作ってみた話
kazzpapa3
0
120
僕たちが「開発しやすさ」を求め 模索し続けたアーキテクチャ #アーキテクチャ勉強会_findy
bengo4com
0
2.6k
Featured
See All Featured
Bootstrapping a Software Product
garrettdimon
PRO
307
110k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
soudai
PRO
183
54k
Practical Orchestrator
shlominoach
190
11k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
jcasabona
33
2.4k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
36
2.5k
Let's Do A Bunch of Simple Stuff to Make Websites Faster
chriscoyier
507
140k
Code Review Best Practice
trishagee
69
19k
Producing Creativity
orderedlist
PRO
347
40k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
333
22k
A designer walks into a library…
pauljervisheath
207
24k
Designing for humans not robots
tammielis
253
25k
ReactJS: Keep Simple. Everything can be a component!
pedronauck
667
120k
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/