Two weeks ago we released a walkthrough of managing Apache HTTP Server with System Center 2016 Technical Preview 2 Operations Manager . This week we continue with a walkthrough for managing MySQL Server with System Center 2016 TP2 Operations Manager. This walkthrough details a step by step guide for setting up and managing MySQL Server.
Here’s a quick look at the feature set for the MySQL Server management pack. A full list of available metrics can be found in the MySQL Server management pack guide in the Appendix section:
- Performance metrics for key cache, query cache, table cache, etc.
- Alerting on connections and query performance
- InnoDB buffer pool hit and usage statistics
- Information on disk space usage for the whole server and individual databases
Requirements for Open Source Software management pack monitoring can be found in the respective management pack guide at the linked download page above.
For this walkthrough my pre-existing environment consists of the following
MySQL Server monitoring consists of a MySQL OMI CIM Provider that uses the MySQL client libraries to retrieve statistics from the running MySQL Server. In order for the MySQL OMI CIM Provider to utilize the MySQL client libraries user credentials must be specified to authorize and facilitate the connection. A short architecture overview can be seen below.
To begin configuration of the MySQL Server monitoring user let’s login to the MySQL Server using the MySQL client. There are a variety of tools to access the MySQL Server. In this tutorial I use the mysql client included with the mysql-server distribution
GRANT SELECT ON mysql.* TO ‘scomuser’@’localhost’;
GRANT SELECT ON <INSERT DATABASE NAME>.* TO ‘scomuser’@’localhost’;
Managing the Ubuntu Server with System Center 2016 Technical Preview 2 Operations Manager
As mentioned in the Apache blog last week, the process for bringing a Linux server under management with this new version of Operations Manager remains largely unchanged. For a more detailed look on how to discover Linux servers with Operations Manager refer to the following blow post http://blogs.technet.com/b/kevinholman/archive/2012/03/18/deploying-unix-linux-agents-using-ops...
Like the Apache provider the MySQL provider is included in the new Linux agents for System Center 2016 TP2 Operations Manager. During the Linux agent installation if a supported version of MySQL Server is installed the Linux agent installs the MySQL Server agent.
If you would like to add MySQL management to an already managed Linux server refer to the instructions inside the MySQL management pack guide on the download page.
Now that we have the MySQL Server discovery completed in Operations Manager we have to configure the MySQL provider to use the MySQL Server monitoring user we created earlier. Thankfully, this can be done by distributing an authentication text file or running a management pack task. This guide uses the management pack tasks. Instructions for creating and distributing the authentication text file can be found in the management pack guide.
Congratulations!! You have successfully set up MySQL Server monitoring with System Center 2016 TP2 Operations Manager. After a couple minutes MySQL Server Databases and MySQL Server performance metrics begin to populate.
We appreciate any comments you may have about MySQL Server or Apache HTTP Server monitoring, and look forward to your feedback.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.