Skip to main content

Posts

Setting up MySQL Monitoring with Prometheus

One thing that I love about Prometheus is that it has a 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, which exposed a large number of metrics for monitoring but not in Prometheus format. For capturing that data in Prometheus format we use mysqld_exporter.

I am assuming that you have already setup MySQL Server.
Configuration changes in MySQL 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 for new service.
CREATEUSER 'mysqld_exporter'@'localhost' IDENTIFIED BY 'password' WITH MAX_USER_CONNECTIONS 3;
After creating a user we simply have to provide permission…

Gitlab-CI with Nexus

Recently I was asked to set up a CI- Pipeline for a Spring based application.
I said "piece of cake", as I have already worked on jenkins pipeline, and knew about maven so that won't be a problem. But there was a hitch, "pipeline of Gitlab CI". I said "no problem, I'll learn about it" with a Ninja Spirit.
So for starters what is gitlab-ci pipeline. For those who have already work on Jenkins and maven, they know about the CI workflow of  Building a code , testing the code, packaging, and deploy it using maven. You can add other goals too, depending upon the requirement.
The CI process in GitLab CI is defined within a file in the code repository itself using a YAML configuration syntax.
The work is then dispatched to machines called runners, which are easy to set up and can be provisioned on many different operating systems. When configuring runners, you can choose between different executors like Docker, shell, VirtualBox, or Kubernetes to determi…

Ansible Variables and Variables Precedence

Ansible Variables and Variables Precedence
What is a variable?
A variable is reference to data stored in a computer program.
How to define variable in Ansible?
Variables Defined in Inventory
Variables can be defined in inventory in two ways - 1. Host variables [web]
host1 http_port=80
host2 http_port=443
2. Group variables [web]
host1
host2

[web:vars]
http_port=80
proxy=proxy.example.com
Variables Defined in a Playbook
You can directly define variables in a playbook: - hosts: appgroup
 vars: