Percona

DECEMBER 20, 2023

In this blog post, we will go through the process of InnoDB buffer pool resizing online, covering why it is important to monitor its progress and how to monitor it. Importance of monitoring the InnoDB buffer pool resize Since MySQL 5.7.5, This status variable reports a string value indicating buffer pool resizing progress.

Monitoring 86

Monitoring Code Open Source Cache 86

Percona

FEBRUARY 27, 2023

Today’s post includes those releases and updates that have come out since February 13, 2023. Percona Monitoring and Management 2.35 Percona Monitoring and Management 2.35 (PMM) was released on February 24, 2023. Download Percona Monitoring and Management 2.35 was released on February 15, 2023.

Monitoring 69

Monitoring Open Source Database Software 69

Percona

OCTOBER 2, 2023

Today’s post includes those releases and updates that have come out since September 18, 2023. was released on September 26, 2023. It is the most stable, scalable, and secure open source MySQL distribution, with two download options: one based on Percona Server for MySQL and one based on Percona XtraDB Cluster. Take a look.

Open Source 79

Open Source Scalability Database Servers 79

Percona

DECEMBER 4, 2023

Today’s post includes those releases and updates that have come out since November 13, 2023. On November 27, 2023, Percona Distribution for MySQL (PS- based variant) 8.1.0 It is the most stable, scalable, and secure open source MySQL distribution based on Percona Server for MySQL. Percona Server for MySQL 8.1.0-1

Open Source 79

Open Source Azure Servers Programming 79

Percona

AUGUST 7, 2023

Today’s post includes those releases and updates that have come out since July 24, 2023. On August 2, 2023, we released Percona Distribution for MySQL (PXC-based variant) 8.0.33. Update to the release of Percona Server for MySQL 8.0.33-25 25 An update to the release of Percona Server for MySQL 8.0.33-25 Take a look.

Open Source 84

Open Source Scalability Servers Database 84

Percona

JANUARY 2, 2024

Managing database servers involves different aspects, among which security is critical. However, we know having a “runaway” grant is always a possibility, especially in environments with a large number of servers. Fortunately, in Percona Server for MySQL , this feature is free to use. How does it work?

Servers 83

Servers Database Open Source Scalability 83

Dynatrace

MARCH 18, 2024

Yet, in 2023, 82% of cloud decision makers reported that managing cloud spend was their top challenge, according to one source. Empowering teams to manage their FinOps practices, however, requires teams to have access to reliable multicloud monitoring and analysis data. In response, many organizations are adopting a FinOps strategy.

Best Practices 225

Best Practices Strategy Cloud AWS 225

Percona

AUGUST 4, 2023

Percona has bundled together some great open source pieces of software to create Percona Monitoring and Management (PMM), a very flexible and powerful monitoring solution. sec) Grafana data source Now that we have the power production data in MySQL, we need to configure Grafana to access the MySQL server.

Monitoring 75

Monitoring Open Source Database Metrics 75

Percona

JULY 24, 2023

Today’s post includes those releases and updates that have come out since July 10, 2023. Percona Monitoring and Management 2.38.1 Percona Monitoring and Management 2.38.1 (PMM) PMM) was released on July 13, 2023. Download Percona Monitoring and Management 2.38.1 was released on July 19, 2023.

Open Source 72

Open Source Scalability Database Monitoring 72

Percona

APRIL 6, 2023

In this blog post, we’ll check how to integrate Percona Monitoring and Management (PMM) with Loki to be able to get not only metrics and queries from our database servers but also text-based information like logs. Promtail will be in charge of reading the log files and sending new information to the Loki server.

Monitoring 85

Monitoring Servers Metrics Database 85

Percona

JUNE 15, 2023

Sometimes we might need to install/upgrade Percona Server for MySQL /MySQL 8 to a particular version in a test or production environment. Install Percona Server for MySQL 8 specific version packages via repository. Download specific Percona Server for MySQL 8 tarball packages and install them manually. bullseye amd64 1.7

Servers 83

Servers C++ Database Systems 83

Percona

MARCH 1, 2023

has had a good, long run, but the official End of Life is October of 2023. EXPLAIN without the ANALYSE gives you the server’s estimated analysis of the performance of your query. But before going with the MySQL Community Edition, you should look at Percona Server for MySQL. Why Percona Server for MySQL?

Servers 117

Servers Open Source Tuning C++ 117

Percona

APRIL 17, 2023

Still, as DBA, you want to use Percona Monitoring and Management (PMM) for better database insights and maintain a common policy of Datadog as a standard alerting or high-level observability tool. Percona Monitoring and Management is not intended to replace Datadog; rather, they work better together. openmetrics.d/conf.yaml

