Re: On fighting with master-slave replication lag

Yeah. You should use mk-heartbeat, it's the best tool for this situation that I have seen before. On Wed, Dec 24, 2008 at 10:06 PM, Baron Schwartz wrote: > On Wed, Dec 24, 2008 at 2:31 AM, Jake Maul wrote: > > Slightly more complicated (and also probably more accurate- the time > > reported by

RE: On fighting with master-slave replication lag

il.com [mailto:baron.schwa...@gmail.com] On Behalf > Of Baron Schwartz > Sent: 2008年12月26日 0:56 > To: xufeng > Cc: Jake Maul; claudio.na...@gmail.com; andy-li...@networkmail.eu; > mysql@lists.mysql.com > Subject: Re: On fighting with master-slave replication lag > > 2008/12/24 xufen

Re: On fighting with master-slave replication lag

2008/12/24 xufeng : > > >> -Original Message- >> From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On Behalf >> Of Baron Schwartz >> Sent: 2008年12月24日 22:06 >> To: Jake Maul >> Cc: mysql@lists.mysql.com >> Subject: Re: On fig

Re: On fighting with master-slave replication lag

your great help. >> Yours >> Xu Feng >> >> >> >>> -Original Message- >>> From: xufeng [mailto:xuf...@yuanjie.net] >>> Sent: 2008年12月25日 10:13 >>> To: 'Baron Schwartz'; 'Jake Maul'; claudio.na..

Re: On fighting with master-slave replication lag

tworkmail.eu; claudio.na...@gmail.com >> Cc: mysql@lists.mysql.com >> Subject: RE: On fighting with master-slave replication lag >> >> >> >> >>> -Original Message- >>> From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On >

RE: On fighting with master-slave replication lag

etworkmail.eu; claudio.na...@gmail.com > Cc: mysql@lists.mysql.com > Subject: RE: On fighting with master-slave replication lag > > > > > -Original Message- > > From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On Behalf > > Of Baron Schwartz

RE: On fighting with master-slave replication lag

> -Original Message- > From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On Behalf > Of Baron Schwartz > Sent: 2008年12月24日 22:06 > To: Jake Maul > Cc: mysql@lists.mysql.com > Subject: Re: On fighting with master-slave replication lag > > On W

Re: On fighting with master-slave replication lag

On Wed, Dec 24, 2008 at 2:31 AM, Jake Maul wrote: > Slightly more complicated (and also probably more accurate- the time > reported by show slave status is known to be unreliable in some cases) > would be a script that inserts a row into a table, then check the > slave over and over till it arrive

Re: On fighting with master-slave replication lag

There's a couple ways to go about this. The simplest thing (and what we use in most of our simple monitoring cases) is a shell script that checks the output of "show slave status\G" on the slave periodically. If it reports that either thread isn't running, or there's something in "Last error", or t

Re: On fighting with master-slave replication lag

Hi, I use Mycat to monitor more than 300 servers using a single config file. It can be used only for replication monitoring though Regards, Chandru www.mafiree.com On Tue, Dec 23, 2008 at 10:51 PM, Andy Shellam wrote: > Hi > > I would suggest a Nagios monitoring system, useful for many di

Re: On fighting with master-slave replication lag

Hi I would suggest a Nagios monitoring system, useful for many different checks and with plugins to check also mysql replication. I'll second this. The standard check_mysql plugin included with Nagios allows you to monitor a MySQL slave and alert when the lag behind the master is larger

Re: On fighting with master-slave replication lag

I would suggest a Nagios monitoring system, useful for many different checks and with plugins to check also mysql replication. Aloha! Claudio Nanni 2008/12/23 xufeng > Hello everyone, > In my production system, I set up MySQL 5.0.67 master/slave replication, > and > recently I met with master/

On fighting with master-slave replication lag

Hello everyone, In my production system, I set up MySQL 5.0.67 master/slave replication, and recently I met with master/slave replication lag problem. Is there a good monitoring tool or some other tools to detect and discover this latency on slave? Any suggestion is welcomed. Thank you in advance.