Tencent Cloud MariaDB¶

Use the script market "TrueWatch cloud sync" series script package to synchronize the data of cloud monitoring and cloud assets to TrueWatch

Configuration¶

Install Func¶

It is recommended to enable TrueWatch integration - extension - hosted Func: all prerequisites are automatically installed, please continue with the script installation

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

Install MariaDB collection script¶

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

To synchronize MariaDB monitoring data, we install the corresponding collection script: "TrueWatch integration (Tencent Cloud-MariaDB collection)" (ID: truewatch_tencentcloud_mariadb)

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

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

After enabling, you can see the corresponding automatic trigger configuration in "Manage / Automatic trigger configuration". Click [Execute] to execute immediately without waiting for the scheduled time. Wait for a moment, and you can view the execution task records and corresponding logs.

If you need to collect the corresponding logs, you also need to enable the corresponding log collection script. If you need to collect billing information, enable the cloud billing collection script.

We default to collecting some configurations, for more details see the metrics section Customize cloud object metrics

Verification¶

1. In "Manage / Automatic trigger configuration", confirm whether the corresponding tasks have the corresponding automatic trigger configuration, and at the same time, check the corresponding task records and logs for any anomalies.
2. On the TrueWatch platform, under "Infrastructure / Custom", check if there is asset information.
3. On the TrueWatch platform, under "Metrics", check if there is corresponding monitoring data.

Metrics¶

Configure Tencent Cloud - Cloud Monitoring, the default metric set is as follows. You can collect more metrics through configuration Tencent Cloud Cloud Monitoring Metric Details

Monitoring Metrics¶

Objects¶

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": "Based on MariaDB 10.1 design (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, fields may change with subsequent updates

Tip 1: tags.name value serves as unique identification

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