Often, customers wish to do load balancing of replicating databases, and wish to effectively monitor them. The attached Java extension leverages JDBC drivers to connect to the database server, then the monitor issues a query of "select 1" to the database server by default. The monitor accepts the following parameters:
user The user to connect as (required) password The user's password (required) type The type of database, supported are "mysql", "mssql", "oracle", or "postgress" (required) database The name of the database configured, i.e. for a "use <database>" command (required) instance For mssql, the name of the instance to connect to (optional) service For Oracle, the name of the service (optional) query The query to use. Use "~" in place of spaces. (optional--defaults to "select 1")
Insure the proper JDBC jar file is configured in the global java CLASSPATH, i.e.:
Upload the db-monitor.sh and ConnectDBServer.class files to the monitors section in the extra files catalog, and create an appropriate monitor with the options above. The db-monitor.sh is a Bash shells script that can be modified to provide additional support for other database types if needed.