Innobackupex remote backup
Apply to DC1-> DC2
Or mysql replication.
DC2, receiver:
Listening interface 1234
Nc-l 1234 | tar ixvf-2 > xtrabackup.log
Root@python-develpment:/script/slave# nc-l 1234 | tar ixvf-2 > xtrabackup.log
DC1, sender, backup
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]... done
170619 16:57:07 [01] Streaming. / pcik_log_dep/t_trade.frm to
170619 16:57:07 [01]... done
170619 16:57:07 [01] Streaming. / pcik_log_dep/t_mail_del.frm to
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
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 appears! On behalf of backup completion