{"id":238,"date":"2018-12-11T14:09:00","date_gmt":"2018-12-11T14:09:00","guid":{"rendered":""},"modified":"2025-11-24T15:58:05","modified_gmt":"2025-11-24T10:28:05","slug":"setting-up-mysql-monitoring-with-prometheus","status":"publish","type":"post","link":"https:\/\/opstree.com\/blog\/2018\/12\/11\/setting-up-mysql-monitoring-with-prometheus\/","title":{"rendered":"Setting up MySQL Monitoring with Prometheus"},"content":{"rendered":"
One thing that I love about Prometheus is that it has\u00a0a multitude of Integration with different services, both officially supported and the third party supported.
\nLet’s see how can we monitor MySQL with Prometheus.Those who are the starter or new to Prometheus can refer to our this blog.MySQL is a popular opensource relational database system, which exposed a large number of metrics for monitoring but not in Prometheus format. For capturing that data in Prometheus format we use\u00a0mysqld_exporter<\/a>.<\/b>
\n
\n<\/b> I am assuming that you have already setup MySQL Server.<\/p>\n

Configuration changes in MySQL<\/h3>\n
For setting up MySQL monitoring, we need a user with reading access on all databases which we can achieve by an existing user also but the good practice is that we should always create a new user in the database\u00a0for new service.<\/div>\n
<\/div>\n
\n
CREATE<\/span> USER<\/span> 'mysqld_exporter<\/span>'@'<\/span>localhost'<\/span><\/span> IDENTIFIED BY 'password<\/span>'<\/span><\/span> WITH MAX_USER_CONNECTIONS 3<\/span>;<\/pre>\n<\/div>\n
<\/div>\n
After\u00a0creating a user we simply have to provide permission to that user.<\/div>\n
\n
GRANT<\/span> PROCESS, REPLICATION CLIENT, SELECT<\/span> ON<\/span> *<\/span>.*<\/span> TO '<\/span>mysqld_exporter'<\/span><\/span>@'<\/span>localhost'<\/span><\/span>;<\/pre>\n<\/div>\n
<\/div>\n
Setting up MySQL Exporter<\/h3>\n
Download the\u00a0mysqld_exporter<\/a>\u00a0<\/b>from GitHub. We are downloading the 0.11.0 version as per latest release now, change the version in future if you want to download the latest version.<\/div>\n
\u00a0<\/b><\/div>\n
\n
wget <\/span>https:\/\/github.com\/prometheus\/mysqld_exporter\/releases\/download\/v0.11.0\/mysqld_exporter-0.11.0.linux-amd64.tar.gz<\/pre>\n<\/div>\n
\u00a0<\/b><\/div>\n
Then simply extract the tar file and move the binary file at the appropriate location.<\/div>\n
\n
tar -xvf <\/span>mysqld_exporter-0.11.0.linux-amd64.tar.gz<\/pre>\n<\/div>\n
<\/div>\n
\n
mv <\/span>mysqld_exporter \/usr\/bin\/<\/pre>\n<\/div>\n
<\/div>\n
\n
Although we can execute the binary simply,\u00a0but the best practice is to create service for every Third Party binary application. Also, we are assuming that systemd\u00a0<\/b>is already installed in your system. If you are using init then you have to create init service for the exporter.<\/p>\n<\/div>\n
\n
useradd <\/span>mysqld_exporter\r\nvim<\/span> \/etc\/systemd\/system\/mysqld_exporter.service<\/span><\/pre>\n<\/div>\n
<\/div>\n
\n
[Unit]<\/span>\r\nDescription=MySQL Exporter Service\r\nWants=network.target\r\nAfter=network.target\r\n\r\n<\/span>[Service]<\/span>\r\n<\/span>User=mysqld_exporter\r\nGroup=mysqld_exporter\r\nEnvironment=\"DATA_SOURCE_NAME=mysqld_exporter:password@unix(\/var\/run\/mysqd\/mysqld.sock)\"\r\nType=simple\r\nExecStart=\/usr\/bin\/mysqld_exporter\r\nRestart=always<\/span>\r\n\r\n[Install]\r\nWantedBy=multi-user.target\r\n<\/pre>\n<\/div>\n
<\/div>\n
You may need to adjust the socket location of Unix according to your environment<\/div>\n
<\/div>\n
If you go and visit the http:\/\/localhost.com:9104\/metrics<\/a>, you will be able to see them.<\/div>\n
<\/div>\n
Prometheus Configurations<\/h3>\n
For scrapping metrics from mysqld_exporter in Prometheus we have to make some configuration changes in Prometheus, the changes are not fancy, we just have to add another job for mysqld_exporter, like this:-<\/div>\n
<\/div>\n
<\/div>\n
\n
vim <\/span>\/etc\/prometheus\/prometheus.yml<\/pre>\n<\/div>\n
<\/div>\n
\n
  - job_name: 'mysqld_exporter'\r\n    static_configs:\r\n      - targets:\r\n          - :9104<\/span><\/pre>\n<\/div>\n
<\/div>\n
\n
After the configuration changes, we just have to restart the Prometheus server.<\/p>\n
systemctl restart prometheus<\/span><\/pre>\n
Then, if you go to the Prometheus server you can find the MySQL\u00a0metrics there like this:-<\/p>\n
<\/a><\/div>\n<\/div>\n
So In this blog, we have covered MySQL configuration changes for Prometheus, mysqld_exporter setup and Prometheus configuration changes.<\/div>\n
In the next part, we will discuss how to create a visually impressive dashboard in Grafana for better visualization of MySQL metrics. See you soon… \ud83d\ude42<\/div>\n
<\/div>\n
<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
One thing that I love about Prometheus is that it has\u00a0a multitude of Integration with different services, both officially supported and the third party supported. Let’s see how can we monitor MySQL with Prometheus.Those who are the starter or new to Prometheus can refer to our this blog.MySQL is a popular opensource relational database system, … Continue reading “Setting up MySQL Monitoring with Prometheus”<\/span><\/a><\/p>\n","protected":false},"author":89038429,"featured_media":29900,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[1],"tags":[723407,768739293,768739289,768739287],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/11\/DevSecOps-1.jpg","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pfDBOm-3Q","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts\/238"}],"collection":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/users\/89038429"}],"replies":[{"embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/comments?post=238"}],"version-history":[{"count":5,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts\/238\/revisions"}],"predecessor-version":[{"id":30052,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts\/238\/revisions\/30052"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/media\/29900"}],"wp:attachment":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/media?parent=238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/categories?post=238"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/tags?post=238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}