Write heavy cluster, more RAM or CPU?

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!

Indexing can be very I/O intensive, and i2 have fast disks, so should be appropriate. Best way to know is to benchmark your use case and see what resource that limits performance.

1 Like

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.