Nms-database
Jump to navigation
Jump to search
Database Information
Currently running against database sitting on backup01. This is the old MySQL 5.7. Need to update to MariaDB for both performance as well as possible new datatype support.
Work todo:
- migrate to recent database release
- investigate support of Postgres
Reminders:
- Nothing database version specific
- avoid foreign key constraints. This is not common and ineffecient, however going this route will make the system more forgiving when random people call API's manually to do things that ignore order of operations. People WILL do this even though they should not, might as well make sure the whole system does not burn when dumb things happen.
- housekeeping should clean orphans on a normal cadence 'automagically' to cover when a user does something that breaks logic or orphans information.
- need better stored procedures investigated