yoshinorim/mha4mysql-manager — Issue #18: Master ping via MySQL CONNECT or SELECT 
Author: yoshinorim
Created: 2011-10-25 19:49:10+00:00
State: open

Right now MHA establishes a persistent connection to a master and checks master's availability by executing "SELECT 1".
But in some cases, it is better to check by connecting/disconnecting every time, because it's more strict and it can detect TCP connection level failure more quickly.

In this issue, I'm going to add a new configuration parameter "ping_type". You can choose either "CONNECT" or "SELECT". If CONNECT is set, MHA connects/disconnects from master every ping operations. Default is CONNECT.