Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
As a user, id like to define a custom sql query or check that runs against my backend nodes to verify that the server is in good standing for my use case, and define a reaction, trigger and poll time of the check.
Example: I have 10 critical tables that have to be online working and would like to periodically select 1 record from those tables, if they all dont pass/ successfully return, i want to trigger an action, maybe even adding the response time, if the response isnt fast enough within a defined boundary, let the user define a trigger/response. An example response could be running a defined script in the maxscale dir, demoting the failed server off out of the monitor/set of servers receiving traffic and or promote an offline server thats been waiting ready to use. or change master or automatically adjust some variable via sql etc.