On Mon, Oct 06, 2003 at 12:43:37PM -0700, David L. Sifry wrote: > An update to the problem, and a workaround (bug report?): > > Jeremy Zawodny wrote: > > >While the tables are locked, be sure to also copy the slave's > >master.info file, relay log(s), and relay index file. Transfer all of > >that to the other slave and you should be good to go. > > > >Does that make sense? > > > > > > > Actually, that's exactly what I did (the tarball of the /var/lib/mysql > directory includes the master.info, relay logs, and relay index file) > but with no joy. > > What finally got it to work was to make the following changes: > > The relay bin file copied over is called "slave1-relay-bin.xxx" and the > relay bin index file is called "slave1-relay-bin.index". > > I had to change things around because the new slave I was copying to is > called "slave2". > > 1. mv slave1-relay-bin.xxx slave2-relay-bin.xxx > 2. mv slave1-relay-bin.index slave2-relay-bin.index > > Then I had to edit the first line of relay-log.info to point to the new > files, changing "slave1-relay-bin.xxx" to "slave2-relay-bin.xxx": > > Then I started mysql, and did a SLAVE START and everything worked. > > Is this a bug?
Not really. It's working as designed. One thing you might do is to explicitly name the relay files in your my.cnf file so that they're hostname independant. relay-log = /path/to/blah/relay-log relay-log-index = /path/to/blah/relay-index Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 22 days, processed 839,067,119 queries (425/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
