NYCPHP Meetup

NYPHP.org

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

David Mintz dmintz at davidmintz.org
Wed Dec 28 16:02:32 EST 2005


On Wed, 28 Dec 2005, Adam Fields wrote:

> On Wed, Dec 28, 2005 at 02:35:38PM -0500, David Mintz wrote:
> > 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.
>
> Define "broken".
>
> What does show slave status show?
>

Oops, sorry, too late. I restored replication yesterday and don't
remember.  Other than "seconds behind master" was NULL and some other
value up at the top of the output was other than "waiting for master to
send event," and I did a couple informal tests -- change some data on
master, see if update propagates to slave -- and they failed.


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



More information about the talk mailing list