I'm 2/3 of the way to getting my daisy chained replication
working.
Here's my set up
Machine 1:
Compaq Proliant 6000, RedHat Linux 7, mysql 3.23.36, 1 NIC, 2 IPs
server id 1 bound to IP 65.64.51.104
server id 2 bound to IP 65.64.51.105
Machine 2:
Ultrasparc 450, Solaris 2.6, mysql 3.23.26, 1 NIC, 1 IP
server id 3
What I want is 2 to replicate from 1, 3 to replicate from 2
and 1 to replicate from 3.
However, when server 2's slave thread tries to connect to server 1, I get
this:
010413 16:12:20 Slave thread: error connecting to master:Unknown MySQL Server Host ''
(4)(107), retry in 60 sec
I have name resolving turned off and have verified that all the grant
tables are correct, flushed privileges.
It seems that server 2 is not reading the master-host line?
Here's the relevant section of the my.cnf for server 2:
log-bin
server-id = 2
master-host = 64.64.51.104
master-user = repl
master-password = blahblah
master-port = 3306
I've tried everything I can think of. Any help would be most
appreciated!
Cary
--
Cary Collett [EMAIL PROTECTED]
http://cary.ratatosk.org/
"To me boxing is like ballet, except that there's no music, no choreography,
and the dancers hit eachother." -- Jack Handy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php