Btw xtrabackup is not only backup..
时间:2010-03-23 来源:pkman110
Btw xtrabackup is not only backup..
Posted by Vadim | Vote on Planet MySQL
It is obvious thing for me, but I just figured out it may be not common understanding. Xtrabackup is also can be used (not only can, but we actually use it this way) to clone one slave to another, or just setup new slave from the master. And it is done in almost non-blocking way ( true for InnoDB setups) for cloned server. Here is command
PLAIN TEXT CODE:-
innobackupex-1.5.1 --stream=tar /tmp/ --slave-info | ssh user@DESTSERVER "tar xfi - -C /DESTDIR"
When it finished on destination server you run
PLAIN TEXT CODE:-
innobackupex-1.5.1 --apply-log --use-memory=2G /DESTDIR
And you have ready database directory, just copy my.cnf from original server and start mysqld.
相关阅读 更多 + -