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

[gerald_clark]

Cemal Dalar wrote:
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.
 

I also have ADSL at home, but for an extra  $15.00 / month I get a 
static IP address.
Most business accounts and many home accounts can get a static address.
Your master has no way of knowing the slave IP address has changed.
Quit banging your head against the wall.
Contact your ISP and request a static address.

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