ManageEngine® Applications Manager


Database Servers

<< Prev

Home

Next >>

Database Servers

 

Database servers are robust, enterprise-class database management system. Applications Manager provides Database Server monitoring that monitors database resources. This database server monitoring involves connecting to the database resource, collecting data, and representing its attribute details as graphs.

 

The following are the different Database servers supported by Applications Manager:

MySQL Database Server

Note: In the MySQL database (that you are trying to monitor), ensure that the user name assigned to Applications Manager has the permission to access the MySQL database from the host where Applications Manager is running. Else, give a relevant user who has the privileges to do the same.

 

Minimum User Privileges : The user should have privileges to execute SELECT, SHOW DATABASES, REPLICATION commands in the MySQL server. Also, Applications Manager machine should be allowed to access the MySQL database server.

 

For enabling the privileges, execute the below commands in the remote MySQL Server

 

INSERT INTO user (Host,User) VALUES('<host>','<user>');
GRANT SELECT,SHOW DATABASES,REPLICATION CLIENT ON *.* TO '<user>'@'<host>';
FLUSH PRIVILEGES;

 

(Host -> Applications Manager machine) /

 

 

 

To create a MySQL database server Monitor, follow the given steps:

  1. Click on New Monitor link.

  2. Select MySQL DB Server.

  3. Enter the IP Address or hostname of the host.

  4. Enter the SubNetMask of the network.

  5. Enter the port number in which MySQL is running.

  6. Enter the polling interval time in minutes.

  7. Provide the user name and password of user who has permission to access the MySQL database.

  8. Specify the database name. Please note that the Database name must be valid. Also, the database name is associated with the user name. Hence, provide the database name corresponding to the user name given in the above field.

  9. Choose the Monitor Group from the combo box with which you want to associate MySQL database server Monitor (optional).

  10. Click Add Monitor(s). This discovers MySQL database server from the network and starts monitoring them.

 

Troubleshoot: Having trouble in monitoring MySQL database server? Refer to the online Troubleshooting section.

 

Top

Oracle Database Server

 

Follow the given steps to create a Oracle database server monitor:

 

Note: For you to create a new Oracle database monitor, you should have admin privileges. Minimum User Privileges -> user with CONNECT and SELECT_CATALOG_ROLE roles

  1. Click on New Monitor link.

  2. Select Oracle DB Server.

  3. Enter the IP Address or hostname of the host.

  4. Enter the SubNetMask of the network.

  5. Enter the port number in which the Oracle is running.

  6. Enter the polling interval time in minutes.

  7. Provide the user name of the admin user ('system' is the default username) and its corresponding password.

  8. Provide a valid System Identifier / Host Connection String.

  9. Choose the Monitor Group from the combo box with which you want to associate Oracle database server Monitor (optional).

  10. Click Add Monitor(s). This discovers Oracle database server from the network and starts monitoring them.

 

Note:
This monitor type is not supported in the Cloud Starter Edition. Compare Editions.

 

Top

MS SQL Database Server

To create a MS SQL database server Monitor, follow the given steps:

  1. Click on New Monitor link.

  2. Select MS SQL DB Server.

  3. Enter the IP Address or Hostname of the host.

  4. Enter the SubNetMask of the network.

  5. Enter the Port number in which the MS SQL is running.

  6. Enter the Polling interval time in minutes.

  7. Provide the User Name and Password of user who has permission to access the MS SQL database. The user name specified for collecting the data from MS SQL Server should have either System Administrator role or the user should be the DB owner for master database. Alternatively, you can provide the Windows Authentication details (give the User Name like domainname\username) also.

  8. Choose the Monitor Group from the combo box with which you want to associate MS SQL database server Monitor (optional).

  9. Click Add Monitor(s). This discovers MS SQL database server from the network and starts monitoring them.

Note:

Minimum User Privileges: User should be permitted to access MASTER database & MSDB database.

Roles: public + db_datareader should be selected for both MASTER and MSDB databases.

For MS SQL 2005, 2008 and 2012 user roles:
Database Accessed: Master

Permit in Database Role: db_datareader & Requires VIEW SERVER STATE permission on the server.

 

To grant VIEW SERVER STATE, you can use any of the following methods :

 

1) Execute the following query


GRANT VIEW SERVER STATE TO username;

 

2) In SQL management studio for user choose Properties -> Securables -> Click Add ( under securables ) -> choose "All objects of the Types..." -> choose Servers -> choose Grant for "View server state" permission.

 

Note:
This monitor type is not supported in the Cloud Starter Edition. Compare Editions.



IBM DB2 Database Server

To create a IBM DB2 database server Monitor, follow the given steps:


Note: IBM DB2 ver.8 and ver.9 monitoring is supported. A DB2 user with SYSMON instance level authority is required for monitoring DB2 server.

  1. Click on New Monitor link.

  2. Select DB2 DB Server.

  3. Enter the IP Address or hostname of the host.

  4. Enter the SubNetMask of the network.

  5. Enter the port number in which DB2 is running.

  6. Enter the polling interval time in minutes.

  7. Provide the user name and password of user who has permission to access the DB2 database. The user name specified for collecting the data from DB2 Server should have either System Administrator role or the user should be the DB owner for master database.

  8. Specify the Database Name.

  9. Choose the Monitor Group from the combo box with which you want to associate DB2 database server Monitor (optional).

  10. Click Add Monitor(s). This discovers DB2 database server from the network and starts monitoring them.

 

