SQLBak

SQLBak — a cloud service for creating and automating database backups (MS SQL Server, MySQL, PostgreSQL, MariaDB, etc.).

Platform testing:
- Installation and operation of Windows agent and Linux agent on various distributions: Ubuntu 20.04/22.04/24.04, Debian, CentOS/AlmaLinux, Rocky Linux — compatibility, installation, and updates verification
- Testing the web interface, creating and executing backup tasks, logging, and monitoring

Functional testing:
- Backups of different database versions: MS SQL 2016–2022, MySQL 5.7/8.0/8.4, PostgreSQL 12–16, MariaDB — compatibility and recovery checks between versions
- Task scheduling, email notifications, retention policies — automatic deletion of old backups according to hybrid schemes (daily/weekly/monthly)
- Execution of scripts before/after backup
- Encryption (AES) and compression (gzip, zstd) of backups with integrity verification of recovery
- Accuracy of schedule execution: transition to summer/winter time, edge cases with cron expressions

Recovery testing:
- Manual and automatic database recovery, point-in-time recovery, recovery to another server or database version, partial recovery of individual tables
- Restore from different types of storage and data integrity verification

Integration and load testing:
- Uploading backups to cloud storage: Google Drive, Dropbox, S3-compatible (MinIO, Wasabi, Backblaze B2), multi-part upload for large files, different regions
- Load testing: backups of large databases (100+ GB), simultaneous backups of multiple servers, impact on DBMS performance during backup
- Network scenarios: connection drop, retry logic, recovery from errors