This task can be performed using PortaBase
Self-hosted, automated database backups—open source and under your control
Best product for this task
PortaBase
oss
Portabase is a self-hosted, open source database backup orchestration system for DevOps and DBAs. It centralizes automated backups, retention, and restores across PostgreSQL, MySQL, and MariaDB, keeping all data within your infrastructure while providing secure agents, scheduling, and incident notifications.
What to expect from an ideal product
- PortaBase gives you one central dashboard to manage backup schedules and retention rules across all your PostgreSQL, MySQL, and MariaDB databases instead of juggling separate scripts and cron jobs
- You can set different retention policies for each database or environment, like keeping daily backups for 30 days and weekly backups for 6 months, all from the same interface
- The system automatically handles backup scheduling without you having to write custom scripts or remember to update cron entries when adding new databases
- Everything runs on your own servers so your backup data never leaves your infrastructure, giving you complete control over sensitive database information
- Built-in notifications alert you when backups fail or retention policies need attention, so you catch issues before they become disasters
