Tencent Cloud MariaDB¶

Use the "Cloud Sync" series of script packages in the script market to synchronize cloud monitoring and cloud asset data to Guance

Configuration¶

Install Func¶

It is recommended to activate the Guance Integration - Extensions - DataFlux Func (Automata): all prerequisites are automatically installed, please proceed with the script installation.

If deploying Func manually, refer to Manual Deployment of Func

Install MariaDB Collection Script¶

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

To synchronize MariaDB monitoring data, we install the corresponding collection script: "Guance Integration (Tencent Cloud-MariaDB Collection)" (ID: integration_tencentcloud_mariadb).

Click [Install], then input the corresponding parameters: Tencent Cloud AK, Tencent Cloud account name.

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

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

If you want to collect corresponding logs, you also need to enable the corresponding log collection script. If you want to collect bills, you need to enable the cloud bill collection script.

Verification¶

1. In "Management / Automatic Trigger Configuration", confirm whether the corresponding task has the corresponding automatic trigger configuration, and check the corresponding task records and logs for any exceptions.
2. In Guance, check if asset information exists in "Infrastructure / Custom".
3. In Guance, check if there is corresponding monitoring data in "Metrics".

Metrics¶

After configuring Tencent Cloud Cloud Monitoring, the default Measurement is as follows. More metrics can be collected through configuration. Tencent Cloud Cloud Monitoring Metric Details

Monitoring Metrics¶

Object¶

The collected Tencent Cloud MariaDB object data structure can be seen in "Infrastructure - Custom".

{
  "measurement": "tencentcloud_mariadb",
  "tags": {
    "AppId": "1311xxx185",
    "AutoRenewFlag" : "0",
    "DbEngine"      : "MariaDB",
    "DbVersion"     : "10.1",
    "DbVersionId"   : "10.1",
    "InstanceId"    : "tdsql-ewqokixxxxxhu",
    "InstanceName"  : "tdsql-ewqoxxxxxxihu",
    "InstanceType"  : "2",
    "Paymode"       : "postpaid",
    "ProjectId"     : "0",
    "RegionId"      : "ap-shanghai",
    "Status"        : "0",
    "StatusDesc"    : "Creating",
    "TdsqlVersion"  : "Designed based on MariaDB 10.1 (Compatible with Mysql 5.6)",
    "Uin"           : "100xxxx113474",
    "Vip"           : "",
    "Vport"         : "3306",
    "WanDomain"     : "",
    "WanPort"       : "0",
    "WanVip"        : "",
    "Zone"          : "ap-shanghai-5",
    "name"          : "tdsql-ewqokihu",
    "WanVIP"        : ""
  },
  "fields": {
    "Cpu"           : 1,
    "CreateTime"    : "2023-08-17 17:55:03",
    "Memory"        : 2,
    "NodeCount"     : 2,
    "PeriodEndTime" : "0001-01-01 00:00:00",
    "Qps"           : 2100,
    "Storage"       : 10,
    "UpdateTime"    : "2023-08-17 17:55:03",
    "message"       : "{Instance JSON Data}"
  }
}

Note: Fields in tags and fields may change with subsequent updates

Tip 1: tags.name value is used as the unique identifier

Tip 2: fields.message and fields.InstanceNode are JSON serialized strings