[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