Effective February 15, 2021, the CodeGuard support center will be merging with the Sectigo support center. This means that support emails will come from support@codeguard.com, and the knowledge base will be hosted on sectigo.com. There will be no interruption of our services, and you will continue to receive top of the line support during and after this transition.

How does CodeGuard back up MySQL databases?

CodeGuard backup uses the industry standard mysqldump tool to back up MySQL databases and does so in such a way that enables the live database to continue to function while also ensuring integrity and consistency of the database backup.

The mysqldump is executed using the 'single-transaction' option. This ensures consistent state of the backup without locking the database. Single-transaction, along with the options 'quick' and 'skip-extended-insert', allows backup of the live database at a point in time without blocking any applications.

CodeGuard backups using mysqldump also ensure low server load, ensuring that the website will continue to function normally while the backup runs in the background. CodeGuard has published results of our msyqldump database backup load testing, which can be found on our blog at http://blog.codeguard.com/database-backup-load-analysis/

More information about how mysqldump works is available at http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request