I’m just trying to get the procedure straight for creating a slave replica of my primary database.
I currently have a single Percona Server with XtraBackup running daily.
Should I be able to;
- Take my last full, create an incremental with it (or just use last nights copy)
- Prepare the backup
- copy across to the slave server
- Configure the db as a slave, start the db and stop the slave process
MASTER_LOG_FILE = ‘xxxx’,
MASTER_LOG_POS = xxxx;
- Start the slave process
- Check slave replication status
Does that seem sane ?
Anything I am missing or should be aware of ?
Is this documented anywhere that I can follow (a search did not return anything useful)