Best cluster configuration for Amazon Redshift

Question

I currently have a 2 node DS2.Large Redshift Cluster. We are excepting heavy rise in both computation(complex as well as frequent queries) as well as storage( not as important, archiving is an option). What would be the best configuration, a 32 node DC2.Large cluster or a 2 node DC2.8XLarge cluster?

Answer 1

In my experience always go with a larger number of smaller resources. It will add more resiliency if you do not want to lose 50% of your capacity.