I’ve transferred a CE installation from sqlite3 to a MariaDB 10 database that is run on a Synology NAS. For backup purposes, I’d like make a copy of the MariaDB database daily at 3am.
Synology will temporary shut down the MariaDB server during the backup, which takes about ten seconds. For me, it is no problem at all if the the seahub website is down for a couple of seconds every night.
I foresee to have large transfers towards Seafile by desktop clients, in the order of hundreds of GBs overnight. During the migration I learned that seafile also has a database present in the MySQL.
Can the temporary shutdown of the MariaDB server during the backup lead to any data integrity problems on the storage? Or is such a backup policy safe to do?