Rule: DynamoDB Tables Should Automatically Scale Capacity

Rule Description

Troubleshooting Steps

2. 1.
   Check Provisioned Capacity: Verify if the DynamoDB table has provisioned capacity enabled. If not, you need to enable it to enable automatic scaling.
4. 2.
   Review Alarms: Ensure that CloudWatch Alarms for DynamoDB are properly set up to trigger auto scaling actions. Check if there are any alarms in a state of insufficient capacity or high utilization that could indicate scaling issues.
6. 3.
   Review Scaling Policy: Confirm that the scaling policy for the table is correctly configured. Ensure that it aligns with the desired capacity and utilization thresholds.
8. 4.
   Review Auto Scaling Configuration: Verify the auto scaling configuration for the table. Ensure that it is properly set up to automatically adjust capacity based on demand.
10. 5.
    Check CloudFormation Templates: If you are using CloudFormation templates, review them to ensure proper configuration of table capacity, scaling policies, and alarms.

Necessary Code

Python:

import boto3

client = boto3.client('dynamodb')

response = client.update_table(
    TableName='your-dynamodb-table-name',
    ProvisionedThroughput={
        'ReadCapacityUnits': desired_read_capacity,
        'WriteCapacityUnits': desired_write_capacity
    },
    BillingMode='PAY_PER_REQUEST'
)

Java:

import com.amazonaws.services.dynamodbv2.AmazonDynamoDB;
import com.amazonaws.services.dynamodbv2.AmazonDynamoDBClientBuilder;
import com.amazonaws.services.dynamodbv2.model.ProvisionedThroughput;
import com.amazonaws.services.dynamodbv2.model.UpdateTableRequest;

AmazonDynamoDB client = AmazonDynamoDBClientBuilder.standard().build();

UpdateTableRequest updateTableRequest = new UpdateTableRequest()
    .withTableName("your-dynamodb-table-name")
    .withProvisionedThroughput(new ProvisionedThroughput()
        .withReadCapacityUnits(desired_read_capacity)
        .withWriteCapacityUnits(desired_write_capacity))
    .withBillingMode("PAY_PER_REQUEST");

client.updateTable(updateTableRequest);

'your-dynamodb-table-name'

desired_read_capacity

desired_write_capacity

Step-by-Step Guide for Remediation

2. 1.
   Step 1: Open the AWS Management Console and navigate to the DynamoDB service.
4. 2.
   Step 2: Select the appropriate region where your DynamoDB table is located.
6. 3.
   Step 3: Click on the name of the desired DynamoDB table that needs automatic scaling.
8. 4.
   Step 4: In the navigation pane, click on the "Capacity" tab.
10. 5.
    Step 5: Under "Auto Scaling", click on the "Manage Auto Scaling" button.
12. 6.
    Step 6: Click on the "Edit" button next to "Auto Scaling is Disabled".
14. 7.
    Step 7: Configure the auto scaling policies by setting the desired values for read and write capacity.
16. 8.
    Step 8: Adjust the "Minimum Units", "Maximum Units", and "Target Tracking" settings based on your requirements.
18. 9.
    Step 9: Click on the "Save" button to enable automatic scaling for the DynamoDB table.
20. 10.
    Step 10: Verify if the automatic scaling policy is successfully applied by checking the status in the "Capacity" tab.