2.6.1 Setting Up RDS Monitoring

Mx.Load allows users to collect metrics from AWS RDS Performance Insights in their environment and display metrics from load testing periods. This feature enables users to view both load testing data and RDS metrics on a single screen.

The metrics available for monitoring depend on the RDS engine. For details, refer to 2.6.2 RDS Monitoring Metrics.

Note

Setting up RDS monitoring requires prior completion of 2.5 Target Host Registration.

Specific setup steps for RDS monitoring are as follows:

1. Create a role in the user’s AWS environment for Mx.Load to retrieve data.
2. Register monitoring settings on the target host.

Following these steps allows viewing Performance Insights metrics from the target host’s load testing on the load testing detail screen.

Create a role from the AWS IAM Roles Management Console.

Select “Custom trust policy,” paste the following IAM Role into the edit screen, and proceed.

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Effect": "Allow",
            "Principal": {
                "AWS": "arn:aws:iam::852404677677:role/ecsTaskContainerRole"
            },
            "Action": "sts:AssumeRole",
            "Condition": {}
        }
    ]
}

Select AmazonRDSPerformanceInsightsReadOnly for the permission policy.

Enter a name for the created IAM role. Here, we use mxload-rds-monitoring-role as an example. Verify the trust policy and permission policy are correctly set, then create the role.

After creating the IAM role, register IAM role information and RDS information with Mx.Load.

From the IAM role list, select the IAM role created earlier.

Copy the ARN of the IAM role created.

Go to the Mx.Load screen, click Monitoring Settings for the registered target host from the Dashboard and click Monitoring Settings registered in 2.5 Target Host Registration.

In the RDS Connection Settings, enter the ARN of the created IAM role in IAM Role ARN that can connect to RDS.

For the resource ID of the destination DB, enter the resource ID of the RDS instance with Performance Insights enabled. You can find the resource ID by clicking on the target instance in the RDS management console and checking from the Settings tab.

Select the region where RDS is located for Destination DB Region. Once Resource ID and Region selection are completed, click Add Resource.

After clicking Add Resource, click Verify Connection to verify access to the resource.

Once Verification completed is displayed, click the Update button. If verification fails, please double-check the ARN, Resource ID, and Region entered for any errors.

For configuring multiple RDS resources, configure the DB Resource ID and Region similarly, and perform Add Resource and Connection Verification.

Once Monitoring settings have been successfully updated is displayed, the monitoring settings are complete.

When you execute load testing on the target host, the RDS Performance Insights items are displayed on the Load Testing Details screen. Click the icon on the right to expand and view metrics.

You can now view RDS Performance Insights metrics from the load testing screen.

For available metrics, refer to 2.6.2 RDS Monitoring Metrics.