Database Servers

Introduction:

This section is common to all the editions of IT360 - Professional Edition, Enterprise Edition (Probes only) and MSP Edition (Probes only).

Database servers are robust, enterprise-class database management system. IT360 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 IT360;

  1. Cassandra

  2. IBM DB2 Database Server

  3. Memcached Server

  4. MongoDB

  5. Microsoft SQL Database Server

  6. MySQL Database Server

  7. Oracle Database Server

  8. PostgreSQL Database Server

  9. Sybase Database Server

1. Cassandra Server

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

  1. Login to IT360 console with the Username and Password of an Admin user.

  2. Click the Admin tab in the header pane.

  3. Click Discover/Add under Discovery.

  4. Choose the option Add from the Discover / Add type dropdown and select the Application radio button.

  5. In the Add New Monitor wizard displayed, click Cassandra under Database Servers (see this screenshot). In the Add Monitor wizard displayed, do the following:

  6. Enter a Display Name for the server.

  7. Enter the Host Name / IP Address of the host, in which the monitor is running.

  8. Enter the JMX Port of the Cassandra server. By default, it will be 7199, or check in the cassandra-env.sh file for the JMX_PORT.

  9. 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, which means all the nodes in the cluster are discovered by default.

  10. Check Is Authentication Required field, to give the jmx credentials to be used to connect to the Cassandra server. Then enter the UserName and Password.

  11. Specify the Polling Interval, in minutes. (The time interval to monitor the different parameters configured for a Monitor)

  12. Now, Associate the above Monitor Instances to a Business Service. i.e. choose the Business Service, to which you want to associate the Cassandra Monitor, from the combo box. If no Business Service is found, Create one by clicking the Create New Business Service link.

2. IBM DB2 Database Server

To create a new DB2 database monitor, the user should have admin privileges or the DB owner for master database.

Note:

i. IBM DB2 ver.8 and ver.9 monitoring is supported.

ii. You should be able to access the SYSPROC procedures.

To create a IBM DB2 database server monitor, follow the below steps:

  1. Login to IT360 console with the Username and Password of an Admin user.

  2. Click the Admin tab in the header pane.

  3. Click Discover/Add under Discovery.

  4. Choose the option Add from the Discover / Add type dropdown and select the Application radio button.

  5. In the Add New Monitor wizard displayed, click DB2 under Database Servers (see this screenshot). In the Add Monitor wizard displayed, do the following:

  6. Enter a Display Name for the server.

  7. Enter the Host Name / IP Address of the host, in which the monitor is running.

  8. Enter the SubNetMask of the network. Click the Advanced link and enable the checkbox "Do not resolve DNS name", in case you have multiple system IP addresses configured with single DNS name. Click the Advanced link and enable the checkbox "Do not resolve DNS name", in case you have multiple system IP addresses configured with single DNS name.

  9. Enter the Port number, in which DB2 is running.

  10. Enter the Polling interval time in minutes. (The time interval to monitor the different parameters configured for a Monitor)

  11. Provide the Username and Password of user, who has permission to access the DB2 database. The Username 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.

  12. Specify the Database Name.

  13. Now, Associate the above Monitor Instances to a Business Service. i.e. choose the Business Service, to which you want to associate the DB2 Monitor, from the combo box. If no Business Service is found, Create one by clicking the Create New Business Service link.

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

Top

3. Memcached Server

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

  1. Login to IT360 console with the Username and Password of an Admin user.

  2. Click the Admin tab in the header pane.

  3. Click Discover/Add under Discovery.

  4. Choose the option Add from the Discover / Add type dropdown and select the Application radio button.

  5. In the Add New Monitor wizard displayed, click Memcached under Database Servers (see this screenshot). In the Add Monitor wizard displayed, do the following:

  6. Specify the Display Name of the Memcached server.

  7. Enter the Hostname or IP Address of the host, where the Memcached server runs.

  8. Enter the Port, where the server is running.

  9. If you want to Enable transaction test, select 'Yes' radio button, else select 'No' radio button.

  10. Set the Polling Interval. (The time interval to monitor the different parameters configured for a Monitor)

  11. Now, Associate the above Monitor Instances to a Business Service. i.e. choose the Business Service, to which you want to associate the Memcached Monitor, from the combo box. If no Business Service is found, Create one by clicking the Create New Business Service link.

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

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

Top

4. MongoDB Server

To monitor a MongoDB server, follow the steps given below:

  1. Login to IT360 console with the Username and Password of an Admin user.

  2. Click the Admin tab in the header pane.

  3. Click Discover/Add under Discovery.

  4. Choose the option Add from the Discover / Add type dropdown and select the Application radio button.

  5. In the Add New Monitor wizard displayed, click MongoDB under Database Servers (see this screenshot). In the Add Monitor wizard displayed, do the following:

  6. Specify the Display Name of the Memcached server.

  7. Enter the Hostname or IP Address of the host, where the Memcached server runs.

  8. Enter the Port, where the server is running.

  9. 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.
