search

arqaamio / LogframeLab-server

Backend Server for Logframe Labs.
https://logframelab.ai
Other
1 stars 3 forks source link

Feature Database Backup Scheduler #43

Closed dotun closed 4 years ago

dotun commented 4 years ago

[#6uuv3m]

AnnKatrina commented 4 years ago

Task linked: CU-6uuv3m Backend - Investigate database solution

git-ari commented 4 years ago

What is the frequency of the backup? and I don't think saving the backup in the application is a good idea, since the application will be replaced with a new one and we will be left with no backup of the database.

dotun commented 4 years ago

What is the frequency of the backup? and I don't think saving the backup in the application is a good idea, since the application will be replaced with a new one and we will be left with no backup of the database.

The backup is scheduled to run every 2 minutes, and the cleanup is scheduled to run every 3 minutes. The cleanup will delete stale backup files, keeping only the 5 most recent ones. Of course, these values are configurable in the application.properties file.

I agree that there could be a better location for backups. Again, the location is configurable in the application.properties backup.location property. I'll leave that to you, @git-ari , as you are managing DevOps.

git-ari commented 4 years ago

I was checking options online, and other than S3 perphaps Glacier would be a cheaper more appropriate option. What do you think @dotun ?

dotun commented 4 years ago

I was checking options online, and other than S3 perphaps Glacier would be a cheaper more appropriate option. What do you think @dotun ?

@git-ari, you could be on to something. I'll look into it, and integrate it if it's appropriate.