search

tinygg / mysql-mha-setup

mysql-master-ha scripts
0 stars 0 forks source link

Not support for detecting poor perfomance masters #100

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
Is this tool supports to detect poor performing master and then do fail-over. 
Instead of detecting dead-master.

Because, Frequently we are facing problem with Master performance degradation 
instead of completely dead

Original issue reported on code.google.com by jayaram2...@gmail.com on 20 Nov 2014 at 1:07

GoogleCodeExporter commented 8 years ago 
MHA does not handle a master as dead, if the master is running, even though the 
master performance degrades. This is to prevent repeating failover and false 
alarm. For example, if there are bugs in application logic, failover won't fix 
the problem so starting failover does not make any sense.

If you want MHA to start promotion, shutdown the master instance (by an 
external script or manually). The script should be smart enough that it 
understands failover fixes the problem (i.e. hardware problem on the master 
server).

Original comment by Yoshinor...@gmail.com on 21 Nov 2014 at 9:10