Ryan,
show slave status after it stops copying should give you some type of
error information about the failure. What does it show?
Keith
Ryan Klein wrote:
I am having an issue that I cannot determine the cause. We have a
master server that is actually a production server and a slave
I am having an issue that I cannot determine the cause. We have a master server
that is actually a production server and a slave server that is a fall back but
after around 10 days, it stops coping data and the servers fall out of sync.
Here is my my.cnf file for the master server:
key_buffer
From: B. Keith Murphy [mailto:[EMAIL PROTECTED]
show slave status after it stops copying should give you some type of
error information about the failure. What does it show?
In addition to the error, what do the following fields show?
Slave_IO_Running
Slave_SQL_Running