Loading...
 
[Zobrazit/Skrýt nabídky vlevo]
[Zobrazit/Skrýt nabídky vpravo]

Create mysql replication

How to (re)create replica from binary backup

1) stop broken replica
2) make backup of master.info file from replica datadir
3) erase content of datadir
4) create full backup on master: innobackupex --user=root --password=yyyyuuuu /data/mysql/backup
5) unpack binary backup to datadir (use -i tar option ! important)
6) prepare backup: innobackupex --apply-log /data/mysql (replay innodb logs)
7) set approppriate owner: chown -R mysql:mysql /data/mysql
8) start DB
9) get master hosta, usera a password from backuped master.info file, get master_log_file and master_log_pos from xtrabackup_slave_info file
10) set master to appropriate parameters: CHANGE MASTER TO MASTER_HOST='192.168.55.51',MASTER_USER='replicator',MASTER_PASSWORD='ReMy',MASTER_LOG_FILE='master-bin.002295',MASTER_LOG_POS=167172163;
11) start slave;


Created by darek. Last Modification: Pátek 15 of červenec, 2016 09:36:48 CEST by maty.