Our great sponsors
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
Oh, this is an interesting problem that I've solved for personally years ago in a project called Sheep. Note, this project won't work for your specific use case, but the premise is the same. Essentially, you're right that a transaction on a single row would create a hotspot, so what you must do is shard the counter across N rows.
NOTE:
The number of mentions on this list indicates mentions on common posts plus user suggested alternatives.
Hence, a higher number means a more popular project.