MySQL With Backups
The standard MySQL database plus backups to Cloudflare R2
MySQL
mysql
Just deployed
/var/lib/mysql
Backup MySQL to R2
dbanty/rclone-mysql-backup
Just deployed
Deploys the standard Railway MySQL plus a container which backs up that database to Cloudflare R2.
To set up properly, modify the backups service to:
- Disable restarts
- Set a Cron schedule to back up as often as you'd like in settings
Internally, this uses mydumper to dump the database quickly (saving you compute cost over mysqldump) and rclone to sync the data with a folder in an R2 bucket.
You can modify the generated rclone config to support virtually any other target for the backup.
Template Content
MySQL
mysqlBackup MySQL to R2
dbanty/rclone-mysql-backupR2_BUCKET
The name of the bucket to upload to
R2_ENDPOINT
The S3 API URL for your R2 account
R2_ACCESS_KEY_ID
An S3-compatible access key
R2_SECRET_ACCESS_KEY
An S3-compatible access key
