All 7 Amazon Redshift & Data Warehousing questions
More in Amazon Redshift & Data Warehousing
What is columnar storage, and why does Redshift use it? How does distribution style affect query performance in Redshift? What is Redshift Spectrum, and how does it let you query data outside your cluster? What is Redshift's Workload Management, and how does it help manage multiple concurrent queries? How does Redshift RA3 node architecture separate compute and storage, and why does this matter?
Advertisement
AWS › Amazon Redshift & Data Warehousing

What is Redshift Concurrency Scaling, and how does it handle sudden spikes in query load?

Advanced

Answer

Redshift Concurrency Scaling automatically and transparently adds temporary additional cluster capacity during periods of high concurrent query demand, routing eligible queries to these additional resources so that regular users are not impacted by a sudden burst of queries from another team or an unusually busy period, and this extra capacity is removed automatically once demand returns to normal, with a certain amount of usage included for free each day.
aws redshift modify-cluster --cluster-identifier my-cluster --enhanced-vpc-routing --publicly-accessible false
Real-world example A retail company enables Concurrency Scaling on its Redshift cluster right before a major sales event, ensuring that a sudden surge of business intelligence queries from multiple departments does not slow down performance for any single team.

Common follow-ups: What types of queries are eligible for Concurrency Scaling?;How is Concurrency Scaling usage billed beyond the free daily credits?

Auto Scaling Groups;AWS Cost Management & Billing
All 7 Amazon Redshift & Data Warehousing questions