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 124

Servers Open Source Tuning C++ 124

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 93

Innovation Open Source Scalability Servers 93

Percona

OCTOBER 16, 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 October 5, 2023, Percona Monitoring and Management 2.40.0 Take a look.

Servers 80

Servers Monitoring Open Source Scalability 80

Percona

JUNE 26, 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 June 15, 2023, Percona Distribution for MySQL (PS-based variation) 8.0.33

Servers 75

Servers Open Source Scalability Database 75

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 90

Open Source Servers Scalability Database 90

Percona

DECEMBER 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 December 12, 2023. was released on December 5, 2023.

Monitoring 93

Monitoring Open Source Servers Database 93

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 89

Open Source Database Servers Scalability 89

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. was released on August 14, 2023. Percona Server for MySQL 5.7.43-47

Open Source 87

Open Source AWS Servers Database 87

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. was released on June 5, 2023. was announced on June 5, 2023. Take a look!

Open Source 88

Open Source Servers Database Scalability 88

Percona

JANUARY 30, 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 9, 2023. was released on January 23, 2023.

Open Source 91

Open Source Storage AWS Cloud 91

Percona

MARCH 13, 2023

to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 server with Percona XtraBackup. In my lab, we have two test nodes: PRIMARY: mysql57 (192.168.56.111) with Percona Server 5.7 server instances are ready for an upgrade. On primary server mysql5.7,

Servers 111

Servers C++ Storage Systems 111

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 85

Open Source Scalability Database Servers 85

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 86

Open Source Azure Servers Programming 86

Percona

OCTOBER 31, 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. PMM) was released on October 20, 2023. was released on October 16, 2023.

Monitoring 85

Monitoring Open Source Scalability Database 85

Dynatrace

JUNE 15, 2023

If your application runs on servers you manage, either on-premises or on a private cloud, you’re responsible for securing the application as well as the operating system, network infrastructure, and physical hardware. However, open source software is often a vector for security vulnerabilities.

Cloud 189

Cloud Open Source Architecture Monitoring 189

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 83

Open Source Servers Scalability Cache 83

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 86

Open Source Servers Database Scalability 86

Percona

APRIL 10, 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 27, 2023. was released on March 27, 2023.

Open Source 83

Open Source Servers Database AWS 83

Percona

MAY 8, 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 May 2, 2023, Percona Monitoring and Management 2.37 (PMM) was released.

Monitoring 82

Monitoring Open Source Database Servers 82

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 90

Servers Database Open Source Scalability 90

Percona

FEBRUARY 2, 2023

PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server. The pg_hba.conf file is used to configure the authentication methods the PostgreSQL server uses and can specify different methods for different types of connections.

Database 129

Database Servers Testing Programming 129

Percona

APRIL 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. 24 was released on April 18, 2023. 24 (2023-03-20) release notes. Take a look!

Open Source 83

Open Source Storage Servers Database 83

Percona

JULY 10, 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 June 28, 2023. was released on June 29, 2023. Take a look!

Monitoring 82

Monitoring Open Source Database Scalability 82

Percona

SEPTEMBER 21, 2023

You can show your support for open source software by participating in an event next March in Pasadena, California – The Southern California Linux Expo, or SCaLE. SCaLE is the largest community-run open source and free software conference in North America. The expo hall is open Friday – Sunday.

Open Source 117

Open Source Programming Software Software 117

Percona

JANUARY 9, 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. was released on January 6, 2023. and included in Percona Server for MySQL include: Supports Generated Invisible Primary Keys(GIPK).

Open Source 90

Open Source Database Servers Software 90

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. PMM) was released on July 13, 2023. was released on July 19, 2023.

Open Source 77

Open Source Database Scalability Monitoring 77

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 192

Metrics Open Source Traffic Cache 192

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 74

Monitoring Open Source Database Software 74

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 88

Servers C++ Database Systems 88

Percona

FEBRUARY 23, 2023

It is a common practice that before a backup can be stored in the cloud or on a dedicated backup server, it has to be prepared first locally and later copied to the destination. zst 2023-02-07T19:33:58.138+0100 writing db2.products products to archive on stdout 2023-02-07T19:33:58.140+0100 writing db2.people

AWS 125

AWS Storage Database Open Source 125

Percona

SEPTEMBER 19, 2023

Now, since backup speed and compactness are important for busy, important databases, Percona’s open source physical backup solution – Percona XtraBackup (PXB) , takes into account all these aspects and benefits MySQL world with its exceptional capabilities! Copyright (c) 2016, 2023, Oracle and/or its affiliates.

C++ 112

C++ Servers Storage Speed 112

Percona

DECEMBER 6, 2023

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. PMM Dump allows you to share monitoring data collected by your PMM server securely with the Percona Support team. 2023-01-05T20:01:33+03:00 INF Processing 1/49 chunk.

Monitoring 104

Monitoring Metrics Analytics Open Source 104

Percona

JUNE 29, 2023

Before Percona Server for MongoDB 4.4 PSMDB), the best practice to create an index was doing it in a rolling manner. Many folks used to create directly on Primary, resulting in the first index being created successfully on Primary and then replicated to Secondary nodes. Starting from PSMDB 4.4, Status of nodes: rs1:PRIMARY> rs.status().members.forEach(function

Servers 85

Servers C++ Storage Best Practices 85

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 101

Database Open Source Storage Servers 101

Percona

FEBRUARY 9, 2023

Welcome to 2023! If you replicate from one server to the next, are you replicating what you need? Take some to check how the server is being accessed, as you do not want a project to use the root access for all queries. reaches end-of-life status in October of 2023, so if you are using that release you need to plan to upgrade.

Database 97

Database Open Source Hardware Operating System 97

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. As we are committed to open source, we hope to involve the community in discussing the best approaches for transparent data encryption (TDE) in PostgreSQL.

Availability 115

Availability Open Source Database Servers 115

Percona

DECEMBER 27, 2023

As we at Percona wind down 2023 and look into what the next year holds, our attention is drawn to the cloud-native landscape and how it is maturing, growing, and evolving. KubeCon NA 2023 recap The theme for KubeCon NA was very clear — AI and Large Language Models (LLMs). We expect that number to rise higher in 2024.

Cloud 85

Cloud Open Source Strategy Best Practices 85