MySQL 5 Replikation

C. Bensend benny at bennyvision.com
Tue May 4 16:22:52 CEST 2010


> I have to set up a Master/Slave Replication in mySQL 5. Before i do this
> i want to have tools watching this replication. Unfortunately i haven´t
> found a Nagios plugin, which is checking more than something like the
> time the slave is behind.
> Is there something to check all data between the Nodes or do you trust
> the replication without checking it?

In a previous life, I monitored some 60 or so remote sites, each
one with a replicating master-slave pair of MySQL 4.x servers.
The base check_mysql (with the "-S" switch) monitored the replication
just fine for us, including the amount of time a slave was behind,
if the slave thread was running properly, and a number of other
details.  It never missed any replication failures, and trust me,
MySQL replication failed all the freakin' time.

Benny


-- 
Me:  'How big a monster can you take out with one of those? Would
      you win a fight with Godzilla?'
Jim: 'You could disassemble Godzilla at a range of seven miles.'
                           -- Blog entry about the 76mm Melera, a
                              gun on a US Navy Perry-class frigate
                              that Somali pirates tried to seize



------------------------------------------------------------------------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null





More information about the Users mailing list