mysql主-主複製

標籤：設定檔   伺服器   mysql   style   使用者   

設定主-主複製：1、在兩台伺服器上各自建立一個具有複製許可權的使用者；2、修改設定檔：# 主伺服器上[mysqld]server-id = 10log-bin = mysql-binrelay-log = relay-mysqlrelay-log-index = relay-mysql.indexauto-increment-increment = 2auto-increment-offset = 1 # 從伺服器上[mysqld]server-id = 20log-bin = mysql-binrelay-log = relay-mysqlrelay-log-index = relay-mysql.indexauto-increment-increment = 2auto-increment-offset = 2 3、如果此時兩台伺服器均為建立立，且無其它寫入操作，各伺服器只需記錄當前自己二進位記錄檔及事件位置，以之作為另外的伺服器複製起始位置即可 server1|mysql> SHOW MASTER STATUS\G************************** 1. row ***************************            File: mysql-bin.000001        Position: 710    Binlog_Do_DB:Binlog_Ignore_DB:1 row in set (0.00 sec) server2|mysql> SHOW MASTER STATUS\Gmysql> SHOW MASTER STATUS\G*************************** 1. row ***************************            File: mysql-bin.000003        Position: 811    Binlog_Do_DB:Binlog_Ignore_DB:1 row in set (0.00 sec) 4、各伺服器接下來指定對另一台伺服器為自己的主伺服器即可：server1|mysql> CHANGE MASTER TO ...,MASTER_LOG_FILE=‘mysql-bin.000003‘, MASTER_LOG_POS=811 server2|mysql> CHANGE MASTER TO ...,MASTER_LOG_FILE=‘mysql-bin.000001‘, MASTER_LOG_POS=710

來自為知筆記(Wiz)

mysql主-主複製