You can use the gateway to monitor cloud database metrics.

To begin monitoring, you need to complete the cloud configuration setup for your particular cloud environment. This document uses the Azure cloud environment as an example.

Prerequisites

  • Configure VPN connectivity for the gateway.
  • Verify that the database you want to monitor is publicly available.
  • You can deploy gateway before or after the cloud integration. If the gateway is deployed before cloud instances are discovered, ensure that the gateway is on the same private network after discovery.
  • If the cloud instances to be monitored are on different private networks, deploy multiple gateways.
  • Each gateway deployed to monitor the cloud instances must be registered with the cloud.
  • Create a cloud database and configure security.
  • Make sure you have the permissions required to create monitoring templates.

Create a cloud database

Using Azure as an example:

  1. Log into Azure.

  2. In the left panel, click SQL databases.

  3. Click +Add to create a database.

  4. Enter the following information:

    • Resource Group: Select the resource group you want from the drop-down.
    • Database name: Enter a unique database name.
    • Server: Select a server with sufficient capacity to host the database.
    • Compute+storage: Select the compute and storage options.
  5. Click Review + create.

  6. Verify that the newly created database is in the list of MySQL servers.

Configure security

  1. From the list of MySQL Database servers, click the name of the database you created.
  2. In the left panel Settings menu, click Connection security .
  3. Configure the gateway IP information.
  4. Click Submit.

The database is now configured with gateway security credentials. This creates the discovery profile.

Assign a gateway profile

On the OpsRamp platform, assign a gateway profile to the cloud integration.

  1. Click All Clients and select a client from the list.
  2. Navigate to Setup > Integrations > Integrations.
  3. From Installed Integrations, click Public Cloud and click Azure.
  4. Click the Integration name.
  5. From the Configuration tab, navigate to Discovery Profiles and click +Add.
  6. From the Filter Criteria, select the Filter Criteria Type of Smart Filters.
  7. Select All resources and click Save.
  8. (Optional) If you need to discover new resources automatically without manual intervention, configure the Discovery Schedule.

Create and assign database credentials

  1. Click Infrastructure.
  2. Select the Resources tab
  3. Click Microsoft Azure, and select the database that you created.
  4. In the left panel, click Credentials.
  5. Click +Add to create new credentials.
  6. Click +Assign and assign credentials to the required client.
  7. Verify if the new credentials appear in the credentials list.

Add a database monitor

  1. Navigate to Setup > Monitoring > Monitors.

  2. Click + Add.

  3. Enter the following monitor information:

    • Monitor Scope: Select Partner Monitor or Client-Specific Monitor. For a Client-Specific Monitor, also select the client.
    • Adaptor Type: Select the monitor type, such as Application.
    • Application Type: Select the type of database resource, such as MySQL. Add the initial database name if you are creating an RDS user.
  4. Click +Add.

  5. Enter Configuration parameters: (Mandatory) Cloud Resource Configuration.

  6. Click Save.

Add database monitor templates

Templates permit you to save resource monitoring settings.

  1. Navigate to Setup > Monitoring >Templates.

  2. Click + Add.

  3. Enter the following information:

    • **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, such as CloudPaas dB.
    • Template Name: Provide a template name.
    • Description: Enter the template summary.
    • Monitors: Select the monitor you created for Cloud database.
  4. Click Save.

  5. Verify that the created monitor is displayed in the available monitors list. Monitor details differ depending on monitor.

Apply templates

  1. Select a client from the All Clients list.

  2. Navigate to Setup > Monitoring > Assign Templates.

  3. Select a client from the drop-down list.

  4. Select one of the following from the drop-down list:

    • Assign Templates to Resources
    • Assign Templates to Services
  5. Select a collector type from the drop-down list.

  6. Click Show Resource Filters to filter on one of the following categories:

    • Resource Groups
    • Sites
    • Operating System
  7. Go to the Select Resources section.

  8. From Select Resources, select the devices. The Selected Devices section displays the selected devices.

  9. Go to Select Monitoring Templates and select the resources. The Selected Templates list displays the templates you selected and want to assign.

  10. Click Assign.

  11. Click Submit.

Validate

Navigate to Infrastructure > Resources > Metrics to view database metrics graphs, which begin to be displayed when the gateway starts monitoring the database.