10up / wpsnapshots

(DEPRECATED) A project sharing tool for WordPress.
MIT License
216 stars 21 forks source link

dump database using a single transaction #58

Closed dustinrue closed 5 years ago

dustinrue commented 5 years ago

Description of the Change

For larger databases that are in use it is important to perform the mysqldump using a single, global transaction to ensure consistency and also ensure you don't lock the database during the backup which will hang busy sites.

Alternate Designs

Benefits

This will allow large, busy databases to get snapshotted while in use.

Possible Drawbacks

Verification Process

I did a very basic check of running a create to ensure I still got a database backup file

Checklist:

Applicable Issues

No issue was created for this

Changelog Entry

Use --single-transaction during the database backup phase of a create or push