My Oracle Support Banner

How to Use MySQL Enterprise Backup (MEB) to Backup from Master And Restore to Slave (Doc ID 1951458.1)

Last updated on MAY 23, 2018

Applies to:

MySQL Server - Version 5.6 and later
MySQL Enterprise Backup - Version 3.10 and later
Generic Linux

Goal

How to use MySQL Enterprise Backup (MEB) to backup from Master and restore to Slave.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 1- Backup from master
 
 On the Slave
 3- Shut down MySQL on the Slave
 4- Remove the old data
 5- Restore the data
 6- Guarantee the ownership of the data directory is correct
 7- If SELinux is in use, ensure that the SELinux contexts are correct 
 8- Prevent writes
 9- Start MySQL on the Slave
 10- CHANGE MASTER based on the coordinates in <backupdir>/meta/backup_variables.txt
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.