Cassandra/HBase or just MySQL: Potential problems doing the next thing
- by alexeypro
Say I have "user". It's the key. And I need to keep "user count".
I am planning to have record with key "user" and value "0" to "9999+ ;-)" (as many as I'll have).
What problems I will drive in if I use Cassandra, HBase or MySQL for that?
Say, I have thousand of new updates to this "user" key, where I need to increment the value.
Am I in trouble? Locked for writes?
Any other way of doing that?
Why this is done -- there will be a lot of "user"-like keys. Different other cases. But the idea is the same. Why keep it this way -- because I'll have more reads, so I can always get "counted value" very fast.