Hi All,
Is there anyway we can monitoring mysql master/slave database replication through Solarwinds?
Thanks
What method of replication are you using?
Hi,
We use the mysql master/slave replication model.
Thanks.
Sorry.....whem you say method.....what do you imply?
Shailesh
You had the right idea - master/slave replication is what I needed to know. So you're using 'show master status', 'show slave status', and the like to determine its health, right? I'd write a small script that does the following:
Thanks for the information. We have been using the APM to monitoirng linux servers for their avilabilty, cpu, disk space, memory etc and as well as for montoting different process like mysql, apache which does not require any sort of scripting. As of now we have not made you of any Linux/Unix Script Monitor. Infact, I did try once and it was asking for credentials....I did give my ssh credentails.....how it sid not work. Would really like to make it work.....not sure how. Can you please emplasize more on the Linux/Unix Script Monitor process.
I'm writing this from memory, so you'll have to forgive any inaccuracies, but when you create a new linux/unix script monitor there are 4 important fields: credentials, program to execute (or something like that - the default value is "perl ${SCRIPT} arg1 arg2"), path, and script (big empty text box).
So, an example:
Credentials
<enter your linux/unix credentials - this should be a user that has a shell on the remote system>
Program
/bin/sh ${SCRIPT}
Starting Path
This could really be anything, or you could leave it blank if you're not relying on a particular starting path. For sake of example, let's make it /tmp.
Script (Body?)
#!/bin/sh
# This is a sample APM script - it has only two requirements:
# 1. There must be a numeric statistic returned (even if it's 0 all the time).
# 2. There must be an exit value of 0, 1, or 2 (UP, WARNING, and DOWN, respectively).
# We could check anything, but let's just return the number of processes (could be 'ps -aux' or 'ps -ef' depending on linux/unix flavor):
num_processes=`ps -aux | wc -l`
echo "Statistic: $num_processes"
exit 0
# END SCRIPT
Give that a run on your remote system by testing your linux/unix node. You should get "AVAILABLE" and "UP" as your result (again, doing this from memory, but it should at least be green). Try changing the exit status to 1 and 2 and re-run the test. Try changing the statistic to something else.
Are there any plans to further develop this?
ipmonitor (which is ancient) has the functionality to select specific columns from returned query results, it could then determine the health of the monitor based on it matching against a regex.
It would make sense that the more advanced product (SAM) is should be able to handle an output of more than just one fields content.
Cheers
Tom
SAM has similar functionality using the ODBC User Experience Monitor in the case of MySQL. The returned value must however be in numeric format, which can be achieved by performing the string match as part of the query and returning a numeric value as the result to SAM.
This is the Component monitor that I am using. I need to monitor the replication state of the mysql db. I can do this using "show slave status"; however, "show slave status" does not support matching, it can only return a row of data (~25 columns).
In ipmonitor it is possible to retrieve that row and inspect just one column, is there some way that this functionality could be ported across to SAM?
