nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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
Store

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?

Shailesh1

Hi,

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.

Thanks.