Tencent Cloud TDSQL_C_MySQL¶

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

Configuration¶

Install Func¶

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

If deploying Func manually, refer to Manual Func Deployment

Enable 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)

Enable Script in Automata¶

1. Log in to the Guance console
2. Click the "Integration" menu, select "Cloud Account Management"
3. Click "Add Cloud Account", select "Tencent Cloud", and fill in the required information on the interface. If the cloud account information has been configured before, ignore this step
4. Click "Test", and if the test is successful, click "Save". If the test fails, please check if the relevant configuration information is correct and test again
5. In the "Cloud Account Management" list, you can see the added cloud account. Click the corresponding cloud account to enter the details page
6. Click the "Integration" button on the cloud account details page, find "Tencent Cloud TDSQL_C_MySQL" in the Not Installed list, and click the "Install" button to pop up the installation interface and install it.

Enable Script Manually¶

1. Log in to the Func console, click "Script Market", enter the Guance script market, and search for integration_tencentcloud_tdsql_c_mysql

2. After clicking "Install", enter the corresponding parameters: Tencent Cloud AK, SK, and account name

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

4. 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 while, you can view the execution task records and corresponding logs

Verification¶

1. In "Management / Automatic Trigger Configuration", confirm whether the corresponding task has the corresponding automatic trigger configuration, and you can also view the corresponding task records and logs to check for any exceptions
2. In Guance, check if there is asset information 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 Metrics Details

Monitoring Metrics¶

Object¶

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}",
  }
}