I'm using EC2 instance. Looking at i3.2xlarge which gives a tons of storage, but wondering if that's the best for write heavy cluster.
There will be maybe 70% insert/upsert, and 20% scan query, with probably just 10% get by id. All of these doesn't require a tons of storage, so I'm wondering if switching to some of the c5 or r5 instances is better?
Any tips helps thanks a lot!