I’ve recently re-discovered my interest in big data analytics and got an idea to make a logging plugin that would log EVERYTHING.
Well, not literally everything but almost…
- All block interactions
- Hits, kills and self-caused deaths
- Chat messages
- Player movement
- etc. etc. etc.
How many of these events per second would you reckon would be generated on a server with ~50 people actively doing things?
I’m trying to pick the right database for the job…
Tested so far:
- MongoDB - ~6400 writes per second (synthetic workload) I’d expect about half that with real data
- MySQL non-indexed - Abysmal ~250 inserts per second (synthetic workload)
Keep in mind these numbers are from a synthetic predictable workload on unoptimized default installs of the respective DB engines.
Any idea what database would be ideal for this?