Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

MYSQL Replication Monitoring

Shailesh1

Hi All,

Is there anyway we can monitoring mysql master/slave database replication through Solarwinds?

Thanks

Find more posts tagged with

Accepted answers

All comments

mrxinu

What method of replication are you using?

Shailesh1

Hi,

We use the mysql master/slave replication model.

Thanks.

Shailesh1

Sorry.....whem you say method.....what do you imply?

Shailesh

mrxinu

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:

Connect to the master database.
Run the 'show' commands.
Determine its health based on the resulting information.
Return a pass/fail in the form of an exit code (0 = up, 1 = warning, 2 = down).
Use that script in the APM component called "Linux/Unix Script Monitor".

Have you set up any of these APM templates with the Linux/Unix Script Monitor yet?