Hi Machiel
use following steps
1) make binary log into readable format through mysqlbinlog
mysqlbinlog -u{user} -p{password} log.log(this any text
file)
2) read text file check next position just after position where replication
is stuck
3) run the *change master* command on
Hi Guys
We need some assistance with a master slave setup we are
experiencing some issues with.
We have one master with 2 slaves replicating from it.
Both the slaves stopped working this morning in the early hours
at exactly the same bin_log file and position.
2012/11/12 Machiel Richards - Gmail machiel.richa...@gmail.com
Hi Guys
We need some assistance with a master slave setup we are
experiencing some issues with.
We have one master with 2 slaves replicating from it.
Both the slaves stopped working this morning in the
Hi Manuel
Please take careful note of what I have stated in the original
mail.
1. the fact that the slaves say seconds behind master = 0
does not neccesarily mean that repliication is working as I have found
this a lot of times where it shows 0 then have proven that
2012/11/12 Machiel Richards - Gmail machiel.richa...@gmail.com
Hi Manuel
Please take careful note of what I have stated in the original
mail.
1. the fact that the slaves say seconds behind master = 0 does
not neccesarily mean that repliication is working as I have found
On Mon, Nov 12, 2012 at 5:21 AM, Machiel Richards - Gmail
machiel.richa...@gmail.com wrote:
1. the fact that the slaves say seconds behind master = 0 does not
neccesarily mean that repliication is working as I have found this a lot of
times where it shows 0 then have proven that
Hi Michael,
Is your binary log running on the slaves?
I have the same issue when forgotten enabling log_bin on SLAVE host
Thanks,
Igor
On 12/11/12 13:04, Machiel Richards - Gmail wrote:
Hi Guys
We need some assistance with a master slave setup we are
experiencing some issues with.