Backwards compatibility fix for super_read_only

yoshinorim / mha4mysql-node

Development tree of Master High Availability Manager and tools for MySQL (MHA), Node (MySQL Server) part

http://code.google.com/p/mysql-master-ha/

GNU General Public License v2.0

402 stars 202 forks source link

Backwards compatibility fix for super_read_only #38

Open martinamps opened 5 years ago

martinamps commented 5 years ago

This fixes checking pivot status for MySQL clusters without super_read_only support:

    Checking if super_read_only is defined and turned on..DBD::mysql::st execute failed: Unknown system variable 'super_read_only' at /usr/local/mha4mysql/lib/MHA/SlaveUtil.pm line 245.
Tue Jul 16 12:38:13 2019 - [error][/usr/local/mha4mysql/lib/MHA/MasterMonitor.pm, ln205] Slaves settings check failed!

First reported in https://github.com/yoshinorim/mha4mysql-manager/issues/111

martinamps commented 5 years ago

@grypyrg @yoshinorim would appreciate a review as time permits 🙌