RA3 Adoption using Simple Replay
Demo Video
Before you Begin
This demo is published as an AWS Blog “Simplify Amazon Redshift RA3 migration evaluation with Simple Replay utility”. Please refer to the blog for detailed instructions. You may follow that along with above demo video. CloudFormation templates (extract and replay) for this demo is available on GitHub.
Client Tool
The demo will leverage the SQL Client Tool of SQLWorkbench/J. Be sure to complete the SQL Client Tool setup before proceeding. Alternatives to the SQLWorkbench include:
- SageMaker: dataengineer.ipynb
- Redshift Query Editor
Challenge
Manhar is an existing Redshift user with previous generation DS2 instances. Management has asked him to evaluate Redshift RA3 instances due to several benefits like separation of storage and compute, data sharing, AQUA and so on. But he got a limited time window to perform this evaluation and don’t want to spend multiple cycles to run this evaluation.
Solution
As detailed in the blog, “Simplify Amazon Redshift RA3 migration evaluation with Simple Replay utility”, Manhar would use AWS CloudFormation templates to extract and replay his past workloads to automatically compare performance between RA3 and DS2 instances. After getting satisfied with the end results, which shows significant improvement on RA3 performance, he may decide to migrate to RA3 instances.
Before you Leave
Please make sure you delete the Replica and Target Redshift clusters created by this process. After that, please delete the cloudFormation template stacks for extract and replay from your AWS account.