Volcengine MySQL¶

Volcengine MySQL Metrics Display, including CPU Usage, Memory Usage, IOPS, Network Bandwidth, InnoDB, TPS, QPS, etc.

Configuration¶

Install Func¶

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

If you deploy Func manually, refer to Manual Func Deployment

Install Script¶

Note: Please prepare the Volcengine 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 MySQL cloud resources, we install the corresponding collection script: "Guance Integration (Volcengine-MySQL Collection)" (ID: integration_volcengine_mysql)

Click 【Install】, then enter the corresponding parameters: Volcengine AK, Volcengine Account Name.

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

After enabling, you can see the corresponding automatic trigger configuration in 「Management / Automatic Trigger Configuration」. Click 【Execute】 to immediately execute once without waiting for the scheduled time. Wait a moment, 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 automatic trigger configuration, and you can also check the corresponding task records and logs to see if there are any abnormalities.
2. In Guance, 「Infrastructure / Custom」, check if there is asset information.
3. In Guance, 「Metrics」, check if there is corresponding monitoring data.

Metrics¶

After configuring Volcengine-MySQL, the default Measurement is as follows, you can collect more metrics through configuration Volcengine Cloud Monitoring Metrics Details

Object¶

The collected Volcengine MySQL object data structure, you can see the object data in 「Infrastructure-Custom」

  {
    "category": "custom_object",
    "fields": {
      "NodeSpec": "rds.mysql.d1.n.1c1g",
      "TimeZone": "UTC +08:00",
      ...
    },
    "measurement": "volcengine_mysql",
    "tags": {
      "AllowListVersion": "initial",
      "DBEngineVersion": "MySQL_5_7",
      "InstanceId": "mysql-xxx",
      "InstanceName": "mysql-xxx",
      "InstanceStatus": "Running",
      "InstanceType": "DoubleNode",
      "LowerCaseTableNames": "1",
      "NodeNumber": "2",
      "ProjectName": "default",
      "RegionId": "cn-beijing",
      "StorageSpace": "20",
      "StorageType": "LocalSSD",
      "SubnetId": "subnet-xxx",
      "VpcId": "vpc-xxx",
      "ZoneId": "cn-beijing-a",
      "name": "mysql-xxx"
    }
  }