Usage
Replication(主从同步)
Master
# my.cnf
server-id = 1
log-bin = mysql-bin
binlog_format = mixed
innodb_flush_log_at_trx_commit=2
sync_binlog=1
# mysql cli
mysql > GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%' IDENTIFIED BY 'l43PMUHNwY6p';
Slave
# my.cnf
server-id = 127001
replicate-do-db=dev_fmd
# mysql cli
# 在 5.6 版本中已不需要指定 master 的 position, mysql 会自动进行定位同步
mysql > CHANGE MASTER TO MASTER_HOST='121.40.221.53', MASTER_USER='repl', MASTER_PASSWORD='l43PMUHNwY6p';
# 数据无法同步时可试着重启 salve, 仍然无效的话可以 reset.
mysql > stop slave;
mysql > start slave;
mysql > reset slave;
Sites