Probing Algorithm and Functionality

• MySQL

  • Sleeps for Thorough_probe_interval

  • Tries to connect to the MySQL instance, with mysqladmin command with argument ping, with the defined faultmonitor user fault <fmuser>. If this fails then the probe will restart the MySQL resource.

  • Every 300 seconds the probe will also check the following:

  • If the MySQL instance is a slave configuration, the probe will check if the MySQL instance is connected to it's master. If the Slave is not connected the probe will write an error message to syslog.

  • Verify that the probe can list all databases and tables, not the contents. If the probe recieve any errors the probe will write an error message to syslog.

  • Conduct an function test on the defined test-database, Create Table, Insert into Table, Update Table, Delete from Table and Drop table. If any of those operation fails then the probe will restart the MySQL resource.

  • If all MySQL processes have died, pmf will interrupt 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