NYCPHP Meetup

NYPHP.org

[nycphp-talk] upgrade a mySQL replication slave server without breaking replication?

David Mintz dmintz at davidmintz.org
Wed Dec 28 14:35:38 EST 2005


On Tue, 27 Dec 2005, Adam Fields wrote:

> On Tue, Dec 27, 2005 at 05:14:11PM -0500, David Mintz wrote:
> > I can't seem to find this from RTFM. How indeed do you go about upgrading
> > a slave server from 4.1.x to 5.0.17 and not break replication in the
> > process?
>
> This should be no problem at all - you just shut down the slave,
> upgrade it, and replication should pick up again when you
> restart. Then you can upgrade the master. This is the same as it was
> with 3.x to 4.x.
>

Then I wonder what I did wrong when I upgraded a slave yesterday. The M in
RTFM recommends mysqldumping all your data pre-upgrade and re-storing it
post-upgrade. I did that. When I ran 'show slave status' it was broken.

---
David Mintz
http://davidmintz.org/



More information about the talk mailing list