Senin, 10 Juni 2024

PSQL-monitoring percona

 We are pleased to announce our 7th Beta release of PMM 2! Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance. This release includes the following improvements:

  • Query Analytics
    • Filtering panel improvements – now hide unused labels
    • Query details section now shows the percentage of the total for all metrics
    • PostgreSQL table definition & indexes – now available on the Tables tab
    • Breadcrumb panel  – tracks your navigation history
  • PMM GUI and dashboards improvements
    • Rearranged dashboards and menu structure: simplified and streamlined menu with better hierarchy
    • New Services Compare dashboards for MySQL, MongoDB, and PostgreSQL
    • MongoDB Cluster Summary dashboard now splits metrics data according to related services
    • PostgreSQL Services Overview dashboard – splits metrics data according to related services
    • Other small refinements
  • Remote services monitoring – monitor MySQL, PostgreSQL, and MongoDB from PMM Server without the need for client installation
  • Authentication improvements – Secures the PMM Client ↔ PMM Server communications.

We’ve also updated our core software to:

PMM 2 is still a work in progress — you may encounter some bugs and missing features. We are aware of a number of issues, but please report any and all that you find to Percona’s JIRA.

This release is not recommended for production environments.  PMM 2 is designed to be used as a new installation — please don’t try to upgrade your existing PMM 1 environment.

Query Analytics Improvements

The filter panel now only shows labels that have meaningful select options. Compare the old layout (on the left) with the new one (on the right):

In cases where a field is blank but we know activity is occurring i.e. Client Host is not available from MySQL Performance Schema data source, we use n/a as a placeholder, and we don’t display the option (see example above – Client Host on left, not displayed on the right). In cases where actual values exist as well as n/a, we display all available options.

Also, the details section was also improved to display % from Total for every Metric of the selected query:

More detailed information about PostgreSQL queries

In addition to the details section which was implemented earlier, QAN now can display the Tables tab for the selected query. It enables you to get the table definition and indexes for each table referenced by the query:

Breadcrumb Panel

This new panel tracks all dashboards you have visited within one session starting from the root (which is either the Home dashboard or Services Overview dashboard) and displays them as a clickable breadcrumb:

Rearranged dashboards and menu structure

In this release, we introduce a restructured menu with a correspondent change in the dashboards’ taxonomy. Now dashboards belong to one of the following groups:

  • Overview Dashboard. This provides a general view of all objects for the selected type (MySQL, OS, MongoDB, etc.). Dashboards of this type provide an easy and fast way to see all available objects and to spot problems.
  • Summary Dashboard. This is used for a more detailed view of the object. It provides information about the single object and its main parameters.
  • Compare Dashboard. This allows you to compare parameters for the object. Objects of the same type are placed side-by-side to allow you to spot differences.
  • Details Dashboard. This contains a more detailed view of some components of the object, thus allowing you to get more in-depth information about the object components. Actually, Details Dashboards are Summary Dashboards for the next level of the hierarchy.

Along with this rearrangement, we have a new main menu. Below is the new look for its top-level:

Selecting a specific service (MySQL, MongoDB, PostgreSQL, etc.) will guide you to the next level of the hierarchy, where you can access Details Dashboards related to this Service, or a Service Compare Dashboard:

Services Compare dashboards

As already noted, we have introduced Services Compare Dashboards for all of the services supported by PMM, with the “Compare” menu item available when a specific service is selected.

The following image shows the dashboard which allows you to compare available PostgreSQL Services:

Services details in MongoDB Cluster Summary dashboard

MongoDB Cluster Summary dashboard has got an update, showing metrics data split by services they are related to in addition to the total metrics data:

Services details in PostgreSQL Services Overview dashboard

PostgreSQL Services Overview dashboard has got an update, showing metrics data split by services they are related to in addition to the total metrics data:

Other dashboard improvements

Several small dashboard improvements were made in this release. The following two improvements are the most noticeable.

The System Overview Dashboard has obtained two new elements describing available service types and database service connections:

The ProxySQL Overview Dashboard now contains a chart with information about client connections:

We’re also incrementally improving our Dashboards with the addition of Tooltips. This release we’ve updated the InnoDB Compression dashboard.

Remote services monitoring

Beginning with Beta 7’s release, PMM can monitor remote database instances without installing any local agents. Note that node resource information will be missing (no CPU/Network/Disk/Memory) since these metrics are only available when a local agent is installed.

Grafana authentication

Grafana now handles authentication between PMM Server and PMM Client.  In particular, PMM Client should be configured to connect to a PMM Server with the admin default user credentials as follows (note the --server-url string change):

Updates widget

The current version and the available update can be seen on the Updates panel on the Home dashboard:

Installation and configuration

Install PMM Server with docker

The easiest way to install PMM Server is to deploy it with Docker. Running the PMM 2 Docker container with PMM Server can be done by the following commands (note the version tag of 2.0.0-beta7):

Now you can check the newly installed PMM Server in your browser, going to your server by its IP address. PMM Server provides user access control, and therefore you will need user credentials to access it:

The default PMM Server credentials are:

username: admin
password: admin

You will be prompted to change the admin password after logging in.

Install PMM Client

Since PMM 2 is still not GA, you’ll need to leverage our experimental release of the Percona repository. You’ll need to download and install the official percona-release package from Percona and use it to enable the Percona experimental component of the original repository. See percona-release official documentation for further details on this new tool.

Specific instructions for a Debian system are as follows:

Now enable the experimental repo:

Install pmm2-client package:

Users who have previously installed pmm2-client alpha version should remove the package and install a new one in order to update to beta1.

Please note that leaving experimental repository enabled may affect further package installation operations with bleeding-edge software that may not be suitable for Production. You can revert by disabling experimental via the following commands:

Configure Percona Monitoring and Management

Once PMM Client is installed, run the pmm-admin config command with your PMM Server IP address to register your Node:

Note that you need to pass the authentication string as part of the --server-url. We’ll be fixing this in a later release when instead we’ll accept as separate parameters. These credentials are the same ones you have used to login to PMM Server, so pass the default password or the new one if you have changed it in the login screen.

You should see the following:

Adding MySQL Metrics and Query Analytics

MySQL server can be added for monitoring in its normal way. Here is a command which adds it using the PERFORMANCE_SCHEMA source:

where username and password are credentials for the monitored MySQL access, which will be used locally on the database host.

The syntax to add MySQL services (Metrics and Query Analytics) using the Slow Log source is the following:

When the server is added, you can check your MySQL dashboards and Query Analytics in order to view its performance information!

Adding MongoDB Metrics and Query Analytics

You can add MongoDB services (Metrics and Query Analytics) with a similar command:

Adding PostgreSQL Metrics and Query Analytics

You can add PostgreSQL service as follows:

You can then check your PostgreSQL Overview dashboard.

Add ProxySQL monitoring service

You can add ProxySQL service as follows:

You can then check your ProxySQL Overview dashboard.

About Percona Monitoring and Management

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL®, MongoDB®, and PostgreSQL® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL, MongoDB, and PostgreSQL servers to ensure that your data works as efficiently as possible.

Help us improve our software quality by reporting any Percona Monitoring and Management bugs you encounter using our bug tracking system.

Diposting oleh di

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)