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.

Is my database locked during backup?

CodeGuard does not explicitly lock database rows or tables at any time during the backup process.

For databases using modern storage systems like InnoDB, backups are performed using a single transaction. This allows for backup consistency while avoiding any lock or contention issues. As a result, this process will not impact the operation of your database.

However, if you have large tables using the legacy MyISAM storage engine, that could lead to undesirable behavior. Since MyISAM does not support transactions and enforces table-level locking for read operations, write and update requests to a table may be delayed while the data export is occurring. In the case of a very large table, they could be delayed for several minutes, giving the appearance that the database or application has become unresponsive.

The CodeGuard database backup process uses the industry-standard mysqldump tool to export your database content.

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