In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.