vADC Forum

Reply
Brocadian
Posts: 2
Registered: ‎03-24-2015

Generic Database Monitor

[ Edited ]

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.:

java!classpath:  /opt/zeus/zxtm/conf/jars/mysql.jar

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.

Join the Community

Get quick and easy access to valuable resource designed to help you manage your Brocade Network.

Download FREE NVMe eBook