You can use the gateway to monitor cloud database metrics.

To start monitoring, you need to complete the cloud configuration setup for your 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 configured with gateway security credentials. This creates the discovery profile.

Assign a gateway profile

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.

How to include Manual configuration to Cloud based templates

To create a template that supports both cloud and manual parameters for all database monitoring, follow the steps below:

  1. Navigate to an advanced cloud template with any database monitoring which is applicable to cloud devices and clone the advanced cloud monitor applied to it.
Template Name - Advanced Cloud MSSQL Database Databases Template

Go to the applied monitor on the advanced cloud template and check the cloud configuration parameters:

NameDisplay NameDescriptionDefault Value
collector.application.typeApplication TypeApplication type
connection.timeout.msconnection timeout in msconnection timeout in ms15000
cloud.resource.configMSSQL cloud resource configMSSQL cloud resource config${could_resource_config}
  1. Select G2-monitor with same database monitoring from the G2 templates which are applicable to on-premise devices.

Template Name - G2 Cloud MSSQL Database Databases Template

Go to the applied monitors on the G2 template and check the configuration parameters:

NameDisplay NameDescriptionDefault Value
collector.application.typeApplication TypeApplication type
connection.timeout.msconnection timeout in msconnection timeout in ms15000
mssql.dbname.listMSSQL DB instance listMSSQL DB instance listmaster
  1. Navigate to the newly cloned monitor and edit the monitor configuration parameters, add the above G2 parameters to the cloned monitor.

The monitor will now have both cloud and manual parameters for monitoring, check the configuration parameters:

NameDisplay NameDescriptionDefault Value
collector.application.typeApplication TypeApplication type
connection.timeout.msconnection timeout in msconnection timeout in ms15000
cloud.resource.configMSSQL cloud resource configMSSQL cloud resource config${could_resource_config}
mssql.dbname.listMSSQL DB instance listMSSQL DB instance listmaster

Now create a new template and apply this new monitor to it,then that template supports both cloud parameters and manual parameters for monitoring.

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 are displayed when the gateway starts monitoring the database.