Innobackupex the meaning of--slave-info parameters and the applicable scenarios

Source: Internet
Author: User

http://blog.itpub.net/28916011/viewspace-1969135/I have a problem has not been understood, is innobackupex inside of the--slave-info this parameter, is what to do. Finally in order to help and my experiment to figure out the meaning.
Here is a statement that I often use to back up the whole library:
Innobackupex--defaults-file=/etc/my.cnf--user=root--password= ' 123 '--host=localhost--rsync--compress-- Compress-threads=5--compress-chunk-size=64k--slave-info/root

Now let's look at the help and see what this--slave-info means:
[Email protected] ~]# Innobackupex--help |grep-c 5 slave
--slave-info
This option is useful the backing up a replication slave server. It
Prints the binary log position and name of the master server. It
Also writes this information to the "Xtrabackup_slave_info" file as
A "Change MASTER" command. A new slave for this master can is set up
By starting a slave server in this backup and issuing a "change
MASTER "command with the binary log position saved in the
"Xtrabackup_slave_info" file.

Here's what I understand:
When backing up from the library, you can use this parameter, plus the--slave-info backup directory will generate more than one Xtrabackup_slave_info file, here will save the main log file and offset, the file content is similar to the following: Change MASTER to Master_ Log_file= ', master_log_pos=0.
This parameter applies to the scenario: Assume that there is now a master library A and from library B, and now want to add a repository C, and let the repository C in the main library a master, because the main library A is a production library, the pressure is generally relatively large, so we back up a database on the repository B, and then take this backup to C server and import Next, execute the Change Master command on the C server: where Master_host is the IP of a, and Master_log_file and Master_log_pos are the values in this xtrabackup_slave_info. I don't know if that's clear (Czxin note).

Innobackupex the meaning of--slave-info parameters and the applicable scenarios

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.