MySQL主从DB同步配置

主库172.30.6.2,从库172.30.6.114主库的my.cnf文件加入# 要使用同步功能, log-bin必须开启log-bin=/data/bin-logs/master-log-binrelay-log = /data/relay-logs/master-relay-bin# 同步时主机的ServerID, 必须唯一.server-id = 1 #唯一标识从库的my.cnf文件加入server-id = 2 #唯一标识master-host = 172.30.6.2master-user = replicatemaster-password = replicatelog-bin = /data/bin-logs/master-log-binrelay-log = /data/relay-logs/master-relay-bin在主库和从库中建立bin-log目录mkdir /data/bin-logsmkdir /data/relay-logschown -R mysql:mysql /data/bin-logschown -R mysql:mysql /data/relay-logs在主库中授权,操作这两个权限的时候一定要使用*.*全局操作grant replication client on *.* to 'replicate'@'172.30.6.114' identified by 'replicate';grant replication slave on *.* to 'replicate'@'172.30.6.114' identified by 'replicate';注意:在启动主从同步的时候从库的状态一定要是主库开始记录bin-log时的状态,否则从库无法进行同步