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