Search Current Space

Skip to end of metadata
Go to start of metadata

mysqlhotcopy

Why mysqlhotcopy Is Not So Hot

mysqlhotcopy 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
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.