Alibaba Cloud¶

Alibaba Cloud MongoDB replica set Metrics display, including CPU usage, memory usage, disk usage, data occupying disk space, log occupying disk space, statements executed per second, request count, connection count, network traffic, replication delay, QPS, etc.

Alibaba Cloud MongoDB sharding cluster Metrics display, including CPU usage, memory usage, disk usage, data occupying disk space, log occupying disk space, statements executed per second, request count, connection count, network traffic, replication delay, QPS, etc.

Alibaba Cloud MongoDB single-node instance Metrics display, including CPU usage, memory usage, disk usage, data occupying disk space, statements executed per second, request count, connection count, network traffic, QPS, etc.

Configuration¶

Install Func¶

It is recommended to activate the Guance integration - extension - hosted Func.

If you deploy Func yourself, refer to Self-deployed Func

Activate Script¶

Tip: Please prepare an Alibaba Cloud AK in advance that meets the requirements (for simplicity, you can directly grant global read-only permission ReadOnlyAccess).

Hosted Activation Script¶

1. Log in to the Guance console.
2. Click on the [Integration] menu and select [Cloud Account Management].
3. Click [Add Cloud Account], select [Alibaba Cloud], and fill in the required information on the interface; if you have configured cloud account information before, ignore this step.
4. Click [Test]. After a successful test, click [Save]. If the test fails, check whether the relevant configuration information is correct and retest.
5. In the [Cloud Account Management] list, you can see the added cloud account. Click the corresponding cloud account to enter the details page.
6. Click the [Integrate] button on the cloud account details page. Under the Not Installed list, find Alibaba Cloud MongoDB, click the [Install] button, and install it by following the installation interface.

Manual Activation Script¶

1. Log in to the Func console, click [Script Market], go to the official script market, and search for guance_aliyun_mongodb.

2. After clicking [Install], input the corresponding parameters: Alibaba Cloud AK ID, AK Secret, and account name.

3. Click [Deploy Startup Script], and the system will automatically create a Startup Measurement set and configure the corresponding startup script automatically.

4. After activation, you can see the corresponding automatic trigger configuration under "Management / Automatic Trigger Configuration". Click [Execute] to run it immediately without waiting for the scheduled time. After a short wait, you can view the execution task records and corresponding logs.

We default collect some configurations, see Metrics section for details.

Configure Custom Cloud Object Metrics

Verification¶

1. In "Management / Automatic Trigger Configuration", confirm whether the corresponding task has the corresponding automatic trigger configuration. You can also view the corresponding task records and logs to check for any abnormalities.
2. In Guance, "Infrastructure / Custom", check if there is asset information.
3. In Guance, "Metrics", check if there are corresponding monitoring data.

Metrics¶

After configuring Alibaba Cloud - Cloud Monitoring, the default collected Metrics are as follows, and more Metrics can be collected through configuration. For more Metrics, please refer to: Alibaba Cloud Cloud Monitoring Metrics Details

Cloud Database MongoDB Edition - Replica Set¶

Cloud Database MongoDB Edition - Sharding Cluster¶

Cloud Database MongoDB Edition - Single Node Instance¶

Objects¶

Collected Alibaba Cloud MongoDB object data structure, which can be viewed from "Infrastructure - Custom".

{
  "measurement": "aliyun_mongodb",
  "tags": {
    "name"                 : "dds-bpxxxxxxxx",
    "DBInstanceType"       : "replicate",
    "ChargeType"           : "PrePaid",
    "Engine"               : "MongoDB",
    "DBInstanceClass"      : "dds.xxxxxxxx",
    "DBInstanceId"         : "dds-bpxxxxxxx",
    "ZoneId"               : "cn-hangzhou",
    "RegionId"             : "cn-hangzhou-h",
    "VPCId"                : "vpc-bpxxxxxxxx",
    "EngineVersion"        : "4.2",
    "CurrentKernelVersion" : "mongodb_20210204_4.0.14",
    "StorageEngine"        : "WiredTiger",
    "DBInstanceDescription": "Business System",
    "LockMode"             : "Unlock",
  },
  "fields": {
    "ExpireTime"       : "2020-11-18T08:47:11Z",
    "DBInstanceStorage": "20",
    "ReplicaSets"      : "{Connection Address JSON Data}",
    "message"          : "{Instance JSON Data}",
  }
}

Logs¶

Slow Query Logs¶

Prerequisites¶

Tip: The code execution of this script depends on mongodb instance object collection. If you have not configured the custom object collection for mongodb, the slow log script will not be able to collect slow log data.

Install Slow Query Collection Script¶

Based on the previous steps, you need to install another script corresponding to MongoDB Slow Query Collection.

In the "Script Market - Official Script Market", go to "Details" and click to install the corresponding script package:

• "Guance Integration (Alibaba Cloud - MongoDB Slow Query Log Collection)" (ID: guance_aliyun_mongodb)

After data synchronization is normal, you can view the data in the "Logs" section of Guance.

An example of the reported data is as follows:

{
  "measurement": "aliyun_mongodb_slowlog",
  "tags": {
    "name"                 : "dds-bpxxxxxxxx",
    "DBInstanceType"       : "replicate",
    "ChargeType"           : "PrePaid",
    "Engine"               : "MongoDB",
    "DBInstanceClass"      : "dds.xxxxxxxx",
    "DBInstanceId"         : "dds-bpxxxxxxx",
    "ZoneId"               : "cn-hangzhou",
    "RegionId"             : "cn-hangzhou-h",
    "VPCId"                : "vpc-bpxxxxxxxx",
    "EngineVersion"        : "4.2",
    "CurrentKernelVersion" : "mongodb_20210204_4.0.14",
    "StorageEngine"        : "WiredTiger",
    "DBInstanceDescription": "Business System",
    "DBName"               : "local",
    "AccountName"          : "Alibaba Cloud Account for Script Development",
    "HostAddress"          : "11.xxx.xxx.xx",
    "TableName"            : "oplog",
  },
  "fields": {
    "SQLText"           : "{SQL Statement}",
    "ExecutionStartTime": "1",
    "QueryTimes"        : "1",
    "ReturnRowCounts"   : "1",
    "KeysExamined"      : "1",
    "DocsExamined"      : "1",
  }
}

Descriptions of some parameters are as follows:

Note: Fields in tags, fields may change with subsequent updates.

Tip: fields.message is a string after JSON serialization.