bin-log in 'needed' for a server to act as a master. This will make the
server log all it's queries for the slave to follow. Don't know of a faster
way.
Regards,
Bhavin.
----- Original Message -----
From: "Vicky Gonzalez" <vgonzalez@stripped>
To: <mysql@stripped>
Sent: Tuesday, September 03, 2002 4:54 PM
Subject: changing a slave to a master in mysql replication
Currently to make a slave a master, the docs say you need to set the bin-log
option in my.cnf on the slave, and that will make the transition to master
quicker. I know I can manually change a slave to a master by stopping the
slave process, stop mysql, take a snapshot of the databases, copy over a new
master my.cnf, make sure I have granted rights to a user for the "old"
master to return as a slave, and restart.
My question is how does having the bin-log option on the slave actually help
this process? Or is there an easier way to convert a slave to master using
the log position that I missed?
Thanks in advance for any help.
~Vicky
---------------------------------------------------------------------
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 <mysql-thread118708@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-bvyas3=comcast.net@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
