Here，I have 2 online running mysql machine, master Mysql A and slave B, they are responsible for read and write respectively. But today there is a new business with a lot of reading operate, i hope these queries that it will not affect the performance of origin mysql slave B. So i want to move this part of query operation to a new slave C and the C will sync data from A.
I build three docker container to mock this scene.
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.
This software is published under the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
170830 20:31:20 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: YES).
... ... xtrabackup: The latest check point (for incremental): '235358683' xtrabackup: Stopping log copying thread. .>> log scanned up to (235358683)
xtrabackup: Creating suspend file '/mysql-backup/2017-08-30_20-31-20/xtrabackup_log_copied' with pid '194' xtrabackup: Transaction log of lsn (235358683) to (235358683) was copied. 170830 20:31:20 innobackupex: All tables unlocked
innobackupex: Backup created in directory '/mysql-backup/2017-08-30_20-31-20' innobackupex: MySQL binlog position: filename 'binlog.000003', position 120 170830 20:31:20 innobackupex: Connection to database server closed 170830 20:31:20 innobackupex: completed OK!