mysqlhotcopy
Why mysqlhotcopy Is Not So Hotmysqlhotcopy is a command line utility provided with MySQL that automates the process of taking of doing a lock and copy on MyISAM tables. Read more about the lock and copy MySQL backup method.
How Does mysqlhotcopy Work?
mysqlhotcopy sounds as if it should be an online or "Hot" backup method. It is not. The challenge with mysqlhotcopy is that it must hold table locks for the duration of the entire MyISAM backup. This means the database is unavailable while tables are being copies. For most production environments this rnders mysqlhotcopy usless unless it is used during maintenance periods where down time is acceptable. mysqlhotcopy is some times used with great success to take a backup copy of a MySQL Slave replica in larger production environments.
| Category |
Legacy |
| Archive Type | Disk |
| MySQL Storage Engines Supported | MyISAM Only |
| Supported O/S | All |
| Binlog Backup & Restore | No |
| Zero Business Interruption (Online Backups) | No |
| Granular (Table Level) Restore |
Yes |
| Easy to Use Graphical User Interface |
No |
| Complete Server Protection (Backup All Data or just MySQL?) |
No |
| Backup Type |
Full |
| Backup Window Length |
Long |
| Server Disk I/O and Load Impact |
Heavy |
Labels:
None