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:41:34 EST 2005


On Wed, 28 Dec 2005, Adam Fields wrote:
[snip]
> If there's a problem, it's almost certainly one of the following:
>
> 1) The slave is trying to log in to the master with a login that
>    either doesn't exist, has the wrong password (or hash scheme), or
>    has insufficient permissions.
>
> 2) There's some network problem that keeps the slave from seeing the
>    master, or the ip address/port of the master is wrong.
>
> 3) The binlog files aren't being read, written, or run properly.
>
> 4) The binglog files can't be run because the slave state is out of
>    sync with the state of the master when then binlog files were
>    generated or the slave is using the wrong binlog file/position.
>
> That's basically it, and it's usually relatively easy to narrow down
> where the problem is.

Maybe I did something silly and broke it myself. It took some doing
to get it working again for reasons that are also obscure. Anyway, thanks.


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



More information about the talk mailing list