Note:
This monitor type is not supported in the Cloud Starter Edition. Compare Editions.

Top

 

Sybase Database Server

To create a Sybase database server Monitor, follow the given steps:


Note: Sybase ASE ver.12.5.3 and above monitoring is only supported.

  1. Click on New Monitor link.

  2. Select Sybase.

  3. Enter the IP Address or Host Name of the host.

  4. Enter the SubNetMask of the network.

  5. Enter the port number in which sybase is running.

  6. Enter the polling interval time in minutes.

  7. Provide the user name and password of user who has permission to access the Sybase database. The user name specified for collecting the data from Sybase should have either System Administrator role or the user should be the DB owner for master database.

  8. Specify the Database Name.

  9. Choose the Monitor Group from the combo box with which you want to associate Sybase database server Monitor (optional).

  10. Click Add Monitor(s). This discovers Sybase database server from the network and starts monitoring them.

 

Note:
This monitor type is not supported in the Cloud Starter Edition. Compare Editions.

Top

PostgreSQL Database Server

To create a PostgreSQL database server monitor, follow the steps given below:

  1. Click on New Monitor link.

  2. Select PostgreSQL.

  3. Enter the Display Name of the database server.

  4. Enter the IP Address or Host Name of the host.

  5. Enter the port number in which PostgreSQL is running.
  6. Provide the user name and password of user who has permission to access the PostgreSQL database.

  7. Specify the DBName.
  8. Enter the polling interval time in minutes.
  9. Choose the Monitor Group with which you want to associate the PostgreSQL database server to, from the combo box (optional).

  10. Click Add Monitor(s). This discovers PostgreSQL database server from the network and starts monitoring them.

 

Note:
This monitor type is not supported in the Cloud Starter Edition. Compare Editions.

Top

Memcached Server

To create a Memcached database server monitor, follow the steps given below:

  1. Click on New Monitor link.

  2. Select Memcached under Cloud Computing/Virtualization category.

  3. Specify the Display Name of the memcached server

  4. Enter the HostName or IP Address of the host where Memcached server runs.

  5. Enter the Port where the server is running.

  6. If you want to enable Transaction test, select 'Yes' radio button, otherwse select 'No' button.

  7. Set the Polling Interval.

  8. Choose the Monitor Group with which you want to associate the Memcached server to, from the combo box (optional).

  9. Click Add Monitor(s). This discovers the Memcached server from the network and starts monitoring it.

Top

Cassandra Server

To create a Cassandra database server monitor, follow the steps given below:

  1. Click on New Monitor link.

  2. Select Cassandra .

  3. Specify the Display Name of the Cassandra monitor

  4. Enter the HostName or IP Address of the host where Cassandra server runs.

  5. Enter the JMX Port where the server is running.By default, it will be 7199 or else check in cassandra-env.sh file for the JMX_PORT.

  6. If you want to discover only this node, disable the option Discover all nodes in the Cluster. By default, it is enabled which means all the nodes in the cluster are discovered by default.

  7. Check the Is Authentication Required field, to give the JMX credentials to be used to connect to the Cassandra server. Now enter the UserName and Password of the credential.

  8. Specify the Polling Interval in minutes.

  9. Choose the Monitor Group with which you want to associate the Cassandra server to, from the combo box (optional).

  10. Click Add Monitor(s). This discovers the Cassandra server from the network and starts monitoring it.

Top

Mongo Server

To create a Mongo database server monitor, follow the steps given below:

  1. Click on New Monitor link.

  2. Select Mongo.

  3. Specify the Display Name of the Mongo monitor

  4. Enter the HostName or IP Address of the host where MongoDB/mongo process runs.

  5. Enter the Port where the server is running.By default, it will be 27017.

  6. To discover only this node and not all nodes in the ReplicaSet / Sharding disable the option Discover all nodes in the ReplicaSet / Sharding. By default, it is enabled.

  7. Check the Is Authentication Required field, to give the credentials to be used to connect to the MongoDB server. Now enter the UserName and Password of the credential.

  8. Specify the Polling Interval in minutes.

  9. Choose the Monitor Group with which you want to associate the MongoDB server to, from the combo box (optional).

  10. Click Add Monitor(s). This discovers the MongoDB server from the network and starts monitoring it.

Top

Redis Server

To create a Redis database server monitor, follow the steps given below:

  1. Click on New Monitor link.

  2. Select Redis.

  3. Specify the Display Name of the Redis monitor

  4. Enter the HostName or IP Address of the host where Redis server runs.

  5. Enter the Port where the server is running.By default, it will be 6379. Or else you can also check it in the redis.conf file.

  6. To discover only this node and not all nodes in the cluster disable the option Discover all nodes in the cluster. By default, it is enabled.

  7. Check the Is Authentication Required field, to give the credentials to be used to connect to the Redis server. Now enter the Password of the credential.

  8. Specify the Polling Interval in minutes.

  9. Choose the Monitor Group with which you want to associate the Redis server to, from the combo box (optional).

  10. Click Add Monitor(s). This discovers the Redis server from the network and starts monitoring it.

If you have added Monitors and not associated them with a Monitor Group, you can do this manually anytime. For information on associating a Monitor with a Monitor Group, refer to Associating Monitor with Monitor Groups topic.

Top

See Also

Monitor Information - Database Server | Create Other New Monitors

 

 

<< Prev

Home

Next >>

Database Query Monitor

File Directory Monitor