| 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 replication | Vicky Gonzalez | 4 Sep |
| • Re: changing a slave to a master in mysql replication | Bhavin Vyas | 4 Sep |
| • RE: changing a slave to a master in mysql replication | Vicky Gonzalez | 4 Sep |
| • Help!! Extreme newbie | Al Davis | 4 Sep |
| • Re: Help!! Extreme newbie | Dicky Wahyu Purnomo | 4 Sep |
| • Re: Help!! Extreme newbie | Steven Kreuzer | 6 Sep |
| • select statements | julian haffegee | 6 Sep |
| • Re: select statements | Jed Verity | 6 Sep |
| • Re: select statements | julian haffegee | 6 Sep |
| • Re: changing a slave to a master in mysql replication | Bhavin Vyas | 4 Sep |
| • Re: select statements | Jed Verity | 6 Sep |
