Database Migration

AppPerfect Agentless Monitor comes with bundled HSQL database which is an purely java based embedded database. Users may like to use their own MySQL or Oracle data base with Agentless Monitor for that purpose. AppPerfect provides support for Database Migration. This functionality allows users to configure Agentless Monitor to use their database in place of bundled database and allows them to have better control over the database. Migrating to Oracle or MySql will give better database performance than HSql database when large number of monitors are being monitored.

AppPerfect Agentless Monitor database can be migrated to following databases:

Database Migration with MySQL 4.x and above

Start the monitor server if its not running. Login into the server using the web interface. You will see the dashboard. Click on the "Database" link. In order to migrate to MySQL database select "MySQL" in the combo box and specify other details as per the configuration of you MySql database.
JDBC Drivercom.mysql.jdbc.Driver
User Name<user name>
Password<password>
Driver JARpath of the jar file containing the driver class
Active Database URLjdbc:mysql://<hostname>:<port>/activedb?relaxAutoCommit=true

Database Migration with Oracle 8.x and above

Start the monitor server if its not running. Login into the server using the web interface. You will see the dashboard. Click on the "Database" link. In order to migrate to Oracle database select "Oracle" in the combo box and specify other details as per the configuration of you Oracle database.
JDBC Driveroracle.jdbc.driver.OracleDriver
User Name<user name>
Password<password>
Driver JARpath of the jar file containing the driver class
Active Database URLjdbc:oracle:thin:@<hostname>:<port>:<SID>