Nms-database: Difference between revisions
Jump to navigation
Jump to search
(Created page with "=== 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 ran...") |
|||
| Line 11: | Line 11: | ||
* housekeeping should clean orphans on a normal cadence 'automagically' to cover when a user does something that breaks logic or orphans information. | * 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 | * need better stored procedures investigated | ||
* enable slow query logging and begin sanity checking some of the more complex queries | |||
Latest revision as of 13:25, 6 June 2023
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
- enable slow query logging and begin sanity checking some of the more complex queries