Monitoring 70

Monitoring Metrics Database Open Source 70

Official Blog - World Web Technology

DECEMBER 1, 2023

Considering our audience’s interest, this post examines the best software for a web design Services Company in 2023. In 2023, web designers will need tools that are both highly effective and simple to use, with the ability to both speed up the design process and foster more creative freedom. Web Design Solutions Made Easy!

Design 59

Design Software Software Website 59

CSS Wizardry

JUNE 30, 2023

I’m willing to bet you still monitor TTFB , even though you know your customers will have no concept of a first byte whatsoever. TTFB is a good measure of your server response times and general back-end health, and issues here may have knock-on effects later down the line (namely with Largest Contentful Paint). View unabridged.

Metrics 326

Metrics Google Monitoring Analytics 326

Percona

SEPTEMBER 15, 2023

At Percona Managed Services , we manage Percona Server for MySQL , Community MySQL, and MariaDB. In my lab, we have two test nodes; both servers will have Debian 11 and MariaDB10.5.19 In my lab, we have two test nodes; both servers will have Debian 11 and MariaDB10.5.19 mariadb.list.old_1 # [info] MariaDB Server version 10.5.19

Servers 100

Servers C++ Processing Testing 100

Percona

MAY 16, 2023

The connection control plugin library allows administrators to introduce an increasing delay in the server response to connections after a designated number of consecutive unsuccessful login attempts. The idea behind using a connection control plugin is to configure a MySQL server so that the server will delay its response.

Servers 118

Servers Database Monitoring Testing 118

Percona

DECEMBER 22, 2023

