mysqldump --single-transaction for online backup
Posted on 2014-09-16
I found the option --single-transaction for mysqldump.
Some forums tell, that using this option, a database can be backed up without locking tables.
How would this work? Why should we use Percona xtrabackup for online database backups if we could simply use mysqldump with --singe-transaction?
I have in mind that mysqldump is not a tool for online backup?
Can you confirm that?
If we use --single-transaction on a production database. Would this be OK?
IT is the goal the have a complete database-backup without interfering the qpplication, which uses the database.
Many thanks in advance!