OpsRamp allows monitoring of cloud database to help you understand and track the performance of the database (MySQL, PostgreSQL, MS SQL, Oracle, Aurora DB) in your cloud environment to determine the seamless functioning of your applications.

To start monitoring, you need to complete configuration in cloud environment (For example, Azure) and OpsRamp. This document outlines the process required to configure monitoring of cloud database using gateway, taking Azure as an example.

Prerequisites and considerations

  • Configure VPN connectivity corresponding to gateway.
  • The database you want to monitor must be publicly available.
  • You can deploy gateway before or after the cloud integration. If gateway is deployed before cloud instances are discovered, ensure gateway is on the same private network as the instances after discovery.
  • If the cloud instances to be monitored are on different private networks, deploy multiple gateways for monitoring.
  • Each gateway deployed to monitor the cloud instances must be registered in cloud.

Configurations in Azure

The following configurations are required in Azure:

Create a database

Create a database in your cloud environment that you want to monitor through gateway.

To create a database in Azure:

  1. Log into Azure platform.
  2. From the left pane, click SQL databases.
    Azure Database for MySQL servers screen appears.
  3. Click +Add to create a database.
    Create SQL Database screen appears.
  4. Provide the following details and click Review + create.
    • Resource Group: Select the required resource group from the drop-down
    • Database name: Enter a unique name to the database
    • Server: Select the server that has sufficient capacity to host the database.
    • Compute+storage: Select the compute and storage options
  5. Verify if the created database appears in the list of MySQL servers.

Configure security details

You need to configure the security details for the database.

Perform the following steps:

  1. From the list of MySQL Database servers, click the name of the database you created.
  2. From the left pane, click Connection security from the Settings menu.
    Connection Security screen appears.
  3. Configure IP details of gateway and click Submit.
    The database you created in Azure is now configured with OpsRamp gateway security details.

Configuration in OpsRamp

After completing configuration in Azure, you need to complete configuration in OpsRamp.

Perform the following steps:

  1. Assign gateway profile.
  2. Create and assign database credentials.
  3. Create monitors.
  4. Create templates using the monitors.
  5. Apply the templates to the database.
  6. Validate.

Assign gateway profile

You need to assign gateway profile to the cloud integration, to facilitate gateway monitoring for the desired cloud environment.

To assign the gateway profile:

  1. Click All Clients and from the displayed list, select a client.
  2. Click Setup.
  3. From the left pane, navigate to Integrations > Integrations.
    Integrations list appears.
  4. From Installed Integrations, click Public Cloud and then click Azure.
  5. Click on the Integration name.
    Azure Integration details screen appears.
  6. From the Configuration tab, navigate to Discovery Profiles and click +Add.
    Add Discovery Profile window appears.
  7. From the Filter Criteria, select Smart Filters as Filter Criteria Type, then select All resources and click Save.
  8. (Optional) Configure Discovery Schedule if you need to discover new resources automatically without manual intervention.
    The discovery profile is now created.

Create and assign database credentials

The Database Administrators (DBAs) can set the permissions or privileges required for the users to monitor the database. For more information, view Privileges to monitor database.

To create and assign credentials:

  1. Click Infrastructure.
  2. Click the Resources tab, click Microsoft Azure, and then select the database that you created.
  3. From the left pane, click Credentials.
    Credentials details screen appears.
  4. Click +Add to create new credentials.
  5. Click +Assign and assign credentials to the required client.
  6. Verify if the new credentials appear in the credentials list.

Create monitor

To create a monitor:

  1. Click Setup.
  2. From the left pane, click Monitoring > Monitors.
  3. Click + Add to add a monitor.
    Create a Monitor page appears.
  4. Provide the following details:
    • Monitor Scope: Select Partner Monitor or Client-Specific Monitor.
      For Client-Specific Monitor,select the client also.
    • Adaptor Type: Select the monitor type. For example, select Application.
    • Application Type: Select the type of resource. For example, select MySQL.
      Notes:
  • OpsRamp monitors multiple flavors of databases like MySQL, PostgreSQL, MS SQL, OracleDB.
  • You must add initial database name while creating an RDS user.
  1. Click +Add to create the corresponding database metrics to the monitor.
    The Metrics list appear.
  2. Provide Configuration parameters: Cloud Resource Configuration (Mandatory)
  3. Click Save.
    The monitor for Cloud database is now created.

Createt template using the monitor

Monitoring templates allow you to save monitoring settings to specific resources. Specific permissions are required to create monitoring templates.

To create a template using the MYSQL database Monitor:

  1. Click Setup.
  2. From the left pane, click Monitoring >Templates.
  3. Click + Add.
    Monitor Template screen appears.
  4. Provide the following required details and click Save.
    • Select Template Scope: Select Partner Template or Client Specific Template.
      For Client-Specific Template, select the Client also.
    • Collector Type: Select the application type that you want to gather the information. For example, Gateway.
    • Monitor Type: Select Monitors for G2 Templates.
    • Applicable for: Select the type of the application. For example, select CloudPaas dB.
    • Template Name: Provide a name of the template.
    • Description: Enter the summary of the template.
    • Monitors: Select the monitor you created for Cloud database.
  5. Verify if the created monitor appears in the list of monitors.
    Monitor details vary for each monitor.

Apply templates to the database

Now, you need to create a template using the monitor that you created for cloud database.

To apply the created template to database:

  1. Select a client from the All Clients list.
  2. Select Setup > Monitoring > Assign Templates.
    ASSIGN TEMPLATES screen appears.
  3. From ASSIGN TEMPLATES, provide details for the following:
    1. From the options displayed in the drop-down list, select a client.
    2. From the options displayed in the drop-down list, select one of the following:
      • Assign Templates to resources
      • Assign Templates to Services
    3. From the options displayed in the drop-down, select a collector type.
    4. Click Show Resource Filters to filter the following:
      • Resource Groups
      • Sites
      • Operating System
    5. After providing the filter details, go to the Select Resources section.
    6. From Select Resources, select the devices.
      The Selected Devices section displays the chosen devices.
    7. After selecting the resources, navigate to Select Monitoring Templates.
    8. From Select Monitoring Templates, select the resources.
      Selected Templates display the chosen templates.
    9. Click Assign.
      ASSIGN TEMPLATES displays the configurations.
    10. Click Submit.
      The templates are assigned to the selected resources.

Validate

When gateway starts monitoring the database, graphs are displayed. Navigate to Infrastructure>Resources>Metrics and verify the graphs.