Master:192.168. 14.115 Slave: 192.168. 14.116
mastermy.cnf file added: [Mysqld]log-bin=mysql-binserver-id=innodb_flush_ Log_at_trx_commit=1 sync_binlog=1 restart
Slave my.cnf File Add Server-id= $
Master creates a login user to use when copying from the slave (you may want to give the user remote access and turn on both firewalls.) MySQL'repl16' @'192.168.14.%'rep116 ';; MySQL'repl16' @'192.168.14.%';
gets the replication start coordinates of the host Binlog locks the database first. mysql>> SHOW MASTER STATUS;
write down the bin file and coordinates of the query results (make sure that the UUID of the two instances is not the same, if you modify the data/auto.cnf file Server_uuid, reboot instance) login slave mysql to perform change MASTER to Master_host='192.168.14.115', Master_user='rep116', Master_password='rep116', Master_log_file='mysql_bin.000001', Master_log_pos=1497; Start slave;
MySQL Master-slave configuration