Sometimes data sets are so large, a mysqldump to load a slave is just not practical. With some of the systems we have administrated, we have had data so large it would have taken days to load the slave when it became out of sync with the master. When this happens, we usually rely upon Percona’s XTRABackup utility which allows us to make a hot/online backup of the master to use for loading the slave.
In the old days we had to rely upon a third-party tool called ibbackup, or InnoDB Hot Backup utility to do this task. In many ways XTRABackup is a replacement for this tool and has in fact surpassed the ibbackup utility in features and …[Read more...]