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
- Dude server has a database that stores historical values of the various probes
- Mikrotik CRS 328 has a very miserly 16MB of disk storage.
The problem with this is that Dude server and files have already taken up 11MB 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.4MB. From the looks of it dude.db-wal size is constant at 4MB the size of dude.db is gradually increasing.
So i have only 4 options
- Somehow add additional disk space to Mikrotik CRS328 device
- Store the Dude database on a remote server and have dude point to that
- Remove Dude server from the Mikrotik CRS328 and load it onto a standalone device like RaspPie 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 ?