欢迎光临
我们一直在努力

innobackupex 远程备份

应用于DC1 -> DC2

或者 mysql replication

DC2,接收端:

监听接口1234

nc -l 1234 | tar ixvf – 2> xtrabackup.log

root@python-develpment:/script/slave# nc -l 1234 | tar ixvf – 2> xtrabackup.log

DC1,发送端,备份端

innobackupex –defaults-file=/data/3308/my.cnf –user=root –password=123456 –stream=tar ./ |  nc 192.168.134.130 1234

[root@mysql-master backup]# innobackupex –defaults-file=/data/3308/my.cnf –user=root –password=123456 –slave-info  –stream=tar ./ |  nc 192.168.134.130 1234

170619 16:57:07 [01] Streaming ./pcik_log_dep/t_redbag_get.frm to <STDOUT>

170619 16:57:07 [01]        …done

170619 16:57:07 [01] Streaming ./pcik_log_dep/t_trade.frm to <STDOUT>

170619 16:57:07 [01]        …done

170619 16:57:07 [01] Streaming ./pcik_log_dep/t_mail_del.frm to <STDOUT>

170619 16:57:07 [01]        …done

170619 16:57:07 Finished backing up non-InnoDB tables and files

170619 16:57:07 [00] Streaming xtrabackup_slave_info

170619 16:57:07 [00]        …done

170619 16:57:07 [00] Streaming xtrabackup_binlog_info

170619 16:57:07 [00]        …done

170619 16:57:07 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS…

xtrabackup: The latest check point (for incremental): ‘370373412’

xtrabackup: Stopping log copying thread.

.170619 16:57:07 >> log scanned up to (370373421)

170619 16:57:07 Executing UNLOCK TABLES

170619 16:57:07 All tables unlocked

170619 16:57:07 [00] Streaming ib_buffer_pool to <STDOUT>

170619 16:57:07 [00]        …done

170619 16:57:07 Backup created in directory ‘/backup’

MySQL binlog position: filename ‘mysql-bin.000017’, position ‘4497’

MySQL slave binlog position: master host ‘127.0.0.1’, filename ‘mysql-bin.000028’, position ‘154’

170619 16:57:07 [00] Streaming backup-my.cnf

170619 16:57:07 [00]        …done

170619 16:57:07 [00] Streaming xtrabackup_info

170619 16:57:07 [00]        …done

xtrabackup: Transaction log of lsn (370373412) to (370373421) was copied.

170619 16:57:07 completed OK!

出现completed OK! 代表备份完成

赞(0)
【声明】:本博客不参与任何交易,也非中介,仅记录个人感兴趣的主机测评结果和优惠活动,内容均不作直接、间接、法定、约定的保证。访问本博客请务必遵守有关互联网的相关法律、规定与规则。一旦您访问本博客,即表示您已经知晓并接受了此声明通告。