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 activate Guance integration - extension - DataFlux Func (Automata): all prerequisites will be automatically installed. Please continue with the script installation.

If you deploy Func on your own, refer to Self-deployed Func

Configuration¶

Install Func¶

It is recommended to activate Guance integration - extension - DataFlux Func (Automata)

If you deploy Func on your own, refer to Self-deployed Func

Activation 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).

Managed Version Activation Script¶

1. Log in to the Guance console.
2. Click on the [Manage] menu, select [Cloud Account Management].
3. Click [Add Cloud Account], choose [Alibaba Cloud], and fill in the required information on the interface. If you have already configured the cloud account information, skip this step.
4. Click [Test]. After a successful test, click [Save]. If the test fails, check whether the related configuration information is correct and retest.
5. In the [Cloud Account Management] list, you can see the added cloud accounts. 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.

Manual Activation Script¶

1. Log in to the Func console, click [Script Market], enter the official script market, and 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], and the system will automatically create a Startup script set and configure the corresponding startup script automatically.

4. After activation, you can see the corresponding automatic trigger configuration under [Manage / Automatic Trigger Configuration]. Click [Execute] to immediately run once without waiting for the scheduled time. Wait a moment, then 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. Confirm in [Manage / Automatic Trigger Configuration] whether the corresponding tasks have been configured with automatic triggers. You can also check the task records and logs for any anomalies.
2. In Guance, under [Infrastructure / Custom], check if asset information exists.
3. In Guance, under [Metrics], check if there are corresponding monitoring data.

Metrics¶

After configuring Alibaba Cloud - Cloud Monitoring, the default Measurement sets are 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 seen in [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 permissions 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 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.