Tencent Cloud TDSQL_C_MySQL¶

Use the "Cloud Sync" series of script packages in the Script Market to synchronize cloud monitoring and cloud asset data to TrueWatch

Configuration¶

Install Func¶

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

If you are deploying Func manually, refer to Manual Deployment of Func

Install TDSQL_C_MySQL Collection Script¶

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

To synchronize the monitoring data of TDSQL_C_MySQL, we install the corresponding collection script: "TrueWatch Integration (Tencent Cloud-TDSQL_C_MySQL Collection)" (ID: integration_tencentcloud_tdsql_c_mysql).

After clicking 【Install】, input the corresponding parameters: Tencent Cloud AK, Tencent Cloud account name.

Click 【Deploy Startup Script】, the system will automatically create a Startup script set and configure the corresponding startup scripts.

After enabling, you can see the corresponding automatic trigger configuration in 「Manage / Automatic Trigger Configuration」. Click 【Execute】 to immediately execute it once without waiting for the scheduled time. After a while, you can check 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 billing data, you need to enable the cloud billing collection script.

Verification¶

In 「Manage / Automatic Trigger Configuration」, confirm whether the corresponding task has the automatic trigger configuration, and you can also check the corresponding task records and logs to see if there are any exceptions.
In TrueWatch, check if asset information exists in 「Infrastructure / Custom」.
In TrueWatch, check if there is corresponding monitoring data in 「Metrics」.

Metrics¶

After configuring Tencent Cloud Cloud Monitoring, the default Measurement is as follows. You can collect more metrics by configuring Tencent Cloud Cloud Monitoring Metrics Details

Monitoring Metrics¶

Metric Name	Metric Chinese Name	Description	Unit	Dimensions
`BytesSent`	Client Traffic Sent per Second	Client Traffic Sent per Second	MB/s	InstanceId
`BytesReceived`	Client Traffic Received per Second	Client Traffic Received per Second	MB/s	InstanceId
`ComDelete`	Delete Count	Delete Count	count/s	InstanceId
`ComInsert`	Insert Count	Insert Count	count/s	InstanceId
`ComUpdate`	Update Count	Update Count	count/s	InstanceId
`MemoryUse`	Memory Usage	Memory Usage	count/s	InstanceId
`ComSelect`	Query Count	Query Count	count/s	InstanceId
`MaxConnections`	Maximum Connections	Maximum Connections	count/s	InstanceId
`SlowQueries`	Slow Query Count	Slow Query Count	count/s	InstanceId
`ThreadsRunning`	Running Thread Count	Running Thread Count	count/s	InstanceId
`Memoryuserate`	Memory Usage Rate	Memory Usage Rate	%	InstanceId
`Storageuserate`	Storage Usage Rate	Storage Usage Rate	%	InstanceId
`Storageuse`	Storage Usage	Storage Usage	GB	InstanceId
`Connectionuserate`	Connection Utilization Rate	Connection Utilization Rate	%	InstanceId
`Tps`	Transactions per Second	Average number of successfully executed transactions per second (including rollbacks and commits)	count/s	InstanceId
`Cpuuserate`	CPU Usage Rate	CPU Usage Rate	%	InstanceId
`Qps`	Queries per Second	Queries per Second	count/s	InstanceId
`Queries`	Total Requests	Total requests within a statistical period	count/s	InstanceId

Objects¶

The collected Tencent Cloud tdsql_c_mysql object data structure can be seen in 「Infrastructure - Custom」.

{
  "measurement": "tencentcloud_tdsql_c_mysql",
  "tags": {
    "ClusterType" : "0",
    "InstanceId"  : "cmxxxx",
    "InstanceName": "test_01",
    "InstanceType": "1",
    "MongoVersion": "MONxxxx",
    "NetType"     : "1",
    "PayMode"     : "0",
    "ProjectId"   : "0",
    "RegionId"    : "ap-nanjing",
    "Status"      : "2",
    "VpcId"       : "vpc-nf6xxxxx",
    "Zone"        : "ap-nanjing-1",
    "name"        : "cmxxxx"
  },
  "fields": {
    "CloneInstances"   : "[]",
    "CreateTime"       : "2022-08-24 13:54:00",
    "DeadLine"         : "2072-08-24 13:54:00",
    "ReadonlyInstances": "[]",
    "RelatedInstance"  : "{Instance JSON Data}",
    "ReplicaSets"      : "{Instance JSON Data}",
    "StandbyInstances" : "[]",
    "message"          : "{Instance JSON Data}",
  }
}