1、环境
操作系统:win7 64位
mysql版本:5.7.19。下载地址:https://dev.mysql.com/downloads/mysql/
2、mysql安装
下载文件mysql-5.7.19-winx64.zip到本地,分别解压到两个目录:
D:\mysql-5.7.19-winx64
D:\mysql-5.7.19-winx64-slave
将"D:\mysql-5.7.19-winx64\bin"添加到环境变量
两个目录下分别增加my.ini文件,内容分别为
master:
[mysqld]
#skip-grant-tables
basedir=D:/mysql-5.7.19-winx64
datadir=D:/mysql-5.7.19-winx64/data
bind-address=127.0.0.1
port=3306
server-id=1
log-bin=master-bin
log-bin-index=master-bin-index
slave:
[mysqld]
#skip-grant-tables
basedir=D:/mysql-5.7.19-winx64-slave
datadir=D:/mysql-5.7.19-winx64-slave/data
bind-address=127.0.0.1
port=3307
server-id=2
relay-log=slave-relay-bin
relay-log-index=slave-relay-bin.index
两个目录下分别执行安装:
D:\mysql-5.7.19-winx64\bin>mysqld install mysql
D:\mysql-5.7.19-winx64-slave\bin>mysqld install mysql-slave
两个目录下分别执行初始化:
D:\mysql-5.7.19-winx64\bin>mysqld --initialize
D:\mysql-5.7.19-winx64-slave\bin>mysqld --initialize
会发现两个目录下新增了data目录,并为root用户分配了默认密码(见D:\mysql-5.7.19-winx64-slave\data\$主机名.err日志)
启动两个实例:
net start mysql
net start mysql-slave
3、配置主从
执行:
create user repl_user;
grant replication slave on *.* to repl_user identified by 'repl_user';
cmd登陆到从实例
mysql -u root -P3307 -p
输入密码,回车进入mysql客户端
执行:
change master to master_host='127.0.0.1', master_port=3306, master_user='repl_user', master_password='repl_user';
start slave;