On Friday 24 August 2001 00:09, Jeremy Zawodny wrote:
On Thu, Aug 23, 2001 at 01:15:25PM -0400, Robinson, Mike wrote:
I just set up a master/slave replication scheme and all is well, but
through the procedure did get bit on the tail.
After the setup, and after the master and slave mysql servers had
been started, I got some error messages that pointed to a type in
the slave's my.cnf file. I shut the slave down, fixed the typo, and
restarted. Got the same error.
I had a look at the master.info, and noticed it contained old
information from the previous my.cnf. There were no binary log
entries in it, so I shut the slave down, deleted the master.info,
and restarted the slave. This fixed the problem and they're
replicating fine. (A terrific feature, my thanks to the mysql team
for that one.)
Question is, is this behaviour by design? Seems to me if you edit
my.cnf and restart the mysql slave the master.info entries
corresponding to the my.cnf file should be updated. Thanks for any
insight.
That's a common problem. Very common. You have to remove the
master.info file, or edit it by hand. :-(
I've called it a bug several times in the past, but it occurs to me
that I may have never told the person who wrote the replication code.
So...
Sasha: Can this be fixed? In my mind it's a bug. One that has bitten
too many people already.
If not, we at least to get it documented here:
http://www.mysql.com/doc/R/e/Replication_Features.html
Thoughts?
It is a feature that needs to be better documented. The main reason
master.info is more authoritative that my.cnf is to support dynamic master
changes. That is if you did CHANGE MASTER TO a different host, you want to
continue replicating from that new master if you restart the slave in the
middle.
The options in my.cnf should really be called default-master-host,
default-master-port, etc, but it is too late to change now - it would cause
more problems that it would solve. In fact, we should probably change the
replication HOWTO to suggest CHANGE MASTER TO command for replication setup
instead of using my.cnf options. The recommended procedure to change masters
is also to use CHANGE MASTER TO command.
Thanks,
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 6 days, processed 88,944,778 queries (148/sec. avg)
Jeremy, your server has been slowing down - it started out at 154 queries per
second, and now is down to 148 :-)
--
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
___/
-
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
