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 Guance integration - extension - DataFlux Func (Automata)

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

Enable Script¶

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

Enable Script for Managed Version¶

1. Log in to the Guance console
2. Click on the 【Integration】 menu, select 【Cloud Account Management】
3. Click 【Add Cloud Account】, choose 【Alibaba Cloud】, fill in the required information on the interface; if you have already configured cloud account information, skip 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. Click on the 【Cloud Account Management】 list to see the added cloud account, click the corresponding cloud account to enter the details page
6. Click the 【Integration】 button on the cloud account details page, under the Not Installed list, find Alibaba Cloud RDS MariaDB, click the 【Install】 button, and install it from the pop-up installation interface.

Manually Enable Script¶

1. Log in to the Func console, click 【Script Market】, enter the official script market, search for: guance_aliyun_rds

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

3. Click 【Deploy Startup Script】, the system will automatically create a 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 run it immediately without waiting for the scheduled time. Wait a moment, and you can view the execution task records and corresponding logs.

We default collect some configurations, 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 at the same time, check the task records and logs for any abnormalities.
2. In Guance, under 「Infrastructure / Custom」, check if there is asset information.
3. In Guance, under 「Metrics」, check if there is corresponding monitoring data.

Metrics¶

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

Objects¶

The collected Alibaba Cloud SLB object data structure can be viewed under 「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" : "{Connection Address JSON Data}",
    "DBInstanceStorage": "100",
    "accounts"         : "{User Permission Information JSON Data}",
    "databases"        : "{Database Information JSON Data}",
    "SSLExpireTime"    : "2022-10-11T08:16:43Z",
    "message"          : "{Instance JSON 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 unique identification.

Note 2: Both fields.message and fields.ConnectionString are JSON serialized 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.