Hi,
Well what I want I really can't find so I am writing one write now in
Perl and this is what I am going to have it do.
1. Check each database to see if it's configured correctly in "/etc/my.conf"
2. Do a diff on MySQL dumps of the master and slave databases.
There are a few more steps I am going to add, but it is specifically for
the type of setup I have here.
I know most of this stuff I can check by hand, but as more databases are
created and other work gets in the way
it can get kind of hard to keep of with everything manually.
So thank you very much for your help, I am also going to give that
script a try that you showed me.
Kishore Jalleda wrote:
> Ok when you say you replicating properly I assume you mean
> 1) is the replication running
> 2) and how behind it is from the master
> both of which you monitor with nagios, but this does not tell you
> which table/database is behind
>
> Now the only other thing I cant think of when you want to make sure
> your individual databases
> are in SYNC between master and slave is to check row counts on the
> individual tables on the DBs, and you can easily write a perl script
> and integrate that in nagios ... ( Try:
> http://kjalleda.googlepages.com/mysqlreplicationconsistency)
>
> This would not however tell you how far behind the slave is in terms
> of time, but would give you a rough idea of what you are looking for ...
>
> Anyway i was just wondering why you would want this kind of a
> monitoring tool?
>
> Kishore Jalleda
>
