On Fri, Apr 13, 2001 at 04:46:54PM -0400, Cary Collett wrote:
>
> 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
Hi Cary,
Look at master.info. I bet it does not have the correct information. If
you do not yet have your slaves replicating, you could shut down your
slave and delete master.info. It will be created again from my.cnf when
the slave is again started).
(Don't u hat procedure on a working system).
HTH,
- Joe Canon
---------------------------------------------------------------------
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
