koy1619 / mysql-master-ha

Automatically exported from code.google.com/p/mysql-master-ha
0 stars 0 forks source link

MHA Scalability #117

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
Hello,

We are planning to run the MHA at our company, however we are wondering with 
one MHA Manager how many nodes/apps we can monitor? 100s, 1000s etc. We have 
quite a few nodes and wanted to know it's the ideal/optimal number of nodes per 
one manager.

Thank you,
-Egezon

Original issue reported on code.google.com by egezon.b...@gmail.com on 5 Aug 2015 at 7:32

GoogleCodeExporter commented 9 years ago
MHA manage does almost nothing at steady state (just running SELECT 1 every few 
seconds). Master failover involves quite a lot of SQL statements, but master 
failover happens on very limited number of masters at the same time (one or a 
few), so manager server is very less likely to be overloaded. At my previous 
employer I managed more than 200 master servers from a small manager server.

Original comment by Yoshinor...@gmail.com on 6 Aug 2015 at 1:13