mysql logical vs physical backups hot/cold/warm backups

With MySQL, 
physical backups are performed by the MySQL Enterprise Backup product, and 
logical backups are performed by the mysqldump command. These techniques have different characteristics in terms of size and representation of the backup data, and speed (especially speed of the restore operation).
Backups are further classified as hotwarm, or cold depending on how much they interfere with normal database operation. (Hot backups have the least interference, cold backups the most.)

hot backup
A backup taken while the database is running and applications are reading and writing to it. The backup involves more than simply copying data files: it must include any data that was inserted or updated while the backup was in process; it must exclude any data that was deleted while the backup was in process; and it must ignore any changes that were not committed.

Comments

Popular posts from this blog

HAproxy logging

teamcity Automatic Agent Start under Linux

NFS mount add in fstab _netdev instead of default | firewall-cmd --list-all