was released on December 21, 2023. This partially happened, and we are testing Percona Toolkit with Percona Server for MySQL 5.7 2023-12-21T15:29:22 Creating triggers. 2023-12-21T15:29:22 Created triggers OK. 2023-12-21T15:29:22 Copying approximately 1 rows. 2023-12-21T15:29:22 Copied rows OK. _t1_new` OK.

Operating System 95

Operating System Programming Open Source Testing 95

Dynatrace

SEPTEMBER 8, 2023

Dataflow overview Dynatrace ActiveGate extensions allow you to extend Dynatrace monitoring to any remote technology that exposes an interface. Dynatrace users typically use extensions to pull technical monitoring data, such as device metrics, into Dynatrace. Upload the ZIP file. Once uploaded, extract the ZIP file at the same location.

Database 264

Database Artificial Intelligence Metrics Monitoring 264

Percona

JUNE 5, 2023

On May 30, Percona was notified of a possible vulnerability in Percona Monitoring and Management (PMM). with a fix for CVE-2023-34409 that addresses the PMM authentication bypass vulnerability. After researching the report, we agreed with the reporter and began working on a fix to address the issue.

Internet 88

Internet Internet C++ Virtualization 88

Percona

MARCH 3, 2023

Hello friends, at Percona Managed Services, we usually do different types of things every day, including routine tasks, monitoring, and, very frequently, answering questions that are not always easy to answer. Check the database’s topology, whether one or more servers were replicating, if it was a Percona XtraDB Cluster , etc.

Testing 98

Testing Database Servers Open Source 98

Dynatrace

MAY 31, 2023

The practice uses continuous monitoring and high levels of automation in close collaboration with agile development teams to ensure applications are highly available and perform without friction. Identify KPIs Next, create a list of the key performance indicators (KPIs) that are important to the business.

Best Practices 216

Best Practices DevOps Latency Metrics 216

Percona

SEPTEMBER 19, 2023

PostgreSQL Community released PostgreSQL 16 on September 14, 2023. To highlight some: Logical replication from standby servers is now supported natively by PostgreSQL. view providing I/O statistics for your monitoring needs, New SQL/JSON constructors and identity functions.

Availability 108

Availability Open Source Database Servers 108

Percona

OCTOBER 31, 2023

Back in 2020, we set out to learn more about how Percona Monitoring and Management (PMM) was being used in order to provide a better product to the community. which is scheduled for EOL by the end of October 2023. One such feature was managed backups. We poured their feedback into the product, and as we iterated, adoption took off!

Open Source 88

Open Source Database Operating System Programming 88

Dynatrace

JUNE 15, 2023

It also entails secure development practices, security monitoring and logging, compliance and governance, and incident response. Cloud application security practices enable organizations to follow secure coding practices, monitor and log activities for detection and response, comply with regulations, and develop incident response plans.

Cloud 171

Cloud Open Source Architecture Monitoring 171

HammerDB

MARCH 25, 2023

Copyright (C) 2003-2023 Steve Shaw Type "help" for a list of commands Initialized SQLite on-disk database /home/steve/HammerDB-4.7/TMP/hammer.DB Copyright (C) 2003-2023 Steve Shaw Type "help" for a list of commands Initialized SQLite on-disk database /home/steve/HammerDB-4.7/TMP/hammer.DB Copy Code Copied Use a different Browser $./scripts/tcl/maria/tprocc/maria_tprocc.sh

C++ 83

C++ Virtualization Benchmarking Database 83

Percona

OCTOBER 10, 2023

[mysql@percona-client /]$ mysql -h minimal-cluster-pxc -u root -p Enter password: Welcome to the MySQL monitor. Your MySQL connection id is 256 Server version: 8.0.32-24.2 Copyright (c) 2009-2023 Percona LLC and/or its affiliates Copyright (c) 2000, 2023, Oracle and/or its affiliates. 2023-07-26T12:22:43 Swapping tables.

Database 94

Database Performance C++ Engineering 94

Percona

AUGUST 18, 2023

2023-05-12T08:10:38.946611Z 1 [ERROR] [MY-013894] [InnoDB] Found redo log file./ib_logfile0 2023-05-12T08:10:38.946683Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2023-05-12T08:10:39.374389Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine. to MySQL 8.x

Open Source 66

Open Source Database Storage Engineering 66

Percona

DECEMBER 19, 2022

We are excited to announce the latest release of Percona Monitoring and Management (PMM) – V2.33. include: Offline metric collection during PMM server outages or loss of PMM client-server network connectivity. Stage two (will be rolled out in 2023). Stage three (will be rolled out in 2023).

Metrics 52

Metrics Monitoring Servers Open Source 52

Dynatrace

MAY 17, 2023

When software runs in a monolithic stack on on-site servers, observability is manageable enough. Traditionally, organizations have relied solely on logging to monitor how applications perform, and that – generally – works fine in many cases. Register now!

Metrics 174

Metrics Open Source Traffic Cache 174

Percona

AUGUST 17, 2023

In another survey, using multiple metrics for overall popularity, PostgreSQL ranks as the fourth most popular database management system ( DB-Engines, March 2023 ). Craig Kerstiens, crunchydata, August 2023 ) That evolution has created lots of reasons for its expanding popularity. Free from vendor lock-in.

Open Source 78

Open Source Healthcare Social Media Database 78

Percona

JUNE 28, 2023

2023-06-22T08:23:29.003334Z 0 [ERROR] [MY-000000] [Galera] gcs/src/gcs_group.cpp:group_post_state_exchange():433: Reversing history: 171 -> 44, this member has applied 127 more events than the primary component.Data loss is possible. sandbox server started At this point, notice that from node1, you have: $./sandboxes/pxc_msb_8_0_31/node1/use

C++ 76

C++ Open Source Servers Monitoring 76

Percona

DECEMBER 18, 2023

Today’s post includes those releases and updates that have come out since December 4, 2023. Percona Monitoring and Management 2.41.0 Percona Monitoring and Management 2.41.0 was released on December 12, 2023. Initially a standalone client for PMM Server, PMM Dump is now accessible in the PMM user interface.

Monitoring 86

Monitoring Open Source Servers Scalability 86

Percona

FEBRUARY 24, 2023

To achieve this in a secure and efficient manner, a key requirement for any database monitoring and management software is to have robust access management features. Monitored data may contain sensitive data that needs to be protected, and label-based access control can be used to ensure that only authorized individuals can access that data.

Metrics 106

Metrics Monitoring Database Engineering 106

Dynatrace

AUGUST 9, 2023

Likewise, operation specialists can prioritize their efforts on monitoring the highest-risk tactics, and executives can better communicate the business risk. First, Dynatrace OneAgent  will automatically monitor and trace our infrastructure and communicate with Dynatrace. For instructions, see Set up Dynatrace on Kubernetes/OpenShift.

Analytics 189

Analytics AWS Strategy Infrastructure 189

Percona

OCTOBER 4, 2023

was released on October 3, 2023. If you use -- recursion - method = dsn , you need to update the DSN table manually, so the tool re-reads it and updates the list of replicas it monitors. Percona Toolkit 3.5.5 This blog post covers the main changes in this release. Download Percona Toolkit

Open Source 99

Open Source Code Testing Systems 99

Percona

OCTOBER 16, 2023

Today’s post includes those releases and updates that have come out since October 2, 2023. Percona Monitoring and Management 2.40.0 On October 5, 2023, Percona Monitoring and Management 2.40.0 It is an open source database observability, monitoring, and management tool for MySQL, PostgreSQL, and MongoDB.

Servers 75

Servers Monitoring Open Source Scalability 75