Re: How to monitor that slave is not working because of user rights?

[gerald_clark]

Why should the slave stop running, just because the IP address changed?
Once the slave is running, how will it know the address changed?
The master will be trying to serve binlogs to the old address, but the 
slave won't know this.
You could monitor the IP address, and stop and start the slave when it 
changes,
but how will the master know about the address change?

A static IP address is not that expensive.
Cemal Dalar wrote:
My point was this situation should affect on Slave_SQL_Running value.. but
in real it is NOT..
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.gittigidiyor.com & http://www.dalar.net
----- Original Message ----- 
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Cemal Dalar" <[EMAIL PROTECTED]>
Cc: "Group MySQL List" <[EMAIL PROTECTED]>
Sent: Thursday, June 17, 2004 4:30 PM
Subject: Re: How to monitor that slave is not working because of user
rights?

 

Cemal Dalar wrote:
   

Hi all,
  I'm running a mysql master - slave configuration. My Slave server is
     

on
 

a dynamic IP address and I restricted the access to master only from
specific IP address for security. I am getting backups through slave
     

server
 

and writted a small java application to monitor the slave status by
     

checking
 

"Slave_SQL_Running" in "SHOW SLAVE STATUS". Everything works fine. But
     

for
 

about once a week my IP address on slave server changes and even if
     

slave
 

does not run and gives the following error on <host>.err file it doesn't
return "No" in both Slave_SQL_Running and Slave_IO_Running. I don't
     

exactly
 

know that this is a bug or not but I need a solution for now.
Thanks for all replies.
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.dalar.net
     

Get a static IP address.
   


 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]