1.分别在主库Master所在服务器(192.168.1.101)、从库Slave(192.168.1.103)所在服务器上安装mysql
2.在Master中作如下配置:
server-id = 1 # 节点ID,确保唯一
# log config
log-bin = mysql-bin #开启mysql的binlog日志功能
log-bin-index = mysql-bin.index
3.创建repl账户并赋给权限
create user repl IDENTIFIED BY 'yourpassword';
grant replication slave on *.* to 'repl'@'192.168.1.103' identified by 'yourpassword';
FLUSH PRIVILEGES;
4.重启数据库,并执行show master status;如下所示
5.在从库中作如下配置并重启
server-id = 2
relay-log-index=slave-relay-bin.index
relay-log=slave-relay-bin
6.对从库进行设置
CHANGE MASTER TO MASTER_HOST = '192.168.1.101', MASTER_USER = 'repl', MASTER_PASSWORD = 'yourpassword', MASTER_PORT = 3306, MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=569, MASTER_RETRY_COUNT = 60, MASTER_HEARTBEAT_PERIOD = 10000;
7.启动从库slave进程 start slave;
8.验证,主库File和position与从库一致,则证明主从同步了
补充:如果针对主库中的某一个库做主从复制,需要在主库my.cnf中添加配置
#test1是库名,需要作主从复制的主库
binlog-ignore-db=test1
#也可以用下面这种方式,除了test2不做主从复制
#binlog-ignore-db=test2
在从库my.cnf中做如下配置:
replicate-do-db=test1
#replicate-ignore-db=test2
在对从库做相关配置前,应先将主库数据迁移到从库。