Mysql做主从同步(replication)

   转自：http://www.162cm.com/archives/740.html

Mysql 同步笔记

    1.a为主，b为从.
   >     collation_server                    = utf8_unicode_ci
    两台机器的设置相同。
     
    2.在主(a)上配置:
    [/etc/my.cnf]中mysqld域新增:
   >     sql-bin-update-same
   >     3.在从机器中配置:
   >     master-user=replication
   >     master-port=3306
   >     master-connect-retry=60
   >     log-slave-updates
    4.授权:在a上面进入mysql:
    GRANT REPLICATION SLAVE ON *.* TO 'replication'@'10.62.240.126' IDENTIFIED BY 'replication';
   >      
    mysql>start slave;#启动复制服务
    8:检查主和从之间的同步是否已经跟上:
    在a中运行mysql>show master status;
    mysql> show master status;
    +-------------------+----------+--------------+------------------+
    | File              | Position | Binlog_Do_DB | Binlog_Ignore_DB |
    +-------------------+----------+--------------+------------------+
    | mysqld-bin.000003 |  5614301 | reping       |
    再在从中运行msyql> show  slave status;
    show slave status\G
    *************************** 1. row ***************************
                 Slave_IO_State: Waiting for master to send event
                    Master_Host: 10.62.240.128
                    Master_User: replication
                    Master_Port: 3306
                  Connect_Retry: 60
                Master_Log_File: mysqld-bin.000003
            Read_Master_Log_Pos: 5614301
                 Relay_Log_File: mysqld-relay-bin.000001
                  Relay_Log_Pos: 4214905
          Relay_Master_Log_File: mysqld-bin.000003
               Slave_IO_Running: Yes
              Slave_SQL_Running: Yes
                Replicate_Do_DB:
            Replicate_Ignore_DB:
             Replicate_Do_Table:
         Replicate_Ignore_Table:
        Replicate_Wild_Do_Table:
    Replicate_Wild_Ignore_Table:
                     Last_Errno: 0
                     Last_Error:
                   Skip_Counter: 0
            Exec_Master_Log_Pos: 5614301
                Relay_Log_Space: 4214905
                Until_Condition: None
                 Until_Log_File:
                  Until_Log_Pos: 0
             Master_SSL_Allowed: No
             Master_SSL_CA_File:
             Master_SSL_CA_Path:
                Master_SSL_Cert:
              Master_SSL_Cipher:
                 Master_SSL_Key:
          Seconds_Behind_Master: 0
    1 row in set (0.01 sec)
    注意read_master_log_pos也是5614301,说明复制成功。以后复制出问题时，也是用这种方式查看和修改。那种查入一条记录然后看从库中是不是也执行了的办法，不可取。