[Pdns-users] Using AXFR vs. Mysql Replication

[Tony Adams]

I too am interested in a method for monitoring the status of mysql
replication.  I've been very fortunate so far in that it seems to just
work, but I'd like to have a better system in place for the eventuality
that it won't.

Thanks

Tony Adams
Systems Engineer
E Solutions Corporation
> -----Original Message-----
> From: pdns-users-bounces at mailman.powerdns.com [mailto:pdns-users-
> bounces at mailman.powerdns.com] On Behalf Of Max Clark
> Sent: Saturday, June 24, 2006 2:43 PM
> To: pdns-users at mailman.powerdns.com
> Subject: Re: [Pdns-users] Using AXFR vs. Mysql Replication
> 
> Lukas,
> 
> I would be very interested in hearing more about your nagios
> configuration to monitor mysql and mysql replication. Anything you can
> provide would be a great help.
> 
> Thanks,
> Max
> 
> On 6/23/06, Lukas Beeler <lb-pdns-users at projectdream.org> wrote:
> > * Max Clark <max.clark at gmail.com>:
> > > issues with Mysql replication (and once because mysql went down
> > > causing the nameservers to go down, which caused name resolution
for
> > > client access to fail when we tried to bring the nameservers back
up -
> > > really stupid problem).
> >
> > MySQL has had a few issues with replication (i've got
> > an open bug report with the MySQL people), and we've started to
> > monitor replication much more closely, and also started
> > seperating MySQL Instances for various services.
> >
> > Are you using Nagios or a similar tool? MySQL replication can
> > break silently if you don't monitor it, which can cause major
> > headaches.
> >
> > If you don't want to rollout nagios or something similar, i'd
> > recommend you to use nagios check scripts, and run them in a
> > cronjob with a small wrapper around them which sends SMS.
> >
> > Personally, all the problems we had with MySQL happened because
> > we don't use a testbed environment for all changes.
> >
> > If you need any help with nagios, let me know, i'd be happy to
> > share my configuration and scripts (don't have time to publish
> > them all properly).
> > _______________________________________________
> > Pdns-users mailing list
> > Pdns-users at mailman.powerdns.com
> > http://mailman.powerdns.com/mailman/listinfo/pdns-users
> >
> 
> 
> --
> Max Clark
> http://www.clarksys.com
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> http://mailman.powerdns.com/mailman/listinfo/pdns-users