Actually. I am talking about a machine which is at office. And inside office
we're connecting using ADSL which gets dynamic Ip address. The slave
server's IP address actully doesn't change. It doesn't have a real ip
address only the ADSL has. Simply saying we are using NAT.
What I have in mind is to monitor the Read_Master_Log_Pos,
Exec_master_log_pos with the master server and only allow small differences
like ~10000. And also checking the other Slave_* values.
At this point I'm not trying to fix this on fly. May be later :) I want
to be sure that my slave server is working fine.. Also I think that I
should this situation in "SHOW SLAVE STATUS" that slave is not working
properly.
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.gittigidiyor.com & http://www.dalar.net
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "Cemal Dalar" <[EMAIL PROTECTED]>
Cc: "gerald_clark" <[EMAIL PROTECTED]>; "Group MySQL List"
<[EMAIL PROTECTED]>
Sent: Thursday, June 17, 2004 5:15 PM
Subject: Re: How to monitor that slave is not working because of user
rights?
>
> 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]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
