Introducing MyHoard, your solution to MySQL backups and restoration

MyHoard is an open-source tool developed by Aiven to automate MySQL backups. The tool was created due to the lack of existing solutions that met their specific requirements, such as seamless failovers and support for various cloud storages. MyHoard uses Percona XtraBackup for creating and restoring snapshots, while also handling scheduling, removing old backups, retrying operations, monitoring, and more. It ensures binary logs are rotated within a reasonable amount of time to avoid excessive disk usage and automatically purges binary logs that have been backed up. MyHoard is designed to run as a systemd service and takes a JSON configuration file for managing MySQL-related settings, cloud object storage configurations, backup options, and monitoring preferences.