Alibaba Cloud RDS MariaDB¶

The displayed Metrics for Alibaba Cloud RDS MariaDB include response time, concurrent connections, QPS, and TPS, etc.

Configuration¶

Install Func¶

It is recommended to enable the TrueWatch integration - extension - DataFlux Func (Automata): all prerequisites will be automatically installed. Please continue with script installation.

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

It is recommended to deploy the GSE version.

Installation Script¶

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

To synchronize the monitoring data of RDS cloud resources, we install the corresponding collection script: "TrueWatch Integration (Alibaba Cloud - RDS Collection)" (ID: truewatch_aliyun_rds)

After clicking [Install], enter the corresponding parameters: Alibaba Cloud AK, Alibaba Cloud account name.

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

In addition, you can see the corresponding automatic trigger configuration in "Manage / Automatic Trigger Configuration". Click [Execute] to run it immediately without waiting for the scheduled time. Wait a moment, and you can view the execution task records and corresponding logs.

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

Configure custom cloud object Metrics

Verification¶

1. In "Manage / Automatic Trigger Configuration", confirm whether the corresponding automatic trigger configuration exists for the task, and check the task records and logs for any abnormalities.
2. On the TrueWatch platform, check if there is asset information under "Infrastructure / Custom".
3. On the TrueWatch platform, check if there are corresponding monitoring data under "Metrics".

Metrics¶

After configuring Alibaba Cloud - Cloud Monitoring, the default Measurement set is as follows. You can collect more Metrics through configuration. Details of Alibaba Cloud Cloud Monitoring Metrics

Objects¶

The collected Alibaba Cloud SLB object data structure can be viewed from "Infrastructure - Custom"

{
  "measurement": "aliyun_rds",
  "tags": {
    "name": "rm-xxxxx",
    "DBInstanceType": "Primary",
    "PayType": "Prepaid",
    "Engine": "MySQL",
    "DBInstanceClass": "rds.mysql.s2.large",
    "DBInstanceId": "rm-xxxxx",
    "ZoneId": "cn-shanghai-h",
    "RegionId": "cn-shanghai",
    "DBInstanceDescription": "Business System",
    "LockMode": "Unlock",
    "Category": "Basic",
    "ConnectionMode": "Standard",
    "DBInstanceNetType": "Intranet",
    "DBInstanceStorageType": "local_ssd"
  },
  "fields": {
    "CreationTime": "2022-12-13T16:00:00Z",
    "ExpireTime": "2022-12-13T16:00:00Z",
    "DiskUsed": "10000",
    "BackupSize": "10000",
    "LogSize": "10000",
    "BackupLogSize": "10000",
    "BackupDataSize": "10000",
    "ConnectionString": "{JSON connection address data}",
    "DBInstanceStorage": "100",
    "accounts": "{JSON user privilege data}",
    "databases": "{JSON database data}",
    "SSLExpireTime": "2022-10-11T08:16:43Z",
    "message": "{JSON instance data}"
  }
}

Note: The fields in tags and fields may change with subsequent updates.

Note: The value of tags.name is the instance ID, used as a unique identifier.

Note 2: fields.message and fields.ConnectionString are serialized JSON strings.

Note 3: The units for fields.DiskUsed, fields.BackupSize, fields.LogSize, fields.BackupLogSize, and fields.BackupDataSize are Bytes, while the unit for fields.DBInstanceStorage is GB.

Note 4: field.SSLExpireTime is in UTC time.