#MariaDB #backup
...
No any (easy?) way with #mariabackup to dump databases with all tables with "InnoDB" engine in a single transaction. Not using locks, with "--no-locks"[0] option would result in inconsistent dumps.

As the database #replication is already ongoing, seems that would have to forgo backups via "mariabackup" on the primary database sever.

0: Mariabackup Options, https://mariadb.com/kb/en/mariabackup-options/#-no-lock
2/2

#MariaDB backup:
During backing up of databases daily, via "#mysqldump" and/or "#mariabackup" (need to see what recording the process overs ~10 days brought), INSERT queries are delayed due to table locks. That causes a swell in number of open connections, from ~5 to ~70.

One way to avoid locks with "mysqldump", is to divide backing up in 2 main steps:
- when all the tables have #InnoDB engine, dump that database via "--single-transaction" option;
- rest with normal table locks.
1/2 ...