Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to realize innobackupex remote backup", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let Xiaobian take you to learn "how to realize innobackupex remote backup"!

1) Backup the MySQL database of hostA to hostB;

2) It can be backed up to remote machines through steam and pipeline of innobackupex;

3) Create the path/home/backup/xtrabackup in hostA and hostB respectively;

4) Execute the following innobackupex statement on hostA:

sudo innobackupex --user=root --password=mytest2018--defaults=/etc/my.cnf --slave-info --stream=tar /home/backup/xtrabackup | ssh -p 22000 lilongqian@10.13.111.27 cat " >" /home/backup/xtrabackup/DBB02_innobackup_20180611.tar

The data will automatically go north to hostB:/home/backup/xtrabackup.

5) End of 4), perform log application operation on hostB:

sudo innobackupex --defaults-file=/etc/my.cnf --user=root --password=mytest2018--use-memory=4G --apply-log /home/backup/xtrabackup

6) Perform database recovery operations:

innobackupex --defaults-file=/etc/my.cnf --user=root --password=mytest2018 --copy-back /home/backup/xtrabackup

7) Start the replication thread above slave according to the binlog position of master.

At this point, I believe everyone has a deeper understanding of "how to achieve innobackupex remote backup," so let's actually operate it! Here is the website, more related content can enter the relevant channels for inquiry, pay attention to us, continue to learn!

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.