Very true, but I like my NAS to be maintenance-free, and Synology delivers on that. Their apps work out of the box and are installed with basically one click. I fiddle with tech enough at my job, I like my private tech to just work.
Even as a power-user you can do a lot, the synology nas also runs docker, so you can run whatever you’d like on it, not just the synology provided services.
Expanding the hardware is kind of a pain, even with RAM they are kind of weird and you need some approved (synology-brand) ram, or need to fiddle with some system files to make it accept any ram.
Also i’d love if they went with zfs instead of their llvm + btrfs.
With restic you can pipe to stdin, so I use mysqldump and pipe it to restic:
mysqldump --defaults-file=/root/backup_scripts/.my.cnf --databases db-name | restic backup --stdin --stdin-filename db-name.sql
The .my.cnf looks like this:
[mysqldump] user=db-user password="databasepassword"