A bit on scaling chess.com's database

Re:A bit on scaling chess.com's database by dbmikus on Monday January 11, 2021 @09:13PM (#25741390)

If you have 1m clients making DB requests and are hitting performance constraints you could do any of:

  1. Add more ram, CPU, etc to the DB host
  2. Create DB read replicas for higher read volume
  3. Shard the DB (reads and writes)
  4. Offload logic to stateless clients, who you can easily scale horizontally

So option 4 is reasonable if you don't want to or can't do the other options.

[ Parent | on HN ]

Re:A bit on scaling chess.com's database by pupdogg on Monday January 11, 2021 @10:45PM (#25741998)

I would need to know a little more about those 1M requests before making any of your points valid. If 1M are solely reads, you can do real-time transient offload onto Redis without calling it cache and breaking your bank.

[ Parent | on HN ]

Re:A bit on scaling chess.com's database by dbmikus on Tuesday January 12, 2021 @02:40AM (#25743575)

True. I would rephrase option 2 as "cache and/or replicate your query results somewhere".

[ Parent | on HN ]