Monitoring MySQL with SCOM 2019

Sajid Ansari 1 Reputation point
2020-08-19T10:04:12.733+00:00

We got a requirement from DB team to monitor their MySQL server & DB with below metrics:
The version of mysql is 8.0.20 running on CentOS 8. I could only find a management pack "System Center Management Packs for Open Source Software"( https://www.microsoft.com/en-us/download/details.aspx?id=46924 ). It is for SCOM 2016 & 1801 while we are using SCOM 2019. Also, as per the MP guide, it only supports upto mysql 5.7 while we are using 8.0.
Please let me know if there is any way or any management pack to monitor below metrics. I want a step by step guide if possible.

Metrics
CPU Utilization
File System / Disk Utilization
Load Average
Active Database Sessions
mysqld process status
Database connection
Slave Status
Master Status
Replication "Seconds_Behind_Master"
Index vs
Number of active connections to database
Throughput: row-based throughput of selects, inserts, updates, and deletes
Latency: latency of fetches, inserts, updates, and deletes

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,413 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. SChalakov 10,261 Reputation points MVP
    2020-08-19T11:49:48.413+00:00

    Hi,
    sorry for disappointing you, but there isn't currently a MP, which can cover MySQL v8. The challenge with the MP you already referenced is not the SCOM version as it can be imported in SCOM 2019 also, but actually the MySQL version support.
    From what I know there is also no 3rd party management pack for MySQL.
    This leaves you with two options:

    1. Author your own Management Pack and cover the above listed requirements.
    2. Give it to a person or a company that will do this for you. I know that Nice are doing this:

    Custom SCOM Management Packs

    Hope i could help you.

    (If the reply was helpful please don't forget to accept as answer, thank you)

    Regards,
    Stoyan

    0 comments