Just a follow up- I got replication working, the error was (as usual)
simple... in the MySQL Replication HOWTO, it says 'Add the following to
my.cnf on the slave(s): I of course (:P) put them at the end of the file,
they must go under [mysqld].
But hey, it works!
Thanks
-----Original Message-----
From: Jeremy D . Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 25, 2001 3:30 AM
To: Bryan Coon
Cc: [EMAIL PROTECTED]
Subject: Re: Replication troubles
On Fri, Mar 23, 2001 at 10:45:00AM -0800, Bryan Coon wrote:
> I have two machines which I am trying to set up replication on. I
followed
> the howto as describe in the manual, and everything seemed to be okay
(i.e.
> no errors), but it simply doesn't work.
>
> Heres what I did on the master:
> 1. Copied /usr/share/my-large.cnf to /etc/my.cnf
> 2. my.cnf already had log-bin, server-id=1, so I didnt touch anything else
> 3. Granted file to user repl as in howto
> 4. Shut down master
> 5. Tarred data dir, copied it to slave
> 6. Restarted master
>
> Heres what I did on the slave:
> 1. Copied /usr/share/my-large.cnf to /etc/my.cnf
> 2. Added following info:
> master-host = 172.34.123.34 # IP of master
> master-user = repl
> master-password = repl
> master-port = 3306
> server-id = 2
> 3. Untarred data directories to /var/lib/mysql
> 4. Verified permissions on directories/files untarred
> 5. Restarted slave
>
> The my.cnf file appears to be read okay, because on both machines began
> generating the binary log files immediately.
>
> Both machines report everything normal and happy, with no entries in the
> .err log files. Users can connect to each machine independently and its
> business as usual.
>
> There is no file 'master.info' generated on the slave (I even checked on
the
> master too)...
That's sort of strange...
Does "SHOW SLAVE STATUS" on the slave say anything interesting?
What if you do a "SLAVE START" on the slave?
You're sure that there is literally nothing related in the *.err file
on the slave?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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
