List:General Discussion« Previous MessageNext Message »
From:Vicky Gonzalez Date:September 3 2002 11:54pm
Subject:changing a slave to a master in mysql replication
View as plain text  
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
Thread
changing a slave to a master in mysql replicationVicky Gonzalez4 Sep
Re: changing a slave to a master in mysql replicationBhavin Vyas4 Sep
RE: changing a slave to a master in mysql replicationVicky Gonzalez4 Sep
  • Help!! Extreme newbieAl Davis4 Sep
    • Re: Help!! Extreme newbieDicky Wahyu Purnomo4 Sep
    • Re: Help!! Extreme newbieSteven Kreuzer6 Sep
      • select statementsjulian haffegee6 Sep
        • Re: select statementsJed Verity6 Sep
          • Re: select statementsjulian haffegee6 Sep
Re: changing a slave to a master in mysql replicationBhavin Vyas4 Sep
Re: select statementsJed Verity6 Sep