Note: For ReplicaSet, it is enough if you give details of any one node in the ReplicaSet and enable this field and IT360 will auto discover all nodes in the ReplicaSet. For Sharding, give the details of mongos process and enable this field. All shards will be discovered automatically by IT360.
  1. Check Is Authentication Required field to give the credentials to be used to connect to mongodb server. Then enter UserName and Password credentials.

  2. Specify the Polling Interval, in minutes. (The time interval to monitor the different parameters configured for a Monitor)

  3. Now, Associate the above Monitor Instances to a Business Service. i.e. choose the Business Service, to which you want to associate the MongoDB Monitor, from the combo box. If no Business Service is found, Create one by clicking the Create New Business Service link.

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

Top

5. Microsoft SQL Database Server

Minimum User Privileges: To create a Microsoft SQL Database Server, the user should be permitted to access MASTER database & In MASTER database the user Requires VIEW SERVER STATE permission on the server.

Roles : public + db_datareader should be selected.

For MS SQL 2005 user role,
Database Accessed: Master

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

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

i. Execute the following query,

GRANT VIEW SERVER STATE TO username;

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

To create a Microsoft SQL database server Monitor, follow the below steps:

  1. Login to IT360 console with the Username and Password of an Admin user.

  2. Click the Admin tab in the header pane.

  3. Click Discover/Add under Discovery.

  4. Choose the option Add from the Discover / Add type dropdown and select the Application radio button.

  5. In the Add New Monitor wizard displayed, click MS SQL under Database Servers (see this screenshot). In the Add Monitor wizard displayed, do the following:

  6. Enter a Display Name for the server.

  7. Enter the Host Name / IP Address of the host, in which the monitor is running.

  8. Enter the SubNetMask of the network. Click the Advanced link and enable the checkbox "Do not resolve DNS name", in case you have multiple system IP addresses configured with single DNS name. Click the Advanced link and enable the checkbox "Do not resolve DNS name", in case you have multiple system IP addresses configured with single DNS name.

  9. Enter the Port number, in which Microsoft SQL is running.

  10. Enter the Polling interval time in minutes. (The time interval to monitor the different parameters configured for a Monitor)

  11. Choose the Authentication Type as SQL or Windows.

  12. Provide the Username and Password of user, who has permission to access the Microsoft SQL database [SQL DB Auth entication]. The Username 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 Username like domainname\username) also.

  13. Enable the Connect Using Named Instance checkbox and give an Instance Name, if you want the database to be connected using a named instance.

  14. Now, Associate the above Monitor Instances to a Business Service. i.e. choose the Business Service, to which you want to associate the Microsoft SQL Database Monitor, from the combo box. If no Business Service is found, Create one by clicking the Create New Business Service link.

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

Top

6. MySQL Database Server

Note: In the MySQL database (that you are trying to monitor), ensure that the Username, assigned to IT360, has the permission to access the MySQL database from the host, where the IT360 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, the IT360 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 -> IT360 machine) /

To create a MySQL database server monitor, follow the below steps;

  1. Login to IT360 console with the Username and Password of an Admin user.

  2. Click the Admin tab in the header pane.

  3. Click Discover/Add under Discovery.

  4. Choose the option Add from the Discover / Add type dropdown and select the Application radio button.

  5. In the Add New Monitor wizard displayed, click MySQL under Database Servers (see this screenshot). In the Add Monitor wizard displayed, do the following:

  6. Enter a Display Name for the server.

  7. Enter the Host Name / IP Address of the host, in which the monitor is running.

  8. Enter the SubNetMask of the network. Click the Advanced link and enable the checkbox "Do not resolve DNS name", in case you have multiple system IP addresses configured with single DNS name. Click the Advanced link and enable the checkbox "Do not resolve DNS name", in case you have multiple system IP addresses configured with single DNS name.

  9. Enter the Port number, in which MySQL is running.

  10. Enter the Polling interval time in minutes. (The time interval to monitor the different parameters configured for a Monitor)

  11. Provide the Username and Password of user, who has permission to access the MySQL database.

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

  13. Now, Associate the above Monitor Instances to a Business Service. i.e. choose the Business Service, to which you want to associate the MySQL Database Monitor, from the combo box. If no Business Service is found, Create one by clicking the Create New Business Service link.

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

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

 

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

Top

7. Oracle Database Server

Follow the below steps to create an Oracle database server monitor:

Note:

i. For you to create a new Oracle database monitor, you should have Admin privileges.

