Huawei Cloud GaussDB SYS.GAUSSDBV5¶

Huawei Cloud GaussDB SYS.GAUSSDBV5, provides data on CPU, memory, disk, deadlocks, SQL response time Metrics, etc.

Configuration¶

Install Func¶

It is recommended to activate Guance integration - extensions - DataFlux Func (Automata): all prerequisites are automatically installed, please proceed with the script installation.

If you want to deploy Func yourself, refer to Deploy Func Yourself

Install Script¶

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

Automata Activation Script¶

1. Log in to the Guance console.
2. Click the 【Integration】 menu, select 【Cloud Account Management】.
3. Click 【Add Cloud Account】, select 【Huawei Cloud】, and fill in the required information on the interface. If you have already configured the cloud account information before, you can skip this step.
4. Click 【Test】, and click 【Save】 after the test is successful. If the test fails, please check if the relevant configuration information is correct and test again.
5. Click 【Cloud Account Management】, and you can see the added cloud account in the list. Click the corresponding cloud account to enter the details page.
6. Click the 【Integration】 button on the cloud account details page, find Huawei Cloud GaussDB SYS.GAUSSDBV5 under the Not Installed list, and click the 【Install】 button. The installation interface will pop up for installation.

Manual Activation Script¶

1. Log in to the Func console, click 【Script Market】, enter the Guance script market, and search for integration_huaweicloud_gaussdb.

2. Click 【Install】, and enter the corresponding parameters: Huawei Cloud AK, SK, and account name.

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

4. After activation, you can see the corresponding automatic trigger configuration in 「Management / Automatic Trigger Configuration」. Click 【Execute】 to execute it immediately without waiting for the scheduled time. After a while, you can check 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 check the corresponding task records and logs to see if there are 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 GaussDB SYS.GAUSSDBV5, the default Measurement is as follows. You can collect more Metrics through configuration Huawei Cloud Cloud Monitoring Metrics Details

Objects¶

The collected GaussDB SYS.GAUSSDBV5 object data structure can be seen in 「Infrastructure - Custom」.

{
  "measurement": "huaweicloud_gaussdb",
  "tags": {
    "RegionId"                : "cn-north-4",
    "db_user_name"            : "root",
    "name"                    : "2e10f990e139xxxxxx5fac6b59de7eein07",
    "port"                    : "3306",
    "project_id"              : "c631f046252d4xxxxxxx5f253c62d48585",
    "status"                  : "BUILD",
    "type"                    : "Cluster",
    "instance_id"             : "1236a915462940xxxxxx879882200in02",
    "instance_name"           : "xxxxx-efa7"
  },
  "fields": {
    "charge_info"          : "{Billing type information, supports pay-as-you-go and subscription}",
    "flavor_info"          : "{Specification information}",
    "volume"               : "{Volume information}",
    "create_time"          : "2023-08-01T14:17:40+0800",
    "update_time"          : "2023-08-01T14:17:42+0800",
    "public_ips"           : "[\"192.168.0.223\"]",
    "nodes"                : "[]",
    "message"              : "{Instance JSON data}",
    "time_zone"            : "UTC+08:00"
  }
}

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

Tip 1: The value of tags.name is the instance ID, which is used as the unique identifier.

Tip 2: fields.message, fields.charge_info, fields.flavor_info, fields.volume, fields.public_ips, fields.nodes are all JSON serialized strings.