innobackupex 远程备份

应用于DC1 -> DC2或者 mysql replication

DC2,接收端：监听接口1234nc -l 1234 | tar ixvf – 2&g开发云主机域名t; xtrabackup.logroot@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 170619 16:57:07 [01] …done170619 16:57:07 [01] Streaming ./pcik_log_dep/t_trade.frm to 170619 16:57:07 [01] …done170619 16:57:07 [01] Streaming ./pcik_log_dep/t_mail_del.frm to 170619 16:57:07 [01] …done170619 16:57:07 Finished backing up non-InnoDB tables and files170619 16:57:07 [00] Streaming xtrabackup_slave_info170619 16:57:07 [00] …done170619 16:57:07 [00] Streaming xtrabackup_binlog_info170619 16:57:07 [00] …done170619 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 TABLES170619 16:57:07 All tables unlocked170619 16:57:07 [00] Streaming ib_buffer_pool to 170619 16:57:07 [00] …done170619 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.cnf170619 16:57:07 [00] …done170619 16:57:07 [00] Streaming xtrabackup_info170619 16:57:07 [00] …donextrabackup: Transaction log of lsn (370373412) to (370373421) was copied.170619 16:57:07 completed OK!
出现completed OK! 代表备份完成

相关推荐: 关系数据模型是什么意思

今天就跟大家聊聊有关关系数据模型是什么意思，可能很多人都不太了解，为了让大家更加了解，小编给大家总结了以下内容，希望大家根据这篇文章可以有所收获。关系数据模型是一种数据模型，以关系或表格的形式对数据进行建模，是用来表示数据在关系数据库中的存储和处理方式，在关系…