mysqlfailover daemon not doing anything during forced poweroff of master server about mysql-utilities HOT 4 OPEN

It took me more than 10 minutes to print all the messages below. It's a serious problem. (mysql 5.7.16 + util 1.6.4)

Master may be down. Waiting for 3 seconds.
Failed to reconnect to the master after 3 attempts.

from mysql-utilities.

util 1.6.5 upgrade
--interval=5 --ping=1 --connection-timeout=5 --master-fail-retry=10 --timeout=10 -vvv --failover-mode=auto

Failed!! Sometimes it's fast, but most of the time it takes a long time.

from mysql-utilities.

I checked the source code and saw that the connection function did not properly reflect the connection timeout option. Also, Connector/Python's default is not 10 seconds. With the server down, it takes more than 2 minutes in default state.

BUG#22932375 => https://fossies.org/windows/misc/mysql-utilities-1.6.5.zip/mysql-utilities-1.6.5/CHANGES.txt

from mysql-utilities.

To solve the problem, manually add the connection_timeout value to the source(./common/server.py - line 1140) and compile it again.

    try:
        parameters = {
            'user': self.user,
            'host': self.host,
            'port': self.port,
            'connection_timeout': 5
        }

python setup.py build
python setup.py install

from mysql-utilities.