Get the App
SLTechnology News&Howtos  ›  Database  › 

Innobackupex remote backup

Shulou Source: shulou.com Published: 2022-06-01 11:31:31 11月06日 Update

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

Tags: Backup Representative Interface Application Monitoring Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno MariaDB Apple Microsoft Xiaomi NVidia