Percona

NOVEMBER 13, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. came out on November 2, 2023. was released on November 1, 2023. Take a look.

Innovation 83

Innovation Open Source Scalability Database 83

Percona

AUGUST 21, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona Monitoring and Management 2.39.0 Percona Monitoring and Management 2.39.0

Open Source 81

Open Source AWS Servers Database 81

Percona

OCTOBER 2, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. was released on September 26, 2023. Percona Server for MySQL 8.0.34-26

Open Source 78

Open Source Scalability Database Servers 78

Percona

DECEMBER 6, 2023

In this post, I will present a new Percona tool: Percona Monitoring and Management (PMM) Dump. The PMM Dump performs a logical backup of the performance metrics collected by the PMM Server and imports them into a different PMM Server instance. First General Availability version of PMM Dump was released on November 22, 2023.

Monitoring 93

Monitoring Metrics Analytics Open Source 93

Percona

DECEMBER 4, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. On November 27, 2023, Percona Distribution for MySQL (PS- based variant) 8.1.0

Open Source 77

Open Source Azure Servers Programming 77

Percona

AUGUST 7, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. On August 2, 2023, we released Percona Distribution for MySQL (PXC-based variant) 8.0.33.

Open Source 83

Open Source Scalability Servers Database 83

Percona

FEBRUARY 27, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Today’s post includes those releases and updates that have come out since February 13, 2023. Take a look! was released.

Monitoring 68

Monitoring Open Source Database Software 68

Percona

JUNE 12, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona Monitoring and Management 2.37.1 was released on June 5, 2023.

Open Source 81

Open Source Servers Database Scalability 81

Percona

FEBRUARY 13, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Today’s post includes those releases and updates that have come out since January 30, 2023. was released on February 9, 2023.

Open Source 81

Open Source Database Servers Scalability 81

Percona

MARCH 27, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Today’s post includes those releases and updates that have come out since March 13, 2023. was released on March 23, 2023.

Open Source 76

Open Source Servers Scalability Cache 76

Percona

SEPTEMBER 18, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. was released on September 14, 2023. was released on September 11, 2023.

Open Source 77

Open Source Servers Database Scalability 77

Percona

JULY 24, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona Monitoring and Management 2.38.1 Percona Monitoring and Management 2.38.1 (PMM)

Open Source 71

Open Source Scalability Database Monitoring 71

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 74

Monitoring Open Source Database Metrics 74

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 84

Monitoring Code Open Source Cache 84

Percona

MAY 29, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Today’s post includes those releases and updates that have come out since May 8, 2023.

Open Source 75

Open Source Servers Scalability Database 75

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 81

Servers Database Open Source Scalability 81

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 115

Servers Open Source Tuning C++ 115

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 182

Cloud Open Source Architecture Monitoring 182

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 84

Monitoring Servers Metrics Database 84

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 82

Servers C++ Database Systems 82

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 69

Monitoring Metrics Database Open Source 69

Percona

FEBRUARY 2, 2023

Additionally, it is best practice to monitor regularly and audit database authentication logs to detect and prevent unauthorized access attempts. PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server. Now it’s time to discuss external authentication methods.

Database 121

Database Servers Testing Programming 121

Percona

SEPTEMBER 25, 2023

PostgreSQL is a powerful and popular open source relational database management system. repo1-host-user=postgres [demo] pg1-path=/var/lib/postgresql/14/main pg1-port=5432 On the pgBackRest server: We maintain two configuration files, specifically /etc/pgbackrest/pgbackrest.conf and /etc/pgbackrest/expire.conf.

Database 91

Database Open Source Storage Servers 91

Percona

JULY 17, 2023

1 among non-relational/document-based systems ( DB-Engines, July 2023 ). Those problems (some with shared elements) include: High cost and complicated pricing structure : Many companies say MongoDB has an expensive and complicated pricing structure ( Cloud Zero, January 2023 ). It ranks No.

Open Source 74

Open Source Database Scalability Software 74

Percona

OCTOBER 31, 2023

Percona has a mission to provide the best open source database software, support, and services so our users can innovate freely. 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. One such feature was managed backups.

Open Source 86

Open Source Database Operating System Programming 86

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 93

Operating System Programming Open Source Testing 93

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. The plan is to start with version 16.

Availability 106

Availability Open Source Database Servers 106

Percona

AUGUST 18, 2023

Why do you need multiple instances on the same server? You can have a host with two or three instances configured as a delayed replica of the source server with SQL Delay of, let’s say, 24hr, 12hr, and 6/3hrs. You can run multiple instances on a server to test your backups with the correct version and configs.

Programming 83

Programming Servers Database Hardware 83

Percona

OCTOBER 11, 2023

There are a couple of third-party tools in the market to migrate data from Atlas to Pecona Server for MongoDB (PSMDB), like MongoPush, Hummingbird, and MongoShake. Below is the sample log when you start MongoShake: [2023/09/25 21:09:13 UTC] [INFO] New session to mongodb+srv://gautam: @cluster0.teeeayh.mongodb.net/

Database 84

Database Open Source Testing Servers 84

Dynatrace

MAY 17, 2023

When software runs in a monolithic stack on on-site servers, observability is manageable enough. OpenTelemetry, the open source observability tool, has emerged as an industry-standard solution for instrumenting application telemetry data to make it observable. OpenTelemetry is a free and open source take on observability.

Metrics 185

Metrics Open Source Traffic Cache 185

Percona

SEPTEMBER 14, 2023

MySQL is an outstanding open source transactional database used by most web-based applications and is very good at handling OLTP workloads. Once we configured the setup, the ClickHouse server will act as a replica. sec) From the ClickHouse end Make sure you have MySQL port access from the ClickHouse server to the MySQL server.

Engineering 85

Engineering Database Servers Analytics 85

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. In another survey, using multiple metrics for overall popularity, PostgreSQL ranks as the fourth most popular database management system ( DB-Engines, March 2023 ). It has evolved steadily, however, during 25 years as an open source project.

Open Source 76

Open Source Healthcare Social Media Database 76

Dynatrace

MAY 17, 2023

OpenTelemetry , the open source observability tool, has become the go-to standard for instrumenting custom applications to collect observability telemetry data. OneAgent is the native telemetry data collector and monitoring solution of Dynatrace. Host monitoring We start off with the very first layer: the host itself.

Metrics 176

Metrics Monitoring Database Network 176

Percona

DECEMBER 29, 2023

Inadequate application-side pooling: Suboptimal application-side pooling can lead to opening a large number of connections, and they may remain open and unused, consuming valuable resources. These connections can accumulate, eventually exhausting server resources and causing the system to become unresponsive.

Servers 78

Servers Database C++ Airlines 78

Percona

APRIL 13, 2023

PostgreSQL is a popular open source relational database management system that is widely used for storing and managing data. Sometimes the server recycles old WAL segments before the backup can finish and cannot find the WAL segment from the primary. for monitoring replication lag. What is replication lag?

Latency 79

Latency Tuning Open Source Network 79

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Therefore, DBAs must take a piecemeal approach to achieve HA with PostgreSQL, bringing together open source extensions and tools from multiple sources. there cannot be high availability.

Availability 82

Availability Open Source Architecture Database 82

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 65

Open Source Database Storage Engineering 65