Hi Folks
I am setting up a Mikrotik based network and as part of that i am setting a Mikrotik Dude Server for monitoring. I have currently installed the Dude Server on the Mikrotik CRS328 running RouterOS.
But now I am realizing two things
1. Dude server has a database that stores historical values of the various probes
2. Mikrotik CRS 328 has 16MB of disk storage.
The problem with this is that Dude server and files have already taken up 12MB of the space and i fear it will run out of space soon. There are 2 main files that are eating up space. One is the DB called dude.db and the other is a temp file called dude.db-wal. The second file takes up about 4MB and the database dude.db is already reached 1.6MB. Both these files size is gradually increasing.
So i have only 4 options
1. Somehow add additional disk space to Mikrotik CRS328 device
2. Store the Dude database on a remote server and have dude point to that
3. Remove Dude server from the Mikrotik CRS328 and load it onto a standalone device like RaspPie 4
4. Limit the amount of history being stored in the database (for eg: store data only for the past week
I am assuming option 1 and 2 are not possible, That leaves option 3 & 4 . I am not keen on option 3 as that means introducing one more device or VM into an already strained setup.
So question is whether I can do something to implement option 4. Is there any setting to ensure that data older than a week is purged ? Any other suggestions how to manage this