search

nicford / Movilytics

Welcome to our website Movylitics, a Sophisticated GroupLens dataset and tmdb analytics exploration tool.
BSD 3-Clause "New" or "Revised" License
3 stars 3 forks source link

Periodic database backups #18

Closed nicford closed 3 years ago

nicford commented 3 years ago

This is crucial for the robustness of the system. Suggested solution: set a cron job on kubernetes so back up the the database every x time period e.g. once per day when we do updates.

Ofcourse, updating is only really important if we are making changes. But a backup of a read only database could increase startup time in case of volume loss, and a new volume needing to be created

SteveLim99 commented 3 years ago

If no new data is being added into the database considering this isin't a CRUD application, I don't think a regular backup job is needed. The data_init.sql is essentially a sql script consisting of all of the data in the database.

SteveLim99 commented 3 years ago

Moving to priority 3 as other requirements are more important and this would be considered as an extra

nicford commented 3 years ago

Insufficient time