![]() ![]() You would like to evaluate moving this cluster to RA3.4XLarge instances with four nodes and Redshift Serverless with base RPU 64 and 128. Example Use CaseĪs an example, you may assume you have an existing Amazon Redshift cluster with 2 nodes of DC2.8XLarge instances. You need to provide at least one subnet in the same VPC (where you have Redshift provisioned clusters or serverless workgroups) which has access to the internet to download the ECR container image. You can review the considerations when using Amazon Redshift Serverless here. If you are going to replay your workload into Serverless workgroup then make sure that you must have at least three subnets, and they must span across three Availability Zones. As a prerequisite to use simple replay utility, you need to enable audit logging and user-activity logging in your Amazon Redshift provisioned clusters and serverless workgroups. If you are already running Amazon Redshift workload in production, you may like to use this solution to replay your past workload leveraging Amazon Redshift Simple Replay Utility. For more information, see Getting started with AWS CloudFormation. If you haven't used AWS Lakeformation before, you need to add yourself as Data Lake Administrator, please follow the instructions here on Setting up AWS Lake Formation. It uses AWS Lake Formation to manage access on the AWS Glue catalog which stores the performance comparison stats. This solution uses AWS CloudFormation to automatically provision all the required resources in your AWS accounts. You need to store this file in an existing Amazon S3 bucket and then use this AWS CloudFormation template to deploy this solution, which will also initiate an iteration of this test by invoking an Amazon Step Functions state machine in your AWS account. Amazon Redshift Audit Log location and simple replay time window (Optional).SQL Script to conduct sequential and concurrency test (Optional).Redshift Snapshot Identifier (Optional).Amazon Redshift provisioned clusters and Serverless workgroups configurations.You need to create a JSON file to provide your input configurations for your test: Along with other resources, this template also creates an Amazon S3 bucket to store all data and metadata related to this process. ![]() AWS CloudFormation template is used to deploy and run this solution in your AWS Account. The solution uses AWS Step Functions, AWS Lambda and AWS Batch to run an end-to-end automated orchestration to find the best Amazon Redshift configuration based on your price/performance requirements. It helps you find the best Amazon Redshift datawarehouse configuration based on your price performance expectation. If you are already using Amazon Redshift, you may also run your past workloads using Amazon Redshift Simple Replay utility to evaluate performance metrics for different Amazon Redshift configurations to meet your needs. You can use this utility to find the right datawarehouse configuration for your workload based on your query performance expectation for sequential or concurrently running queries. If you are still using the previous version which only supports provisioned clusters, please refer to this readme **Īmazon Redshift Node Configuration Comparison utility answers a very common question on which instance type and number of nodes should we choose for your workload on Amazon Redshift. Amazon Redshift Node Configuration Comparison utility ** Note: This readme walks you through the latest version of this utility which now supports Redshift Serverless to test your workload for performance.If you want to either explore different Redshift Serverless configurations or combination of Redshift Provisioned and Serverless configurations based on your workload, please follow instructions in this readme.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |