MySQL Monitoring and Management like a Boss

pmm-logo

 

PMM (Percona Monitoring and Management) is one of the best way to keeping MySQL under the control.

Installation is super easy, I’m writing for Ubuntu but you can find more detail on installation page.

Setting up the server

a) Data Container

$ docker create \
   -v /opt/prometheus/data \
   -v /opt/consul-data \
   -v /var/lib/mysql \
   -v /var/lib/grafana \
   --name pmm-data \
   percona/pmm-server:1.0.7 /bin/true

b) Server Container

$ docker run -d \
   -p 80:80 \
   --volumes-from pmm-data \
   --name pmm-server \
   --restart always \
   percona/pmm-server:1.0.7

Installing Client

a) Setup

$ wget https://repo.percona.com/apt/percona-release_0.1-4.$(lsb_release -sc)_all.deb
$ sudo dpkg -i percona-release_0.1-4.$(lsb_release -sc)_all.deb
$ sudo apt-get update
$ sudo apt-get install pmm-client

b) Connecting to server

$ sudo pmm-admin config --server 192.168.100.1

c) Data Collection

 sudo pmm-admin add mysql

PMM comes with Grafana and Prometheus you can see really cool metrics 🙂

Thanks Percona for PMM 👍

Demo: https://pmmdemo.percona.com/

🐬

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s