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]