Tencent Cloud CDB¶

Use the「Official Script Market」series script package in the script market to synchronize data from cloud monitoring cloud assets to the observation cloud.

Config¶

Install Func¶

Recommend opening「Integrations - Extension - DataFlux Func (Automata)」: All preconditions are installed automatically, Please continue with the script installation

If you deploy Func yourself,Refer to Self-Deployment of Func

Installation script¶

Tip : Please prepare Tencent Cloud AK that meets the requirements in advance ( For simplicity's sake,You can directly grant the global read-only permissionReadOnlyAccess)

To synchronize the monitoring data of CLB Public cloud resources, we install the corresponding collection script : 「Guance Integration (Tencent Cloud - CDBCollect)」(ID : guance_tencentcloud_clb)

Click [ Install ] and enter the corresponding parameters: Tencent Cloud AK, Tencent Cloud account name.

tap [ Deploy startup Script ] , The system automatically creates Startup script sets, And automatically configure the corresponding startup script.

After this function is enabled, you can view the automatic triggering configuration in「Management / Crontab Config」Click [ Run ] , you can immediately execute once, without waiting for a regular time . After a while, you can view task execution records and corresponding logs.

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

We collected some configurations by default, as described in the Metrics column Configure custom cloud object metrics

Verify¶

1. Into「Management / Crontab Config」, Check whether the automatic triggering configuration exists for the corresponding task, and check whether the task records and logs are abnormal.
2. On the Observing cloud platform, click [ Infrastructure / Custom ] to check whether asset information exists.
3. On the observing cloud platform, click [ Metric ] to check whether monitoring data exists

Metric¶

Configure 「Guance Integration ( Tencent Cloud - CDBCollect)」,The default metric set is as follows. More metrics can be collected through configuration TencentDB for MySQL Monitoring Metrics details

Resources monitoring¶

Engine (general) - MyISAM¶

Engine (general) - InnoDB¶

Engine (general) - connection¶

Engine (general) - access¶

Engine (general) - table¶

Engine (extended) - Tmp¶

Engine (extended) - key¶

Engine (extended) - InnoDB row¶

Engine (extended) - InnoDB data¶

Engine monitoring (extended) - handler¶

Engine (extended) - buffer¶

Engine (extended) - others¶

Engine (extended) - connection¶

Engine (extended) - access¶

Deployment (replica)¶

Object¶

The collected Tencent Cloud CDB object data structure can be seen from "Infrastructure - Custom"

{
  "measurement": "tencentcloud_cdb",
  "tags": {
    "name"         : "cdb-xxxxxxx",
    "RegionId"     : "ap-shanghai",
    "Region"       : "ap-shanghai",
    "InstanceId"   : "cdb-imxxxx",
    "InstanceName" : "smart_check_test",
    "InstanceType" : "1",
    "Zone"         : "ap-shanghai-3",
    "ZoneName"     : "",
    "DeviceType"   : "UNIVERSAL",
    "EngineVersion": "8.0",
    "Vip"          : "172.xx.x.9",
    "Status"       : "1",
    "ProtectMode"  : "0",
    "ProjectId"    : "0",
    "PayType"      : "1",
    "WanStatus"    : "0"
  },
  "fields": {
    "WanPort"     : 0,
    "Memory"      : 1000,
    "Volume"      : 25,
    "DeadlineTime": "0000-00-00 00:00:00",
    "CreateTime"  : "2022-04-27 15:18:06",
    "message"     : "{Instance JSON data}"
  }
}

Logging¶

Slow query statistics¶

Precondition¶

Note: The execution of the script depends on CDB instance object collection. If the custom object collection of CDB is not configured, the slow log script cannot collect slow log data

Installation script¶

On the basis of the previous, you need to install another script ** that corresponds to the collection of CDB slow query statistics logs

In "Script Marketplace - Official Script Market", click and install the corresponding script package:

• 「Guance Integration ( Tencent Cloud - CDB Slow Query Log Collect) 」(ID : guance_tencentcloud_cdb_slowlog)

After data is synchronized, you can view the data in 'Logs' of the observation cloud.

The following is an example of the reported data:

{
  "measurement": "tencentcloud_cdb_slow_log",
  "tags": {
    "name"          : "cdb-llxxxxx",
    "Database"      : "test",
    "UserHost"      : "9.xxx.xxx.122",
    "UserName"      : "root",
    "InstanceId"    : "cdb-lxxxxtk8",
    "DeviceType"    : "UNIVERSAL",
    "EngineVersion" : "8.0",
    "InstanceName"  : "cdbxxxxx",
    "InstanceType"  : "1",
    "PayType"       : "1",
    "ProjectId"     : "0",
    "ProtectMode"   : "0",
    "Region"        : "ap-shanghai",
    "RegionId"      : "ap-shanghai",
    "Status"        : "1",
    "Vip"           : "172.xx.xxx.15",
    "WanStatus"     : "0",
    "Zone"          : "ap-shanghai-3",
    "account_name"  : "脚本开发用 腾讯 Tencent 账号",
    "cloud_provider": "tencentcloud"
  },
  "fields": {
      "QueryTime"   : 3.000195,
      "SqlText"     : "select sleep(3)",
      "Timestamp"   : 1652933796,
      "LockTime"    : 0,
      "RowsExamined": 1,
      "RowsSent"    : 1,
      "SqlTemplate" : "select sleep(?);",
      "Md5"         : "26A15F1AE530F28F",
      "message"     : "{Instance JSON data}"
  }
}

Some parameters are described as follows:

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

Tip 1: tags.name is the instance ID as a unique identifier.

Tip 2: fields.message is the JSON serialized string.