This is a post to list the needed stats/history for SPHERE.
For each user - creation and deletion events
- timestamp, username, created or deleted
For each user login attempt
- timestamp, username, succeded or failed
For each organization - creation and deletion
- timestamp, org, username, created or deleted, org category, org description
For each project - creation and deletion
- timestamp, project, username, created or deleted, project category, project description
For each membership change
- timestamp, project or org name, username originating the change, username whose membership is changing, new membership role
For each experiment - creation or deletion or realization/materialization/revision
- timestamp, experiment name, project name, username originating the event, type of event (created, deleted, pushed new model, realization, materialization), succeeded or failed, for push/realize/materialize include model file, for failures include error message
For realizations and materializations
- timestamp, experiment, project, user, list of physical resources involved, list of virtual nodes and lans, allocate or deallocate, success or failure
If some of these cannot be achieved, let’s document what we can and cannot do and keep moving towards the ideal where we have all these
After dev discussion we decided that a database to track these stats is the way to go.
We can still use the existing stats service (which publishes stats to https://grafana.sphere-testbed.net), but those stats are time-series and it sounds like you want straight up stats - which don’t really fit well in time-series format.
Do you have a database preference? MongoDB was one suggestion that was raised…