MariaDB no-locking backup

[yigitahmetsahin]

What problem will this feature address?

While MariaDB backups running it locks the tables and this freezes any application uses MariaDB while backup process. Currently mysql backup command uses option "--single-transaction" while MariaDB backup command is not using this option. Adding this option will fix the problem.

Describe the solution you'd like

Adding "--single-transaction" option to getMariadbBackupCommand.

Describe alternatives you've considered

No need for alternative since the solution is simple in the recommended way.

Additional context

No response

Will you send a PR to implement it?

Yes

[joeltargett]

This would be hugely beneficial. I've just migrated from Coolify to Dokploy, and trying to run a backup on my MariaDB database (12GB) knocks my database offline for 5-10 minutes. --single-transaction would fix this.

[yigitahmetsahin]

@Siumauricio sent a pr for this issue: #2582