Mysql学习之XtraBackup(3)-------流备份与远程备份

流备份

相当于备份+打包，优势在于不会占用额外的存储空间，备份打包一步到位

非压缩备份：

innobackupex --defaults-file=/etc/my.cnf -ubkpuser -pxxx --no-timestamp --stream=tar /tmp >/u01/mysqlbackup/all-20190729bak.tar

or

xtrabackup --defaults-file=/etc/my.cnf -ubkpuser -pxxx --backup  --stream=tar  > /u01/mysqlbackup/all-20190730bak.tar

 
压缩备份：

innobackupex --defaults-file=/etc/my.cnf -ubkpuser -pxxx --no-timestamp --stream=tar /tmp |gzip >all-20190729bak.tar.gz

or

xtrabackup --defaults-file=/etc/my.cnf -ubkpuser -pxxx --backup  --stream=tar |gzip  > /u01/mysqlbackup/all-20190730bak.tar.gz

 
远程备份：

xtrabackup --defaults-file=/etc/my.cnf -ubkpuser -pxxx --backup  --stream=tar |gzip |ssh root@192.169.10.242 "cat > /u01/mysqlbackup/all-20190731bak.tar.gz"

 注：远程备份之前要保证备份节点与远程节点之间建立好互信

Linux建立互信的步骤:
        1)两节点分别ssh-keygen -t rsa 生成密钥
        2)把公钥对传给对端 ssh-copy-id -i /root/.ssh/id_rsa.pub 192.169.10.242
        3)ssh 192.169.10.242测试

[root@rhel62 ~]# ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save 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:
8e:e9:fd:27:95:5c:dc:b6:79:c8:bc:6d:17:c7:57:3e root@rhel62
The key's randomart image is:
+--[ RSA 2048]----+
|                 |
|                 |
|             . . |
|              o +|
|        S  . = =+|
|       +    + +E*|
|      o .  .   o*|
|     . .  . . . +|
|      . ...o   ..|
+-----------------+
[root@rhel62 ~]# ssh-copy-id -i /root/.ssh/id_rsa.pub 192.169.10.242
root@192.169.10.242's password: 
Now try logging into the machine, with "ssh '192.169.10.241'", and check in:

  .ssh/authorized_keys

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

[root@rhel62 ~]# ssh 192.169.10.242
Last login: Sun Jul 28 02:13:44 2019 from 192.169.10.1
[root@rhel6 ~]#