mysql从做主从,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,说明复制成功。以后复制出问题时，也是用这种方式查看和修改。那种查入一条记录然后看从库中是不是也执行了的办法，不可取。