Redshift Reserved Nodes Should Not Be Unused
More Info:
Ensure that your Amazon Redshift Reserved Nodes are being utilized.Risk Level
LowAddress
Cost OptimisationCompliance Standards
CBPTriage and Remediation
Remediation
Using Console
Using Console
To remediate the issue of having unused Redshift Reserved Nodes in AWS, you can follow these steps using the AWS Management Console:
-
Identify Unused Reserved Nodes:
- Go to the AWS Management Console and navigate to the Amazon Redshift dashboard.
- Click on the “Clusters” tab to view the list of Redshift clusters in your account.
- Look for any Reserved Nodes that are marked as “Unused” or have low utilization.
-
Modify or Exchange Reserved Nodes:
- Select the unused Reserved Node that you want to modify or exchange.
- Click on the “Actions” dropdown menu and choose the “Modify” or “Exchange” option.
- If you choose to modify the Reserved Node, you can adjust the node type or the number of nodes to better match your current usage requirements.
- If you choose to exchange the Reserved Node, you can select a different Reserved Node with specifications that better fit your needs.
-
Apply Changes:
- Review the changes you have made to the Reserved Node configuration.
- Click on the “Apply Changes” button to save the modifications or exchanges.
-
Monitor Utilization:
- Regularly monitor the utilization of your Redshift clusters to ensure that the Reserved Nodes are being effectively utilized.
- Adjust the Reserved Node configurations as needed to optimize cost savings and performance.
Using CLI
Using CLI
To remediate the issue of having unused Redshift Reserved Nodes in AWS, you can follow these steps using AWS CLI:
- List all the existing Reserved Nodes in Redshift:
- Identify the Reserved Nodes that are currently unused or underutilized based on their utilization metrics.
- Modify the Reserved Nodes to match the actual usage or delete them if they are no longer needed. You can modify a Reserved Node to a different node type or change the number of nodes using the following command:
- If the Reserved Nodes are no longer needed, you can delete them using the following command:
- Monitor the Redshift clusters to ensure that the Reserved Nodes are now being utilized effectively.
Using Python
Using Python
To remediate the issue of unused Redshift Reserved Nodes in AWS, you can use the AWS SDK for Python (Boto3) to automate the process. Here are the step-by-step instructions to remediate this issue:By following these steps and customizing the script as per your requirements, you can automate the remediation of unused Redshift Reserved Nodes in AWS using Python and Boto3.
- Install Boto3: Ensure you have Boto3 installed in your Python environment. You can install it using pip:
- Create a Python Script: Create a Python script (e.g.,
remediate_redshift_reserved_nodes.py) and import the necessary libraries:
- Initialize Boto3 Client: Initialize the Boto3 client for Redshift:
- List Reserved Nodes: Use the
describe_reserved_nodesmethod to list all the reserved nodes in your Redshift cluster:
- Identify Unused Reserved Nodes: Loop through the reserved nodes to identify any unused nodes. You can check if the
NodeCountis 0 or if the node is not associated with any cluster:
- Modify or Delete Unused Nodes: Depending on your requirements, you can choose to modify the unused nodes (e.g., associate them with a cluster) or delete them. Below are the steps to modify the node and associate it with a cluster:
- Run the Script: Save the script and run it to identify and remediate the unused Redshift Reserved Nodes: