Percona Monitoring & Management

by v1 | Ubuntu 20.04, Debian 10

Open source monitoring platform to gain deep insight into the performance of applications and databases.

Percona Monitoring and Management is a free, best-of-breed, open source database monitoring and management solution. It helps enterprises reduce complexity and simplify management, while optimizing performance and improving the security of your business-critical database environments, no matter where they are located, including on-premises or in the cloud.

Gain more insight in seconds by deploying the Percona Monitoring and Management One-Click App on Linode.

Software Included

The PMM One-Click App will install the following required software on your Linode:

SOFTWAREDESCRIPTION
DockerDocker is used to containerize Percona PMM.
GrafanaGrafana is a visualization tool that provides charts, graphs, and alerts. Provides these tools for Percona PMM
pmm-adminpmm-admin is a command-line tool used to managing PMM clients.

Getting Started After Deployment

Access Your PMM Server’s Grafana Dashboard

After the Percona PMM server has finished installing, you will be able to access its Grafana dashboard it over http:// with your Linode’s IPv4 address. To find your Linode’s IPv4 address:

  1. Click on the Linodes link in the sidebar. You will see a list of all your Linodes.
  2. Find the Linode you just created when deploying your app and select it.
  3. Navigate to the Networking tab.
  4. Your IPv4 address will be listed under the Address column in the IPv4 table.
  5. Copy and paste the IPv4 address into a browser window. Ensure you are using http://.
  6. You will see the PMM Home Dashboard actively monitoring your server:

Installing the PMM Client

To begin monitoring a database node, you will need to install the PMM Client on the Linode that hosts your database and connect the node to the PMM Server.

  1. Connect to your Linode via SSH.
  2. Update your system’s software.

    Debian or Ubuntu
    sudo apt-get update && apt-get upgrade

    CentOS
    sudo apt-get update && apt-get upgrade
  3. Install the PMM Client (version 1):

    Debian or Ubuntu
    sudo apt-get install pmm-client

    CentOS
    sudo yum install pmm-client
  4. Connect your database node to the PMM Server. Replace 192.0.2.0 with your PMM Server’s IPv4 address.

    sudo pmm-admin config --server 192.0.2.0

    Once complete, you should see a similar output:

    OK, PMM server is alive.

    PMM Server | 192.0.2.0
    Client Name | li222-111
    Client Address | 192.0.2.1

Monitor a Database Instance

Once your database node and your PMM Server are communicating, the final step is to add your database instance to be monitored by your PMM Server. These steps are completed on your Database node.

  1. Connect to your Linode via SSH.
  2. Add your database instance to be monitored by your PMM Server. This command will add a MySQL database instance to be monitored. You can replace mysql with the database type that your node is hosting (i.e. postgresql or mongodb). See Percona’s Managing PMM Client documentation for details.

    pmm-admin add mysql

    Your Percona dashboard should now be monitoring your MySQL service. To learn how to monitor a different database service, see Percona’s official documentation.