This section describes the HA for MySQL fault monitor's probing algorithm or functionality, states the conditions, messages, and recovery actions associated with unsuccessful probing.
For conceptual information on fault monitors, see Data Services Fault Monitors in Oracle Solaris Cluster 4.3 Concepts Guide.
The HA for MySQL fault monitor uses the same resource properties as resource type SUNW.gds. Refer to the SUNW.gds(5) man page for a complete list of resource properties used.
The following are the MySQL probing steps:
Sleeps for Thorough_probe_interval.
Tries to connect to the MySQL instance, with mysqladmin command with argument ping, with the defined fault-monitor user fault fmuser. If this fails, then the probe will restart the MySQL resource.
Every 300 seconds, the probe also checks the following:
If the MySQL instance is a slave configuration, the probe checks whether the MySQL instance is connected to its master. If the Slave is not connected, the probe will write an error message to syslog and sets a status message.
Verifies that the probe can list all databases and tables, not the contents. If the probe receives any errors the probe writes an error message to syslog.
Conducts function tests on the defined test-database, Create Table, Insert into Table, Update Table, Delete from Table and Drop Table. If any of those operations fails, then the probe restarts the MySQL resource.
If all MySQL processes have died, pmf interrupts the probe to immediately restart the MySQL resource.
If the MySQL resource is repeatedly restarted and subsequently exhausts the Retry_count within the Retry_interval then a failover is initiated for the Resource Group onto another node if Failover_enabled is set to TRUE.