Alibaba Cloud¶

Alibaba Cloud MongoDB replica set Metrics display, including CPU usage, memory usage, disk usage, data disk space usage, log disk space usage, statements executed per second, number of requests, number of connections, network traffic, replication delay, QPS, etc.

Alibaba Cloud MongoDB sharded cluster Metrics display, including CPU usage, memory usage, disk usage, data disk space usage, log disk space usage, statements executed per second, number of requests, number of connections, network traffic, replication delay, QPS, etc.

Alibaba Cloud MongoDB single node instance Metrics display, including CPU usage, memory usage, disk usage, data disk space usage, statements executed per second, number of requests, number of connections, network traffic, QPS, etc.

Configuration¶

Install Func¶

It is recommended to enable TrueWatch integration - extensions - DataFlux Func (Automata)

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

Enable Script¶

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

Enable Script on DataFlux Func (Automata)¶

1. Log in to the TrueWatch console
2. Click 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 the cloud account information has been configured before, ignore this step
4. Click 【Test】, after the test is successful, click 【Save】. If the test fails, please check whether the relevant configuration information is correct and test again
5. Click 【Cloud Account Management】, you can see the added cloud account in the list, click the corresponding cloud account to enter the details page
6. Click the 【Integration】 button on the cloud account details page, find Alibaba Cloud MongoDB under the Not Installed list, click the 【Install】 button, and the installation interface will pop up for installation.

Manually Enable Script¶

1. Log in to the Func console, click 【Script Market】, enter the TrueWatch script market, search: integration_alibabacloud_mongodb

2. Click 【Install】, then enter the corresponding parameters: Alibaba Cloud AK ID, AK Secret, and account name.

3. Click 【Deploy Startup Script】, the system will automatically create the Startup script set and automatically configure the corresponding startup script.

4. After enabling, you can see the corresponding automatic trigger configuration in 「Management / Automatic Trigger Configuration」. Click 【Execute】 to execute it immediately without waiting for the scheduled time. After a while, you can view the execution task records and corresponding logs.

We have collected some configurations by default, see the 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, and you can also check the corresponding task records and logs to check for any abnormalities
2. In TrueWatch, check whether there is asset information in 「Infrastructure / Custom」
3. In TrueWatch, check whether there is corresponding monitoring data in 「Metrics」

Metrics¶

After configuring Alibaba Cloud CloudMonitor, the following Metrics are collected by default. More Metrics can be collected through configuration. For more Metrics, please refer to: Alibaba Cloud CloudMonitor Metrics Details

Alibaba Cloud MongoDB - Replica Set¶

Alibaba Cloud MongoDB - Sharded Cluster¶

Alibaba Cloud MongoDB - Single Node Instance¶

Object¶

The collected Alibaba Cloud MongoDB object data structure can be seen in 「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}",
  }
}

Log¶

Slow Query Log¶

Prerequisites¶

Note: The code execution of this script depends on the collection of MongoDB instance objects. If the custom object collection of MongoDB is not configured, the slow log script cannot collect slow log data

Install Slow Query Collection Script¶

On the previous basis, you need to install a corresponding MongoDB Slow Query Collection Script

In 「Script Market - Official Script Market」, enter 「Details」, click to install the corresponding script package:

• 「TrueWatch Integration (Alibaba Cloud-MongoDB Slow Query Log Collection)」(ID: integration_alibabacloud_mongodb)

After the data is synchronized normally, you can view the data in the 「Log」 of TrueWatch.

The reported data example 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"          : "Script Development Alibaba Cloud Account",
    "HostAddress"          : "11.xxx.xxx.xx",
    "TableName"            : "oplog",
  },
  "fields": {
    "SQLText"           : "{SQL Statement}",
    "ExecutionStartTime": "1",
    "QueryTimes"        : "1",
    "ReturnRowCounts"   : "1",
    "KeysExamined"      : "1",
    "DocsExamined"      : "1",
  }
}

Some parameter descriptions are as follows:

Note: The fields in tags, fields may change with subsequent updates

Note: fields.message is a JSON serialized string