4 ms·
clickhouse, influxdb, timescale, rockset, etc are all viable solutions here. a single ec2 box for ~$100/mo would give them ample room to grow. no need to split
by hipadev23 3y ago
clickhouse, influxdb, timescale, rockset, etc are all viable solutions here. a single ec2 box for ~$100/mo would give them ample room to grow. no need to split read/write. This is anything but a hard problem. Literally the defaults on the above DBs and they'd be fine.
20M rows is so tiny it's laughable.
- wutwutwat 3y agoSure, but I think most people use RDS specifically to not have to deal with the ops of maintaining a highly available, fault tolerant, snapshotted, clonable, backed by infinite block storage service. A single ec2 instance won’t fly for any company that wants to exist when an availability zone takes a nap or a developer fat fingers the wrong command in a prod psql session.
- hipadev23 3y agoManaged solutions for all of the above exist for materially lower TCO than cited in the article. It’s more about using the right tool.
- wutwutwat 3y agoThe comment I’m replying to said ec2 instance and that’s what I’m responding to. I’m aware managed services exist for these things, but that’s not what the parent comment said.