Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Innobackupex remote backup

2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report