Hello Adam,
i have explained how to properly monitor the mysql replication in this post
http://onaxer.com/blog/blog/tag/mysql-replication/
hope you will find it useful , let me know in case of any questions/doubts.
Thanks
Pankaj
On Sun, Sep 4, 2011 at 10:42 PM, Adam PAPAI <papai.adam@stripped> wrote:
>
>
> Adam PAPAI wrote:
>
>> Dear List,
>>
>> I have a Master -> [ Slave 1, Slave 2 ] setup for years.
>>
>
>
> I have the db under /var/db/mysql
>
> it shows:
>
> -rw-rw---- 1 mysql mysql 149765008 Sep 4 18:37
> tungsten-relay-bin.000214
> -rw-rw---- 1 mysql mysql 67 Sep 4 18:38 relay-log.info
> -rw-rw---- 1 mysql mysql 73 Sep 4 18:38 master.info
>
> but the date is:
>
> [root@tungsten /var/db/mysql]# date
> Sun Sep 4 19:11:13 CEST 2011
>
>
>
> And it's delayed 1 hour. No data is transferred to the slave. It says:
> Secords behind master 0.
>
> What the hell is going on here?
>
>
> --
> Adam PAPAI
> Grapes Communication Kft.
> http://www.grapes.hu
> E-mail: papai.adam@stripped
> Phone: +36 30 33-55-735 (Hungary)
>
>
> --
> MySQL Replication Mailing List
> For list archives:
> http://lists.mysql.com/**replication<http://lists.mysql.com/replication>
> To unsubscribe: http://lists.mysql.com/**replication?unsub=1
> *gmail.com <http://lists.mysql.com/replication?unsub=1
>
>
