安装mysql的主从架构

1. 先决定我的服务器上的mysql为主,虚拟机上的为从.
2. 编辑主mysql的/etc/my.cnf
3. 配置从mysql服务器

---

    ### 编辑主mysql的/etc/my.cnf    ### edit by guang    ### 2017-07-22    ### make a server-id for master mysql .server-id = ip_tail(3) --给master mysql 设置一个server-id=ip后面三位数    ### make log-bin for master mysql --给master mysql 设置一个log-bin    server-id=102    log-bin=mysql-bin    binlog-format=mixed

---

    ### 配置从mysql服务器    ### edit by guang    ### 2017-07-22    ### make a server-id for master mysql .server-id = ip_tail(3) --给master mysql 设置一个server-id=ip后面三位数    ### make log-bin for master mysql --给master mysql 设置一个log-bin    server-id=131    log-bin=mysql-bin    binlog-format=mixed    relay-log=mysql-relay

---

重启主和从的mysql,然后可以看到

[guang@www mysql]$ lsauto.cnf  guang  ibdata1  ib_logfile0  ib_logfile1  mysql  mysql-bin.000001  mysql-bin.index  mysql.sock  performance_schema[guang@www mysql]$ more mysql-bin.000001 mysql-bin.000001: Permission denied[guang@www mysql]$ sudo more mysql-bin.000001 þbinfMrYfmysql> show master status;+------------------+----------+| File             | Position |+------------------+----------+| mysql-bin.000001 |      120 | +------------------+----------+1 row in set (0.01 sec)bin-log顺利生成;

---

然后查看从mysql的服务

mysql> show slave status;Empty set (0.00 sec)发现为空(这是正常的,别慌)主mysql服务器创建授权账号grant replication client,replication slave on *.* to repli@'%' identified by 'Repli@123456';使用被分配的账号密码连接主mysql服务器(master_log_file和maeter_log_pos的配置要根据 show master status来填写)change master to master_host='192.168.0.102',master_user='repli',master_password='Repli@123456',master_log_file='masql-bin.000001',master_log_pos=339;启动从服务器start slave ;查看从服务器的启动情况 show slave status \Gtips:如出现报错,根据报错信息按图索骥~