Cemal,
If the connection between your master and your slave is somehow proxied,
then your slave may never know it's address changed. If your slave doesn't
know it's broke, how can it fix itself?
How is this "Dynamic IP" actually being performed? (specifics please)
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Cemal Dalar"
<[EMAIL PROTECTED]> To: "gerald_clark" <[EMAIL
PROTECTED]>
cc: "Group MySQL List" <[EMAIL
PROTECTED]>
06/17/2004 09:44 Fax to:
AM Subject: Re: How to monitor that slave
is not working because of user
rights?
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
