請問大大們...
我安裝了三台系統版本完全相的 MySQL server
OS: CentOS 4.4 (update 10/02)
MySQL:
mysql-server-4.1.20-1.RHEL4.1
mysql-4.1.20-1.RHEL4.1
當只有兩台做雙向 Replication 時, 完全沒問題...
但是如果同時用三台的話就破功了 .. :cry:
這三台是這樣設定的..
A Server(IP: 192.168.1.131):
server-id=1
log-bin
sql-bin-update-same
binlog-do-db=test2
master-host=192.168.1.133
master-user=repl
master-password=zxy12345
log-slave-updates
master-port=3306
master-connect-retry=60
replicate-do-db=test2
B Server(IP: 192.168.1.133):
server-id=3
log-bin
sql-bin-update-same
binlog-do-db=test2
master-host=192.168.1.131
master-user=repl
master-password=zxy12345
log-slave-updates
master-port=3306
master-connect-retry=60
replicate-do-db=test2
master-host=192.168.1.134
master-user=repl
master-password=zxy12345
log-slave-updates
master-port=3306
master-connect-retry=60
replicate-do-db=test2
C Server(IP: 192.168.1.134):
server-id=4
log-bin
sql-bin-update-same
binlog-do-db=test2
master-host=192.168.1.133
master-user=repl
master-password=zxy12345
log-slave-updates
master-port=3306
master-connect-retry=60
replicate-do-db=test2
三台 Server 啟動時都沒有任何錯誤訊息..
不過當我在 A Server 操作MySQL(刪除或增加資料),
B & C Server 沒有跟著動作, 而且 A, C 會有錯誤出現...
類似這樣...
061002 11:25:58 [ERROR] Slave: received end packet from server, apparent master shutdown:
061002 11:25:58 [ERROR] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'MySQL03-bin.000001' position 479
061002 11:25:58 [ERROR] Slave I/O thread: error reconnecting to master 'repl@192.168.1.133:3306': Error: 'Lost connection to MySQL server during query' errno: 2013 retry-time: 60 retries: 86400
061002 11:28:00 [Note] Slave: connected to master 'repl@192.168.1.133:3306',replication resumed in log 'MySQL03-bin.000001' at position 479
061002 11:28:01 [ERROR] Error reading packet from server: Client requested master to start replication from impossible position (server_errno=1236)
061002 11:28:01 [ERROR] Got fatal error 1236: 'Client requested master to start replication from impossible position' from master when reading data from binary log
061002 11:28:01 [ERROR] Slave I/O thread exiting, read up to log 'MySQL03-bin.000001', position 479
是不支援這種同步方式?? 還是設定有錯誤??
有無大大試過這種方式, 或是有無這方面的資料可供參考!!
先謝謝嘍~~
:lol: :lol: