上一篇在同一机器上搭建了俩个mysql服务(其实就是不同的端口,一个主3306,一个从3307)
接下来就进行相关主从的配置了:
1.修改主服务器的配置文件my.ini
[mysqld]
server-id = 1
binlog-do-db=rollmachine#要同步的数据库
log-bin=mysql-bin #要生成的二进制日记文件名称
2.修改从服务器的配置文件my.ini
[mysqld]
server-id = 2
log-bin = mysql-bin
replicate-do-db=rollmachine
3.在主数据库中添加用户repl并指定replication权限
create user 'repl'@'127.0.0.1' identified by 'asdf';
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'127.0.0.1';
4.把主数据库rollmachine中的数据复制一份到从数据库
5.在主数据库中运行show master status;并记下file的值和position的值
mysql> show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000001 | 107 | rollmachine | |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
6.在从数据库中进行配置
mysql> change master to master_host='127.0.0.1',master_port=3306,master_user='repl',master_password='asdf',master_log_file='mysql- bin.000001',master_log_pos=107;
Query OK, 0 rows affected (0.19 sec)
7.在从数据库中开启复制功能
mysql> slave start;
Query OK, 0 rows affected (0.00 sec)
8.接着你在主库中进行操作,从数据库就会有相应的操作了!