AWS RDS MySQL¶

Use the script package series of 「Guance Cloud Sync」in the script market to synchronize cloud monitoring and cloud asset data to Guance.

Configuration¶

Install Func¶

It is recommended to enable Guance Integration - Extension - Hosted Func: All prerequisites are automatically installed, please continue with script installation.

If you deploy Func manually, refer to Manual Deployment of Func

Install Script¶

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

Hosted Edition Script Activation¶

1. Log in to the Guance console.
2. Click on the 【Integration】menu and select 【Cloud Account Management】.
3. Click 【Add Cloud Account】, choose 【AWS】, and fill in the required information on the interface. If you have already configured cloud account information before, skip this step.
4. Click 【Test】. After a successful test, click 【Save】. If the test fails, check whether the relevant configuration information is correct and retest.
5. In the 【Cloud Account Management】list, you can see the added cloud accounts. Click on the corresponding cloud account to enter the details page.
6. Click the 【Integration】 button on the cloud account details page. Under the Not Installed list, find AWS RDS MySQL, click the 【Install】 button, and install it from the installation interface.

Manual Script Activation¶

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

2. After clicking 【Install】, input the corresponding parameters: AWS AK ID, AK Secret, and account name.

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

4. After enabling, you can see the corresponding automatic trigger configuration under "Management / Automatic Trigger Configuration". Click 【Execute】 to run it immediately without waiting for the scheduled time. Wait a moment, and you can view the execution task records and corresponding logs.

Verification¶

1. Confirm under "Management / Automatic Trigger Configuration" whether the corresponding task has an automatic trigger configuration. You can also check the corresponding task records and logs for any abnormalities.
2. In Guance, under "Infrastructure / Custom", check if there is asset information.
3. In Guance, under "Metrics", check if there is corresponding monitoring data.

Metrics¶

After configuring Amazon-CloudWatch, the default metric sets are as follows. You can collect more metrics through configuration. Amazon CloudWatch Metrics Details

Amazon RDS Instance-Level Metrics in Amazon CloudWatch¶

The AWS/RDS namespace in Amazon CloudWatch includes the following instance-level metrics.

Note:

The Amazon RDS console may display metrics in units different from those sent to Amazon CloudWatch. For example, the Amazon RDS console might display a metric in megabytes (MB), while sending the same metric to Amazon CloudWatch in bytes.

Amazon RDS Usage Metrics in Amazon CloudWatch¶

The AWS/Usage namespace in Amazon CloudWatch includes account-level usage metrics for Amazon RDS service quotas. CloudWatch automatically collects usage metrics for all AWS regions.

For more information, see CloudWatch Usage Metrics in the Amazon CloudWatch User Guide. For more information about quotas, see Quotas and Limits for Amazon RDS and Requesting an Increase in Quota in the Service Quotas User Guide.

• Amazon RDS does not publish the units of usage metrics to CloudWatch. These units appear only in the documentation.

Objects¶

Data structure of collected AWS RDS MySQL objects, which can be viewed under "Infrastructure - Custom".

{
  "measurement": "aws_rds",
  "tags": {
    "name"                     : "xxxxx",
    "RegionId"                 : "cn-northwest-1",
    "Engine"                   : "mysql",
    "DBInstanceClass"          : "db.t3.medium",
    "DBInstanceIdentifier"     : "xxxxxx",
    "AvailabilityZone"         : "cn-northwest-1c",
    "SecondaryAvailabilityZone": "cn-northwest-1d"
  },
  "fields": {
    "InstanceCreateTime"  : "2018-03-28T19:54:07.871Z",
    "LatestRestorableTime": "2018-03-28T19:54:07.871Z",
    "Endpoint"            : "{JSON connection address data}",
    "AllocatedStorage"    : 100,
    "message"             : "{JSON serialized instance data}",
  }
}

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

Tip 1: The value of tags.name is the instance ID, serving as unique identification.

Tip 2: fields.message and fields.Endpoint are JSON serialized string data.