mysql主从复制

上一篇在同一机器上搭建了俩个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.接着你在主库中进行操作，从数据库就会有相应的操作了！