Setting Up a New Replication Slave
If you use MySQL replication, MySQL Enterprise Backup allows you to set up a slave database without
stopping the master, by backing up the master and restoring that backup on a new slave server.
2. Edit the my.cnf file of the new slave and put skip-slave-start under the [mysqld] section.
3. Start the new slave mysqld (version >= 5.1). It prints the latest MySQL binlog position the backup
knows of.
…
InnoDB: Last MySQL binlog file position 0 128760128, file name ./hundin-bin.006
…
Note that InnoDB only stores the binlog position information to its tablespace at a transaction commit.
To make InnoDB aware of the current binlog position, you must run at least one transaction
while binlogging is enabled.
4. Use the CHANGE MASTER SQL command on the slave to initialize it properly. For example:Restoring a Master Database in Replication
78
CHANGE MASTER TO
MASTER_LOG_FILE='hundin-bin.006',
MASTER_LOG_POS=128760128;
5. Set the statuses of any events that were copied from the master to SLAVESIDE_DISABLED. For
example:
mysql> UPDATE mysql.event SET status = 'SLAVESIDE_DISABLED';
6. Start replication in the new slave with the SLAVE START SQL command.
7. Remove the line skip-slave-start from the my.cnf file of the slave.
If you use MySQL replication, MySQL Enterprise Backup allows you to set up a slave database without
stopping the master, by backing up the master and restoring that backup on a new slave server.
1. /opt/mysql/meb-3.8/bin/mysqlbackup --port=3306 --protocol=tcp --user=root --password=***** --backup-dir=/tempmnt/slavefrom8 backup-and-apply-log
cp /var/lib/mysql/mysql-bin.* /tempmnt/slavefrom8/binarylog/
/tempmnt/此目录为从服务器的NFS目录。
Take the backup, transfer it to the slave server, use mysqlbackup with the apply-log option to
prepare it, and put the restored backup and the log files in the right directories for the new slave.2. Edit the my.cnf file of the new slave and put skip-slave-start under the [mysqld] section.
3. Start the new slave mysqld (version >= 5.1). It prints the latest MySQL binlog position the backup
knows of.
…
InnoDB: Last MySQL binlog file position 0 128760128, file name ./hundin-bin.006
…
Note that InnoDB only stores the binlog position information to its tablespace at a transaction commit.
To make InnoDB aware of the current binlog position, you must run at least one transaction
while binlogging is enabled.
4. Use the CHANGE MASTER SQL command on the slave to initialize it properly. For example:Restoring a Master Database in Replication
78
CHANGE MASTER TO
MASTER_LOG_FILE='hundin-bin.006',
MASTER_LOG_POS=128760128;
5. Set the statuses of any events that were copied from the master to SLAVESIDE_DISABLED. For
example:
mysql> UPDATE mysql.event SET status = 'SLAVESIDE_DISABLED';
6. Start replication in the new slave with the SLAVE START SQL command.
7. Remove the line skip-slave-start from the my.cnf file of the slave.