设为首页 加入收藏

TOP

Xtrabackup流备份与恢复(二)
2015-11-21 01:58:29 来源: 作者: 【 】 浏览:1
Tags:Xtrabackup 备份 恢复
ave the key (/root/.ssh/id_rsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /root/.ssh/id_rsa.
Your public key has been saved in /root/.ssh/id_rsa.pub.
The key fingerprint is:
29:45:ee:8d:b3:55:f1:5f:2f:da:2a:88:0c:0d:37:9f root@vdbsrv1

###copy 公钥到远程主机
# ssh-copy-id -i ~/.ssh/id_rsa.pub root@192.168.1.7
21
The authenticity of host '192.168.1.7 (192.168.1.7)' can't be established.
RSA key fingerprint is 1d:7c:40:98:ef:de:6f:b8:8c:b2:87:72:0e:79:db:0a.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '192.168.1.7' (RSA) to the list of known hosts.
root@192.168.1.7's password:
Now try logging into the machine, with "ssh 'root@192.168.1.7'", and check in:

.ssh/authorized_keys

to make sure we haven't added extra keys that you weren't expecting.

###验证等效性是否成功
# ssh 192.168.1.7 date;
Wed Apr 15 17:55:31 CST 2015

c、使用tar格式远程增量备份时收到如下提示,即只支持xbstream
xtrabackup: error: streaming incremental backups are incompatible with the
'tar' streaming format. Use --stream=xbstream instead.

d、用流备份,默认的临时目录都是系统的/tmp目录,需要保证该目录有足够的空间,或指定--tmpdir选项

e、流备份日志输出
innobackupex --stream=xbstream /tmp 2>>"$backupLog" | gzip > "$backup_file" 2>>"$backupLog"

首页 上一页 1 2 下一页 尾页 2/2/2
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇Hibernate操作Clob类型数据是怎样.. 下一篇memcache安装和使用

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: