TODOS

[ItzNotABug]

• [x] Explore Possibility of No Downtimes\ Investigate methods to perform backups without stopping Appwrite services.

• [x] MariaDB Hot Backups\ Implement hot, incremental backups for the Appwrite database to allow live data capture. The issue might arise for other services.

• [ ] Periodic Automated Backups\ Set up scheduled automated backups to ensure regular data protection and minimize manual effort.

• [ ] Explore SQL Dump\ Instead of backing up the whole MariaDB volume, mysqldump sounds more better and performant, could give it a shot. The size differences came at - 1.1MB vs 272.9MB inside a tar.gz.

[ItzNotABug]

Hot Backups kinda works for me but there's probably some gotchas too!

Essentials data could be lost if there's some file or deployment being uploaded in chunks.

1. What I did was to create a script that'd upload a file, a deployment and add a record to databases each second.
2. Once we have definite amount of data, we do abr backup and the backup is created while content is being uploaded and added.
3. Cancelled the updates, performed a restore and the data came back as is, at the point of backup.

[ItzNotABug]

Feedback thread regarding using Volumes x SQLDump 🚀 - https://discord.com/channels/564160730845151244/837593904952901634/threads/1303299950809059340.