Percona’s XtraBackup does not lock your database during the backup either - it’s also one of the options in the open-source hot backup world.The mysqlbackup command lets you back up a running MySQL instance (including InnoDB tables) with minimal disruption - when mysqlbackup is backing up InnoDB tables, reads and writes to InnoDB tables can continue.In MySQL, hot backups can be performed using the mysqlbackup command that is part of the MySQL Enterprise Backup component or XtraBackup. Hot backups are often a very convenient solution because they do not require downtime and the disruption of operations is very minimal, but they also have certain downsides: if the data that is being backed up is altered in any way while a backup is in progress, the backup might not be the same as the final version of the data in the database. Hot backups are backups that are performed on data while the database is online and accessible to users.
In this blog post we will try to figure out the similarities and differences between them. When dealing with backups in MySQL, you have probably heard the terms “hot backup”, “warm backup” and “cold backup”.
0 kommentar(er)
