Archive for category Backup
Taking a hot backup of a MySQL database with XtraBackup
Posted by dctrwatson in Backup, MySQL, Replication on July 16, 2010
A hot backup means you don’t have to take the database offline or stop sending traffic to it. This is especially useful for creating new replication slaves. A hot backup takes minutes vs the hours a dump/import would take. Ideally, all the tables in the database need to be InnoDB; however, Percona has adapted a script (innobackupex) to also backup MyISAM tables (if there are MyISAM tables then you probably should stop sending traffic to it as those require table locks). What makes XtraBackup so nice (besides being free) is that it logs C_UD statements to applied during restoration and it can do incremental backups as well.
Read the rest of this entry »
Using mydumper to parallel dump/import from/to MySQL
Posted by dctrwatson in Backup, MySQL on July 16, 2010
I originally attempted to use mk-parallel-[dump/restore] but I kept running into issues when restoring the data. mydumper (written by Domas Mituzas) has been tested to be faster so I thought I would give it a try.
Read the rest of this entry »