Would it be possible to use --single-transaction for Mysql backups? When the InnoDB engine is in use it makes a huge difference in the performance of the site while the backup is happening.

Comments

ronan’s picture

ronan commented

That's good to know. I'll look into what it will take to implement this feature.

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented

Basically this would mean that the site doesn't have to be taken offline for a nontrivial backup. With a regular mysqldump (assuming that's what we're doing) the site freezes during the backup, whereas with --single-transaction, the site continues to work (perhaps with performance degradation) but it doesn't have to be taken offline during the dump.

ronan’s picture

ronan commented
Status: Active » Closed (won't fix)

I'm not using mysqldump for backups with this module, so I'm not sure what I would need to do to emulate this feature. If you have more info on this please reopen.