mySQL slave configration error
Posted by: Garey Guan
Date: February 08, 2012 03:03PM

hi, experts,
i have two server A(192.168.10.249) and B(192.168.10.250), all windows server2003 with mySQL 5.5.17-log, now i want to congigure the replication from A to B, A is the master:

step 1: stop A mysql service, add

server-id = 1
log-bin
binlog-do-db=reltest
to my.ini file, and start the service.

step 2: stop B mySQL service, add

server-id = 2
master-host=192.168.10.249
master-user=DBA
master-password = ******
master-port = 3306
master-connect-retry = 10
replicate-do-db = reltest

to my.ini configure file,but when i try to start the mySQL service on server B, got Error:
Could not start the mySQL servie on local computer
Error 1067:The process teminated unexpectedly.

even i ony add

server-id = 2
master-host=192.168.10.249

also got the same error, but if i only add

server-id = 2

can start the service, why if i configure the master-host then encounter error?
A and the same workgroup, network no isssue, pls help me, Thanks


Regards
Garey

Options: ReplyQuote


Subject
Views
Written By
Posted
mySQL slave configration error
2581
February 08, 2012 03:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.