Master-Master(雙主)

1、測(cè)試環(huán)境

Master/Slave???????????????????????? ? Master1/Slave1

IP?? ?192.168.1.13???????????????????????? ?192.168.1.10

為了保持干凈的環(huán)境：兩邊服務(wù)器

rm -rf /var/lib/mysql/*

service mysqld restart

IP:192.168.1.13

IP:192.168.1.10

2、主服務(wù)器授權(quán)

分別在Master/Slave和Master1/Slave1上創(chuàng)建一個(gè)用戶(hù)并授予相應(yīng)權(quán)限。

mysql> grant replication slave on *.* to repli@'192.168.1.13′ identified by '123′;

mysql> grant replication slave on *.* to srepli@'192.168.41.189′ identified by '123′;

然后退出mysql控制臺(tái)，停止mysql服務(wù)：

mysql> \q

3、配置Mysql主配置文件/etc/my.cnf

在/etc/my.cnf配置文件[mysqld]模塊添加如下參數(shù)

Master/Slave(192.168.1.13):

[root@bogon ~]# vim /etc/my.cnf

server-id??????????? = 1

log-bin????????????? = mysql-bin

master-host????????? = 192.168.1.13

master-user????????? = srepli

master-password????? = 123

master-port????????? = 3306

replicate-ignore-db? = mysql

Master1/Slave1(192.168.1.10):

[root@repli1 ~]# vim /etc/my.cnf

server-id???????? = 2

log-bin?????????? = mysql-bin

master-host?????? = 192.168.1.10

master-user?????? = repli

master-password?? = 123

master-port?????? = 3306

replicate-ignore-db???? = mysql

4、查看同步狀態(tài)

service mysqld restart //兩邊服務(wù)器執(zhí)行

在Master1/Slave1上查看

mysql> show slave status\G

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

在master/Slave上查看：

mysql> show slave status\G

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

注：如果沒(méi)有先啟動(dòng)的服務(wù)器Slave_IO_Running: NO mysql> slave stop; mysql> slave start; mysql> show slave status\G 兩邊服務(wù)器建庫(kù)，建表，插入語(yǔ)句

總結(jié)

以上是生活随笔為你收集整理的mysql双主 绿色_mysql (双主，互主)的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。