ii. Minimum User Privileges = user with CONNECT and SELECT_CATALOG_ROLE roles.

  1. Login to IT360 console with the Username and Password of an Admin user.

  2. Click the Admin tab in the header pane.

  3. Click Discover/Add under Discovery.

  4. Choose the option Add from the Discover / Add type dropdown and select the Application radio button.

  5. In the Add New Monitor wizard displayed, click Oracle under Database Servers (see this screenshot). In the Add Monitor wizard displayed, do the following:

  6. Enter a Display Name for the server.

  7. Enter the Host Name / IP Address of the host, in which the monitor is running.

  8. Enter the SubNetMask of the network. Click the Advanced link and enable the checkbox "Do not resolve DNS name", in case you have multiple system IP addresses configured with single DNS name. Click the Advanced link and enable the checkbox "Do not resolve DNS name", in case you have multiple system IP addresses configured with single DNS name.

  9. Enter the Port number, in which Oracle is running.

  10. Enter the Polling interval time in minutes. (The time interval to monitor the different parameters configured for a Monitor)

  11. Provide the Username and Password of user, who has permission to access the Oracle database.

  12. Provide the Instance Name [Service Name].
  • To monitor a single Oracle database instance:
    Specify the SID or Service Name of the instance, to which you want to connect.
  1. Now, Associate the above Monitor Instances to a Business Service. i.e. choose the Business Service, to which you want to associate the Oracle Database Monitor, from the combo box. If no Business Service is found, Create one by clicking the Create New Business Service link.

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

Top

8. PostgreSQL Database Server

ManageEngine IT360 uses PostgreSQLs subsystem statistics collector to monitor PostgreSQL server activity. By default, the statistics collector is accessible.

If you have problems in adding a new PostgreSQL server, follow the below steps:

  • Open postgresql.conf under <postgres home>/data.

  • Check value of configuration parameter, it has to be "*". If not, change it to "*".

  • Click here for more details on configuring postgresql.conf.

  • Open pg_hba.conf under <postgres home>/data. Add a new line host all all 0.0.0.0/0 md5 to allow all machines with proper password authentication to access the PostgreSQL DB server.Click here for more details on configuring pg_hba.conf.

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

  1. Login to IT360 console with the Username and Password of an Admin user.

  2. Click the Admin tab in the header pane.

  3. Click Discover/Add under Discovery.

  4. Choose the option Add from the Discover / Add type dropdown and select the Application radio button.

  5. In the Add New Monitor wizard displayed, click PostgreSQL under Database Servers (see this screenshot). In the Add Monitor wizard displayed, do the following:

  6. Enter a Display Name for the server.

  7. Enter the Host Name / IP Address of the host, in which the monitor is running.

  8. Enter the Port number, in which PostgreSQL is running.

  9. Provide the Username and Password of user, who has permission to access the PostgreSQL database.

  10. Specify the DBname.

  11. Enter the Polling interval time in minutes. (The time interval to monitor the different parameters configured for a Monitor)

  12. Now, Associate the above Monitor Instances to a Business Service. i.e. choose the Business Service, to which you want to associate the PostgreSQL Monitor, from the combo box. If no Business Service is found, Create one by clicking the Create New Business Service link.

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

Top

9. Sybase Database Server

To create a Sybase database server Monitor, follow the below steps;Note: Sybase ASE ver.12.5.3 and above monitoring is only supported.

  1. Login to IT360 console with the Username and Password of an Admin user.

  2. Click the Admin tab in the header pane.

  3. Click Discover/Add under Discovery.

  4. Choose the option Add from the Discover / Add type dropdown and select the Application radio button.

  5. In the Add New Monitor wizard displayed, click Sybaseunder Database Servers (see this screenshot). In the Add Monitor wizard displayed, do the following:

  6. Enter a Display Name for the server.

  7. Enter the Host Name / IP Address of the host, in which the monitor is running.

  8. Enter the SubNetMask of the network. Click the Advanced link and enable the checkbox "Do not resolve DNS name", in case you have multiple system IP addresses configured with single DNS name. Click the Advanced link and enable the checkbox "Do not resolve DNS name", in case you have multiple system IP addresses configured with single DNS name.

  9. Enter the Port number, in which Oracle is running.

  10. Enter the Polling interval time in minutes. (The time interval to monitor the different parameters configured for a Monitor)

  11. Provide the Username and Password of user, who has permission to access the Oracle database.

  12. Specify the Database Name.

  13. Now, Associate the above Monitor Instances to a Business Service. i.e. choose the Business Service, to which you want to associate the Sybase Monitor, from the combo box. If no Business Service is found, Create one by clicking the Create New Business Service link.

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

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 Monitors with Business Service topic.

Top

See Also:

Monitor Information - Database Server | Create Other New Monitors

Copyright © 2014, ZOHO Corp. All Rights Reserved.