AWS RDS MySQL¶

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

Configuration¶

Install Func¶

It is recommended to enable TrueWatch Integration - Extension - DataFlux Func (Automata): All prerequisites will be automatically installed. Please continue with the script installation.

If you deploy Func yourself, refer to Self-deployed 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).

To synchronize AWS RDS monitoring data, we install the corresponding collection script: "TrueWatch Integration (AWS-RDS Collection)" (ID: truewatch_aws_rds)

After clicking [Install], enter the corresponding parameters: Amazon AK, Amazon account name.

Click [Deploy Startup Script], and the system will automatically create a Startup script set and automatically configure the corresponding startup script.

In addition, you can see the corresponding automatic trigger configuration in the "Manage / Automatic Trigger Configuration". Click [Execute] to immediately execute it once without waiting for the regular time. After a while, you can view the execution task records and corresponding logs.

We default collect some configurations, for more details, see the metrics column Customize Cloud Object Metrics

Verification¶

1. In "Manage / Automatic Trigger Configuration", confirm whether the corresponding task has an automatic trigger configuration, and at the same time, you can view the corresponding task records and logs to check for any abnormalities.
2. On the TrueWatch platform, under "Infrastructure / Custom", check if there is any asset information.
3. On the TrueWatch platform, under "Metrics", check if there are any corresponding monitoring data.

Metrics¶

Configure Amazon-CloudWatch well, and the default metric set is as follows. You can collect more metrics through configuration Amazon CloudWatch Metric 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 might 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 metric to Amazon CloudWatch in bytes.

Amazon RDS Account-Level 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{:target="blank"} in the _Amazon CloudWatch User Guide. For more information about quotas, see Quotas and Limits for Amazon RDS{:target="blank"} and Requesting an Increase in Your Quota in the _Service Quotas User Guide.

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

Objects¶

The collected AWS RDS MySQL object data structure can be viewed in "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 serialized connection address}",
    "AllocatedStorage": 100,
    "message": "{JSON serialized instance data}"
  }
}

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

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

Tip 2: Both fields.message and fields.Endpoint are JSON serialized strings.