文章详情

  • 游戏榜单
  • 软件榜单
关闭导航
热搜榜
热门下载
热门标签
php爱好者> php文档>Btw xtrabackup is not only backup..

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:
  1. 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:
  1. 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.

排行榜 更多 +
热血突击战官方版

热血突击战官方版

飞行射击 下载
原始传奇176新区

原始传奇176新区

角色扮演 下载
风云岛行动vivo账号版

风云岛行动vivo账号版

角色扮演 下载