I recently started a project in my free time, which is about constructing a very very simple mmo 3-tier architecture (for a max player count of 100).
I came to the point where I have to decide what data can be stored in the backend (MySQL). Constantly storing a players position seems unefficient to me.
The same goes for item properties like damage, item level and other.
I wonder how this thing would be done by an expert. My idea was to store player data only if something happend (like level up) and save players position every 5 minutes or something.
For the item properties part, i thought of a construction, that the item data may be stored in the backend, but initialy loaded once the server starts up. So the item properties would be stored in the memory of the server. If I change something at runtime of an item, this item could be reloaded again.
I hope you understand what I am trying to do and maybe you can give me tips or links to some articles.