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
smime.p7s
Description: S/MIME cryptographic signature