Sep
19
2022
--

Percona Distribution for MongoDB 4.2.22, Version updates for Percona Distribution for PostgreSQL: Release Roundup September 19, 2022

Percona Releases Sept 19 2022

Percona Releases Sept 19 2022It’s time for the release roundup!

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.

Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download.

Today’s post includes those releases and updates that have come out since September 6, 2022. Take a look!

Percona Distribution for MongoDB 4.2.22

Percona Distribution for MongoDB 4.2.22 was released on September 6, 2022. It is a collection of solutions to run and operate your MongoDB efficiently with the data being consistently backed up. Important: With this release, the kmipKeyIdentifier option for data-at-rest encryption using the KMIP protocol (tech preview feature) is optional. This change serves to improve the user experience with Percona Server for MongoDB as the option names and behavior are similar to those of MongoDB Enterprise. However, if data-at-rest encryption using KMIP is configured, it is the breaking change because the standard upgrade procedure does not work. We do recommend to use the data-at-rest encryption using the KMIP protocol only for testing purposes until it is in the general availability stage.

Download Percona Distribution for MongoDB 4.2.22

 

Percona Server for MongoDB 4.2.22-22

Percona Server for MongoDB 4.2.22-22 was released on September 6, 2022. It is an enhanced, source available, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 4.2.22 Community Edition. It supports MongoDB 4.2.22 protocols and drivers. Improvements in this release include making the kmipKeyIdentifier option not mandatory.

Download Percona Server for MongoDB 4.2.22-22

 

Percona Operator for MongoDB 1.13.0

On September 15, 2022, Percona Operator for MongoDB 1.13.0 was released, automating the creation, modification, or deletion of items in your Percona Server for MongoDB environment. The Operator contains the necessary Kubernetes settings to maintain a consistent Percona Server for MongoDB instance.

Some release highlights include:

Download Percona Operator for MongoDB 1.13.0

 

Percona Distribution for PostgreSQL 13.8

On September 7, 2022, we released Percona Distribution for PostgreSQL 13.8, a collection of tools to assist you in managing PostgreSQL. Percona Distribution for PostgreSQL installs PostgreSQL and complements it by a selection of extensions that enable solving essential practical tasks efficiently.

This release of Percona Distribution for PostgreSQL is based on PostgreSQL 13.8.

Download Percona Distribution for PostgreSQL 13.8

 

Percona Distribution for PostgreSQL 12.12

Percona Distribution for PostgreSQL 12.12 was released on September 7, 2022.

Download Percona Distribution for PostgreSQL 12.12

 

Percona Distribution for PostgreSQL 11.17

On September 8, 2022, Percona Distribution for PostgreSQL 11.17 was released.

Download Percona Distribution for PostgreSQL 11.17

 

Percona Distribution for MySQL (PXC-Variant) 8.0.29

Percona Distribution for MySQL (PXC-variant) 8.0.29 was released on September 12, 2022. It is a single solution with the most critical enterprise components from the MySQL open source community, designed and tested to work together.

Percona Distribution for MySQL provides two deployment variants: one is based on Percona Server for MySQL and another one is based on Percona XtraDB Cluster (PXC). This release of Percona Distribution for MySQL is focused on the Percona XtraDB Cluster-based deployment variant. It is based on Percona XtraDB Cluster 8.0.29-21. Release highlights include a number of the bug fixes for MySQL 8.0.29, provided by Oracle.

Download Percona Distribution for MySQL (PXC-variant) 8.0.29

 

Percona XtraDB Cluster 8.0.29-21

On September 12, 2022, we released Percona XtraDB Cluster 8.0.29-21, a free, open source, enterprise-grade solution includes the high availability and security features your business requires to meet your customer expectations and business goals. Bugs fixed in this release include:

  • PXC-3982: When the replica node is also an asynchronous slave and, while joining the cluster, this node was not ready to accept connections, a SQL thread failed at the start.
  • PXC-3118: A fix for when, using a thread pool, a brute force abort for a metadata locking (MDL) subsystem conflict stalled.
  • PXC-3999: The cluster was stalled on Waiting for acl cache lock with concurrent user DDL commands.

Download  Percona XtraDB Cluster 8.0.29-21

 

That’s it for this roundup, and be sure to follow us on Twitter to stay up-to-date on the most recent releases! Percona is a leader in providing best-of-breed enterprise-class support, consulting, managed services, training, and software for MySQL, MongoDB, PostgreSQL, MariaDB, and other open source databases in on-premises and cloud environments.

Sep
06
2022
--

Percona Monitoring and Management 2.30, Updates to Percona Distribution for MongoDB: Release Roundup September 6, 2022

Percona Updates Sept 6 2022

Percona Updates Sept 6 2022It’s time for the release roundup!

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.

Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download.

Today’s post includes those releases and updates that have come out since August 22, 2022. Take a look!

Percona Monitoring and Management 2.30

On August 25, 2022, Percona Monitoring and Management 2.30 was released. It is an open source database monitoring, management, and observability solution for MySQL, PostgreSQL, and MongoDB. A release highlight is the introduction of a more user-friendly and insightful experimental Home Dashboard in version 2.30.0. With this new Home Dashboard, you can experience a boost in performance while monitoring a large number of nodes or services. Repeated rows (for a large number of nodes) on the dashboard can take a considerable time to load the Home Dashboard UI.

Download Percona Monitoring and Management 2.30

 

Percona Distribution for PostgreSQL 14.5

On Monday, September 5, 2022, Percona Distribution for PostgreSQL 14.5 was released. It is a collection of tools to assist you in managing PostgreSQL. It installs PostgreSQL and complements it with a selection of extensions that enable solving essential practical tasks efficiently.

Download Percona Distribution for PostgreSQL 14.5

 

Percona Distribution for MongoDB 5.0.11

On September 1, 2022, Percona Distribution for MongoDB 5.0.11 was released. It is a freely available MongoDB database alternative, giving you a single solution that combines enterprise components from the open source community, designed and tested to work together. The aim of Percona Distribution for MongoDB is to enable you to run and operate your MongoDB efficiently with the data being consistently backed up. Important release highlight: With this release, the kmipKeyIdentifier option for data-at-rest encryption using the KMIP protocol (tech preview feature) is optional. This change serves to improve the user experience with Percona Server for MongoDB as the option names and behavior are similar to those of MongoDB Enterprise. However, if data-at-rest encryption using KMIP is configured, it is the breaking change because the standard upgrade procedure does not work. We do recommend to use the data-at-rest encryption using the KMIP protocol only for testing purposes until it is in the general availability stage.

If you have configured data at rest encryption and it is absolutely necessary to upgrade your MongoDB instance, see the upgrade instructions.

Download Percona Distribution for MongoDB 5.0.11

 

Percona Server for MongoDB 5.0.11-10

Percona Server for MongoDB 5.0.11-10 was released on September 1, 2022. It’s an enhanced, source-available, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 5.0.11 Community Edition. It supports MongoDB 5.0.11 protocols and drivers. Important highlight:

With this release, the kmipKeyIdentifier option for data-at-rest encryption using the KMIP protocol (tech preview feature) is optional. This change serves to improve the user experience with Percona Server for MongoDB as the option names and behavior are similar to those of MongoDB Enterprise. However, if data-at-rest encryption using KMIP is configured, it is the breaking change because the standard upgrade procedure does not work. We do recommend to use the data-at-rest encryption using the KMIP protocol only for testing purposes until it is in the general availability stage.

If you have configured data at rest encryption and it is absolutely necessary to upgrade your MongoDB instance, see the upgrade instructions.

Download Percona Server for MongoDB 5.0.11-10

 

Percona Distribution for MongoDB 4.4.16

On August 31, 2022, we released Percona Distribution for MongoDB 4.4.16. This release of Percona Distribution for MongoDB includes improvements and bug fixes, provided by MongoDB and included in Percona Server for MongoDB. Note: take caution when upgrading from earlier versions of v4.4.x to later versions of 4.4 or on to v5.0. See SERVER-68511 for more details.

Download Percona Distribution for MongoDB 4.4.16

 

Percona Server for MongoDB 4.4.16-16

Percona Server for MongoDB 4.4.16-16 was released on August 31, 2022. It is an enhanced, source-available, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 4.4.16 Community Edition. It supports MongoDB 4.4.16 protocols and drivers. Note: Take caution when upgrading from earlier versions of v4.4.x to later versions of 4.4 or on to v5.0. See SERVER-68511 for more details.

Download Percona Server for MongoDB 4.4.16-16

 

Percona XtraDB Cluster 5.7.39-31.61

Percona XtraDB Cluster 5.7.39-31.61 was released on August 29, 2022. Percona XtraDB Cluster is based on Percona Server for MySQL and is a free, open source, enterprise-grade solution that includes the high availability and the security features your business requires to meet your customer expectations and business goals.

The improvements and bug fixes for MySQL 5.7.39, provided by Oracle, and included in Percona Server for MySQL are the following:

  • Enable the performance_schema_show_processlist system variable to use an alternative implementation of the SHOW PROCESSLIST statement. Instead of querying the thread manager and holding a global mutex, which may affect performance, this implementation queries the active thread data from the Performance Schema and does not require a mutex.

Download Percona XtraDB Cluster 5.7.39-31.61

 

That’s it for this roundup, and be sure to follow us on Twitter to stay up-to-date on the most recent releases! Percona is a leader in providing best-of-breed enterprise-class support, consulting, managed services, training, and software for MySQL, MongoDB, PostgreSQL, MariaDB, and other open source databases in on-premises and cloud environments.

Aug
22
2022
--

Percona Distribution for MySQL (PS-Based Variant) 8.0.29, Percona Distribution for MongoDB 5.0.10-9: Release Roundup August 22, 2022

Percona releases Aug 22 2022

Percona releases Aug 22 2022It’s time for the release roundup!

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.

Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download.

Today’s post includes those releases and updates that have come out since August 8, 2022. Take a look!

Percona Distribution for MySQL (Percona Server-based variant) 8.0.29

On August 8, 2022, Percona Distribution for MySQL (PS-based variant) 8.0.29 was released. It is a single solution with the best and most critical enterprise components from the MySQL open-source community, designed and tested to work together. It provides two deployment variants: one is based on Percona Server for MySQL and another one is based on Percona XtraDB Cluster.

The following lists a number of the bug fixes for MySQL 8.0.29, provided by Oracle, and included in Percona Server for MySQL and Percona Distribution for MySQL:

  • The Performance Schema tracks if a query was processed on the PRIMARY engine, InnoDB, or a SECONDARY engine, HeatWave. An EXECUTION_ENGINE column, which indicates the engine used, was added to the Performance Schema statement event tables and the sys.processlist and the sys.x$processlist views.
  • Added support for the IF NOT EXISTS option for the CREATE FUNCTIONCREATE PROCEDURE, and CREATE TRIGGER statements.
  • Added support for ALTER TABLE ... DROP COLUMN ALGORITHM=INSTANT.
  • An anonymous user with the PROCESS privilege was unable to select processlist table rows.

Download Percona Distribution for MySQL (PS-based variant) 8.0.29

 

Percona Server for MySQL 8.0.29-21

Percona Server for MySQL 8.0.29-21 was released on August 8, 2022. It is a free, fully compatible, enhanced, and open source drop-in replacement for any MySQL database. It provides superior performance, scalability, and instrumentation. It includes all the features and bug fixes available in the MySQL 8.0.29 Community Edition in addition to enterprise-grade features developed by Percona.

Download Percona Server for MySQL 8.0.29-21

 

Percona Server for MySQL 5.7.39-42

August 15, 2022, saw the release of Percona Server for MySQL 5.7.39-42, which includes all the features and bug fixes available in MySQL 5.7.39 Community Edition in addition to enterprise-grade features developed by Percona. Improvements are that the SHOW PROCESSLIST statement now displays an extra field TIME_MS. The TIME_MS field provides the information about the time in milliseconds that the thread has been in its current state.

Download Percona Server for MySQL 5.7.39-42

 

Percona Distribution for MongoDB 5.0.10-9

On August 9, 2022, we released Percona Distribution for MongoDB 5.0.10-9, a freely available MongoDB database alternative, giving you a single solution that combines enterprise components from the open source community, designed and tested to work together. This release of Percona Distribution for MongoDB includes bug fixes and improvements provided by MongoDB and included in Percona Server for MongoDB. It specifically includes multiple fixes related to sharding and the resharding operation.

Download Percona Distribution for MongoDB 5.0.10-9

 

Percona Server for MongoDB 5.0.10-9

Percona Server for MongoDB 5.0.10-9 was released on August 9, 2022. It is an enhanced, source available, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 5.0.10 Community Edition. It is rebased on MongoDB 5.0.10 Community Edition and supports MongoDB 5.0.10 protocols and drivers.

This release includes bug fixes and improvements provided by MongoDB and included in Percona Server for MongoDB. It specifically includes multiple fixes relate to sharding and the resharding operation. A few of the bugs of note are the following:

  • SERVER-66418 – Fixed the issue with bad projection created during dependency analysis due to string order assumption. It resulted in the PathCollision error. The issue is fixed by improving dependency analysis for projections by folding dependencies into ancestor dependencies where possible.
  • SERVER-65821 – Fixed the deadlock situation in cross shard transactions that could occur when the FCV (Feature Compatibility Version) was set after the “prepared” state of the transactions. That ended up with both the the setFCV thread and the TransactionCoordinator hung.

Download Percona Server for MongoDB 5.0.10-9

 

That’s it for this roundup, and be sure to follow us on Twitter to stay up-to-date on the most recent releases! Percona is a leader in providing best-of-breed enterprise-class support, consulting, managed services, training, and software for MySQL, MongoDB, PostgreSQL, MariaDB, and other open source databases in on-premises and cloud environments.

Aug
08
2022
--

Anti-Affinity Configuration in Percona Operator for PostgreSQL, Updated Grafana in PMM: Release Roundup August 8, 2022

Percona releases

It’s time for the release roundup!

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.

Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download.

Today’s post includes those releases and updates that have come out since July 25, 2022. Take a look!

Percona Operator for PostgreSQL 1.3.0

On August 4, 2022, we released Percona Operator for PostgreSQL 1.3.0.  It is s based on best practices for configuration and setup of a Percona Distribution for PostgreSQL cluster. The benefits of the Operator are many, but saving time and delivering a consistent and vetted environment is key. Release highlights include

  • The automated upgrade is now disabled by default to prevent unplanned downtimes for user applications and to provide defaults more focused on strict user control over the cluster
  • Flexible anti-affinity configuration is now available, which allows the Operator to isolate PostgreSQL cluster instances on different Kubernetes nodes or to increase its availability by placing PostgreSQL instances in different availability zones

Download Percona Operator for PostgreSQL 1.3.0

Percona Monitoring and Management (PMM) 2.29.1

Percona Monitoring and Management 2.29.1 was released on July 28, 2022. It is an open source database monitoring, management, and observability solution for MySQL, PostgreSQL, and MongoDB. Release highlight is we have updated Grafana to fix critical CVEs impacting Alerting in PMM.

Download Percona Monitoring and Management 2.29.1

 

That’s it for this roundup, and be sure to follow us on Twitter to stay up-to-date on the most recent releases! Percona is a leader in providing best-of-breed enterprise-class support, consulting, managed services, training, and software for MySQL, MongoDB, PostgreSQL, MariaDB, and other open source databases in on-premises and cloud environments.

Jul
25
2022
--

Helm Chart in Percona Monitoring and Management, Percona Distribution for MongoDB 4.4.15-15: Release Roundup July 25, 2022

Percona Software Roundup July 25 2022

It’s time for the release roundup!

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.

Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download.

Today’s post includes those releases and updates that have come out since July 11, 2022. Take a look!

Percona Monitoring and Management 2.29.0

Percona Monitoring and Management 2.29.0 (PMM) was released on July 19, 2022. It is an open source database monitoring, management, and observability solution for MySQL, PostgreSQL, and MongoDB. A release highlight is a short in-app tutorial that automatically pops up when you first launch the application. If you are a new user, this is your virtual unboxing of key features to help you get started easier. If you are an Intermediate or Advanced user, use the tour as a checklist of features worth exploring to ensure you’re making the most out of your PMM.

Also, starting with PMM 2.29.0, we have introduced the helm chart supported by Percona to seamlessly deploy your PMM instances on Kubernetes (k8s), a prominent container orchestration system. With the Helm chart, you can customize your deployment. You can tweak your PMM installation by setting these various parameters.

Download Percona Monitoring and Management 2.29.0

 

Percona Distribution for MongoDB 4.4.15-15

On July 19, 2022, we released Percona Distribution for MongoDB 4.4.15-15. It is a freely available MongoDB database alternative, giving you a single solution that combines enterprise components from the open source community, designed and tested to work together. The aim of Percona Distribution for MongoDB is to enable you to run and operate your MongoDB efficiently with the data being consistently backed up.

Download Percona Distribution for MongoDB 4.4.15-15

 

Percona Server for MongoDB 4.4.15-15

Percona Server for MongoDB 4.4.15-15 was released on July 19, 2022. It is an enhanced, source available, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 4.4.15 Community Edition. It supports MongoDB 4.4.15 protocols and drivers. Release highlights include the support of multiple KMIP servers which adds failover to your data-at-rest encryption setup, and users can set KMIP client certificate password through a flag to simplify the migration from MongoDB Enterprise to Percona Server for MongoDB.

Download Percona Server for MongoDB 4.4.15-15

 

Percona Backup for MongoDB 1.8.1

Percona Backup for MongoDB 1.8.1 was released on July 12, 2022. It is a distributed, low-impact solution for consistent backups of MongoDB sharded clusters and replica sets. This is a tool for creating consistent backups across a MongoDB sharded cluster (or a non-sharded replica set), and for restoring those backups to a specific point in time. Release highlights include:

  • PBM-871 – Fixed the restore failure on a different cluster. Now the UUID of users and system collections are not preserved when replaying the oplog.
  • PBM-881 – The PITR chunks display is now consistent in both pbm status and pbm list outputs.

Download Percona Backup for MongoDB 1.8.1

 

Percona Distribution for MySQL 8.0.28 (Percona XtraDB Cluster-based variant)

Percona Distribution for MySQL 8.0.28 (PXC-based variant) was released on July 19, 2022. It is a single solution with the most critical enterprise components from the MySQL open source community, designed and tested to work together. This release of Percona Distribution for MySQL is focused on the Percona XtraDB Cluster-based deployment variant and is based on Percona XtraDB Cluster 8.0.28-19.1.

Download Percona Distribution for MySQL 8.0.28 (PXC-based variant)

 

Percona XtraDB Cluster 8.0.28-19.1

We released Percona XtraDB Cluster 8.0.28-19.1 on July 19, 2022. It is a free, open source, enterprise-grade solution that includes the high availability and security features your business requires to meet your customer expectations and business goals. Release highlights include improvements and bug fixes introduced by Oracle for MySQL 8.0.28 and included in Percona Server for MySQL are following:

  • The ASCII shortcut for CHARACTER SET latin1 and UNICODE shortcut for CHARACTER SET ucs2 are deprecated and raise a warning to use CHARACTER SET instead. The shortcuts will be removed in a future version.
  • A stored function and a loadable function with the same name can share the same namespace. Add the schema name when invoking a stored function in the shared namespace. The server generates a warning when function names collide.
  • InnoDB supports ALTER TABLE ... RENAME COLUMN operations when using ALGORITHM=INSTANT.
  • The limit for innodb_open_files now includes temporary tablespace files. The temporary tablespace files were not counted in the innodb_open_files in previous versions.

Download Percona XtraDB Cluster 8.0.28-19.1

 

Percona XtraBackup 8.0.29-22

On July 19, 2022, we released Percona XtraBackup 8.0.29-22, which enables MySQL backups without blocking user queries. Percona XtraBackup is ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, Percona XtraBackup drives down backup costs while providing unique features for MySQL backups. Release highlights include new redo log types to support the changes in the INSTANT algorithm behavior. MySQL 8.0.29 extended the support for ALGORITHM=INSTANT to allow columns to be added to any position in a table and column drops. Older versions of Percona XtraBackup are incompatible with MySQL 8.0.29 because of this new functionality.

Download Percona XtraBackup 8.0.29-22

 

That’s it for this roundup, and be sure to follow us on Twitter to stay up-to-date on the most recent releases! Percona is a leader in providing best-of-breed enterprise-class support, consulting, managed services, training, and software for MySQL, MongoDB, PostgreSQL, MariaDB, and other open source databases in on-premises and cloud environments.

Jul
11
2022
--

Percona Distribution for MongoDB 4.2.21, Tech Preview of Percona Operator for MySQL 0.2.0: Release Roundup July 11, 2022

Percona releases july 11 2022

Percona releases july 11 2022It’s time for the release roundup!

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.

Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download.

Today’s post includes those releases and updates that have come out since June 28, 2022. Take a look!

Percona Distribution for MongoDB 4.2.21

Percona Distribution for MongoDB 4.2.21 was released on June 30, 2022. It is a collection of solutions to run and operate your MongoDB efficiently with the data being consistently backed up. Release highlights include:

  • The following improvements to the data-at-rest encryption using the Key Management Interoperability Protocol (KMIP) (tech preview feature):
    • the support of multiple KMIP servers as the failover to your setup
    • the ability to set KMIP client certificate passwords through a flag to simplify the migration from MongoDB Enterprise to Percona Server for MongoDB
  • Added support for Ubuntu 22.04 for Percona Server for MongoDB and Percona Backup for MongoDB.

Download Percona Distribution for MongoDB 4.2.21

 

Percona Server for MongoDB 4.2.21-21

On June 29, 2022, we released Percona Server for MongoDB 4.2.21-21, an enhanced, source-available, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 4.2.21 Community Edition. It supports MongoDB 4.2.21 protocols and drivers. Release highlights include support of multiple KMIP servers and allowing users to set KMIP client certificate passwords through a flag to simplify the migration from MongoDB Enterprise to Percona Server for MongoDB.

Download Percona Server for MongoDB 4.2.21-21

 

Percona Operator for MySQL 0.2.0

Percona Operator for MySQL 0.2.0 was released on June 30, 2022. Version 0.2.0 of the Percona Operator for MySQL is a tech preview release and it is not recommended for production environmentsAs of today, we recommend using Percona Operator for MySQL based on Percona XtraDB Cluster, which is production-ready and contains everything you need to quickly and consistently deploy and scale MySQL clusters in a Kubernetes-based environment, on-premises or in the cloud.

Download Percona Operator for MySQL 0.2.0

That’s it for this roundup, and be sure to follow us on Twitter to stay up-to-date on the most recent releases! Percona is a leader in providing best-of-breed enterprise-class support, consulting, managed services, training, and software for MySQL, MongoDB, PostgreSQL, MariaDB, and other open source databases in on-premises and cloud environments.

Jun
28
2022
--

Encryption Functions in Percona Server for MySQL 8.0.28, Multiple KMIP Servers in Percona Distribution for MongoDB 5.0.9: Release Roundup June 28, 2022

Release Roundup June 28

Release Roundup June 28It’s time for the release roundup!

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.

Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download.

Today’s post includes those releases and updates that have come out since June 13, 2022. Take a look!

Percona Distribution for PostgreSQL 14.4

On June 27, 2022, Percona Distribution for PostgreSQL 14.4 was released.  This release of Percona Distribution for PostgreSQL is based on PostgreSQL 14.4. It fixes the issue with all PostgreSQL 14 versions that could cause silent data corruption when using the CREATE INDEX CONCURRENTLY or REINDEX CONCURRENTLY commands. Learn how to detect and fix silent data corruption in your indexes in the upstream documentation.

Download Percona Distribution for PostgreSQL 14.4

 

Percona Distribution for MySQL (Percona Server for MySQL-based variant) 8.0.28

Percona Distribution for MySQL (PS-based variant) 8.0.28 was released on June 20, 2022. It is a single solution with the best and most critical enterprise components from the MySQL open source community, designed and tested to work together. Release highlights include:

  • Encryption functions and variables to manage the encryption range are added. The functions may take an algorithm argument. Encryption converts plaintext into ciphertext using a key and an encryption algorithm.
  • Support for the Amazon Key Management Service (AWS KMS) component.
  • Error messages are now logged to a memory buffer.
  • ZenFS file system plugin for RocksDB is updated to version 2.1.0.
  • Memory leak and errors detectors (Valgrind or AddressSanitizer) provide detailed stack traces from dynamic libraries (plugins and components). The detailed stack traces make it easier to identify and fix the issues.

Download Percona Distribution for MySQL (PS-based variant) 8.0.28

Percona Server for MySQL 8.0.28-20

On June 20, 2022, we released Percona Server for MySQL 8.0.28-20, a free, fully compatible, enhanced, and open source drop-in replacement for any MySQL database. It provides superior performance, scalability, and instrumentation. New features and improvements introduced include:

  • Percona Server for MySQL implements encryption functions and variables to manage the encryption range. The functions may take an algorithm argument. Encryption converts plaintext into ciphertext using a key and an encryption algorithm. You can also use the user-defined functions with the PEM format keys generated externally by the OpenSSL utility.
  • Percona Server for MySQL adds support for the Amazon Key Management Service (AWS KMS) component.
  • ZenFS file system plugin for RocksDB is updated to version 2.1.0.
  • Memory leak and error detectors (Valgrind or AddressSanitizer) provide detailed stack traces from dynamic libraries (plugins and components). The detailed stack traces make it easier to identify and fix the issues.

Download Percona Server for MySQL 8.0.28-20

 

Percona Distribution for MongoDB 5.0.9

On June 20, 2022, Percona Distribution for MongoDB 5.0.9 was released. It is a freely available MongoDB database alternative, giving you a single solution that combines enterprise components from the open source community, designed and tested to work together. The aim of Percona Distribution for MongoDB is to enable you to run and operate your MongoDB efficiently with the data being consistently backed up. Release highlights include:

  • The following improvements to the data-at-rest encryption using the Keys Management Interoperability Protocol (KMIP) (tech preview feature):
    • the support of multiple KMIP servers as the failover to your setup
    • the ability to set KMIP client certificate passwords through a flag to simplify the migration from MongoDB Enterprise to Percona Server for MongoDB
  • Added support for Ubuntu 22.04 for Percona Server for MongoDB and Percona Backup for MongoDB.
  • Added improvements to initial syncs from a secondary sync source.

Download Percona Distribution for MongoDB 5.0.9

Percona Server for MongoDB 5.0.9-8

Percona Server for MongoDB 5.0.9-8 was released on June 20, 2022. It’s an enhanced, source-available, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 5.0.9 Community Edition. It supports MongoDB 5.0.9 protocols and drivers.

Download Percona Server for MongoDB 5.0.9-8

That’s it for this roundup, and be sure to follow us on Twitter to stay up-to-date on the most recent releases! Percona is a leader in providing best-of-breed enterprise-class support, consulting, managed services, training, and software for MySQL, MongoDB, PostgreSQL, MariaDB, and other open source databases in on-premises and cloud environments.

Jun
13
2022
--

New Percona Distributions for PostgreSQL, Percona Server for MySQL 5.7.38-41: Release Roundup June 13, 2022

Percona Releases June 13 2022

It’s time for the release roundup!

Percona Releases June 13 2022Percona 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.

Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download.

Today’s post includes those releases and updates that have come out since May 31, 2022. Take a look!

Percona Distribution for PostgreSQL 14.3

On June 1, 2022, we released Percona Distribution for PostgreSQL 14.3. It is a collection of tools to assist you in managing PostgreSQL. Percona Distribution for PostgreSQL installs PostgreSQL and complements it with a selection of extensions that enable solving essential practical tasks efficiently. This release is based on PostgreSQL 14.3. The set of extensions supplied with Percona Distribution for PostgreSQL now includes the HAProxy – a high-availability and load-balancing solution. A full list is available in the release notes.

Download Percona Distribution for PostgreSQL 14.3

 

Percona Distribution for PostgreSQL 13.7

June 2, 2022, saw the release of Percona Distribution for PostgreSQL 13.7. This release of Percona Distribution for PostgreSQL is based on PostgreSQL 13.7. Along with HAProxy, this release also includes the following packages:

  • llvm 12.0.1 packages for Red Hat Enterprise Linux 8 and derivatives. This fixes compatibility issues with LLVM from upstream.
  • supplemental ETCD packages that can be used for setting up Patroni clusters. These packages are available for the following operating systems:

Download Percona Distribution for PostgreSQL 13.7

 

Percona Distribution for PostgreSQL 12.11

Percona Distribution for PostgreSQL 12.11 was released on June 7, 2022. This release of Percona Distribution for PostgreSQL is based on PostgreSQL 12.11.

Download Percona Distribution for PostgreSQL 12.11

 

Percona Distribution for PostgreSQL 11.16

On June 7, 2022, we released Percona Distribution for PostgreSQL 11.16. Percona Distribution for PostgreSQL is also shipped with the libpq library. It contains “a set of library functions that allow client programs to pass queries to the PostgreSQL backend server and to receive the results of these queries.”

Download Percona Distribution for PostgreSQL 11.16

 

Percona Server for MySQL 5.7.38-41

Percona Server for MySQL 5.7.38-41 was released on June 2, 2022. It is a free, fully compatible, enhanced, and open source drop-in replacement for any MySQL database. It provides superior performance, scalability, and instrumentation. This release includes all the features and bug fixes available in MySQL 5.7.38 Community Edition in addition to enterprise-grade features developed by Percona. Improvements and bug fixes provided by Oracle for MySQL 5.7.38 and included in Percona Server for MySQL are the following:

  • If a statement cannot be parsed, for example, if the statement contains syntax errors, that statement is not written to the slow query log.
  • Loading an encrypted table failed if purge threads processed the undo records for that table.
  • There was a memory leak when mysqldump was used on more than one table with the –order-by-primary option. The memory allocated to sort each row in a table is now released after every table.

Download Percona Server for MySQL 5.7.38-41

 

Percona Operator for MySQL based on Percona XtraDB Cluster 1.11.0

Percona Operator for MySQL based on Percona XtraDB Cluster 1.11.0 was released on June 3, 2022. It contains everything you need to quickly and consistently deploy and scale Percona XtraDB Cluster instances in a Kubernetes-based environment on-premises or in the cloud.

Download Percona Operator for MySQL based on PXC 1.11.0

 

Percona Backup for MongoDB 1.8.0

On June 9, 2022, we released Percona Backup for MongoDB 1.8.0. It’s a distributed, low-impact solution for consistent backups of MongoDB sharded clusters and replica sets. This is a tool for creating consistent backups across a MongoDB sharded cluster (or a single replica set), and for restoring those backups to a specific point in time. Release highlights include:

Download Percona Backup for MongoDB 1.8.0

 

That’s it for this roundup, and be sure to follow us on Twitter to stay up-to-date on the most recent releases! Percona is a leader in providing best-of-breed enterprise-class support, consulting, managed services, training, and software for MySQL, MongoDB, PostgreSQL, MariaDB, and other open source databases in on-premises and cloud environments.

Jun
06
2022
--

Percona Platform and Percona Account Benefits

Percona Platform and Percona Account

On the 15th of April, Percona introduced the general availability of Percona Platform, and with that step, our company started a new, interesting period.

Popular questions we have received after this date include: 

  • What is Percona Platform, and how does it differ from Pecona Account? 
  • What is the difference between Percona Platform and Percona Portal? 
  • Why should Percona users connect to Percona Platform?

In this blog post, I will answer these questions and provide a summary of the benefits of a Percona Account. 

What is Percona Platform, and how does it differ from Pecona Account? 

First, let’s make sure we understand the following concepts:

Percona PlatformA unified experience for developers and database administrators to monitor, manage, secure, and optimize database environments on any infrastructure. It includes open source software and tools, access to Percona Expert support, automated insights, and self-service knowledge base articles.

Percona Account – A single login provides users with seamless access across all Percona properties, as well as insights into your database environment, knowledge base, support tickets, and guidance from Percona Experts. By creating a Percona Account, you get access to Percona resources like Forums, Percona Portal, ServiceNow (for current customers), and, in the future, other Percona resources (www.percona.com, Jira, etc.).

Percona Portal One location for your Percona relationship, with a high-level overview of your subscription and key resources like the knowledge base, support tickets, and ability to access your account team from anywhere.

Next, let’s try to understand the complete flow users will have to go through when they decide to start using the Percona Platform. A Percona Account is foundational to Percona Platform. Users can create their own account here on Percona Portal. There are two options for Percona Account creation, either via an email and password or by using a social login from Google or Github.  

What is the difference between Percona Platform and Percona Portal? 

From the description above Percona Platform is a great experience in open source software, services, tools, and resources Percona is offering to all users. Percona Portal is just a part of Percona Platform and could be thought of as the core component of Percona Platform to discover the value Percona is offering to registered users.

Why should Percona users connect to Percona Platform?

Percona Platform brings together enterprise-ready distributions of MySQL, PostgreSQL, and MongoDB and a range of open source tools for database monitoring, backup, and management, making it easier to run complex database environments.

Percona Platform consists of several essential units: 

  • Percona Account, 
  • Percona Monitoring & Management, which can assure alerting, advisor insight for users’ environments, backups, private DBaaS, etc.
  • Percona Portal, 
  • Support and services.

Percona Monitoring and Management, DBaaS 

The heart of Percona Platform is Percona Monitoring and Management (PMM), which provides the observability required to understand database health while offering actionable insights to remediate database incidents or performance issues. 

PMM has already won the hearts of millions of DBAs around the world with its Query Analytics (QAN) and Advisors and now with Percona Platform release we made it even cooler! 

The new technical preview feature that I’m talking about is Private DBaaS. 

With less than 20 minutes to configure, Percona Private DBaaS enables you to provide self-service databases to your internal teams in any environment. 

Percona Private DBaaS enables Developers to create and manage database clusters through familiar UI and well-documented API, providing completely open source and ready-to-use clusters with MySQL or MongoDB that contain all necessary Kubernetes settings. Each cluster is set up with high availability, load balancing, and essential monitoring and management.

Private DBaaS feature of PMM is free from vendor lock-in and does not enforce any cloud or on-prem infrastructure usage restrictions.

Learn more about DBaaS functionality in our Documentation

Percona Portal 

Percona Portal is a simple UI to check and validate your relationship with Percona software and services. Stay tuned for updates. 

percona platform

To start getting the value from Percona Portal, just create an organization in the Portal and connect Percona Monitoring & Management using a Percona account. Optionally, you can also invite other members to this group in order to share a common view of your organization, any PMM connection details, a list of current organization members, etc. 

When existing Percona customers create their accounts with corporate email, Percona Portal already knows about their organization. They are automatically added as members and can see additional details about their account, like opened support tickets, entitlements, and contact details.

Percona Portal

Percona Account and SSO

Percona Platform is a combination of open source software and services. You can start discovering software advantages right from installing PMM and start monitoring and managing your environments. You could ask yourself what role of the Platform connection is there? Let’s briefly clarify this.

SSO is the first advantage you should see upon connecting your PMM instance to Percona Platform. All users in the organization are able to sign in to PMM using their Percona Account credentials. They also will be granted the same roles in PMM and Portal.  For example, if a user is an admin on Percona Portal, they do not need to create a new user in PMM, but will instead be automatically added as an admin in PMM. Portal Technical users will be granted a Viewer role in PMM.

Let’s assume a Percona Platform user has already created an account, has his own organization with a couple of members in it, and has also connected PMM to the Platform with a Percona Account. Then, he is also able to use SSO for the current organization. 

Percona Advisors

Advisors provide automated insights and recommendations within Percona Monitoring and Management, ensuring your database performs at its best. Constantly evolving with technology and user feedback, the Advisors check for:

  • Availability at risk,
  • Replication inconsistencies,
  • Durability at risk,
  • Passwordless users,
  • Unsecure connections,
  • Unstable OS configuration,
  • Available performance improvements and more.

 Advisors workflow consists of the following:

  1. If the user has just started PMM and set up monitoring of some databases and environments, we provide him with a set of basic Advisors.  To check the list the user should go to the Advisors section in PMM.
    Percona Advisors
  2. After the user connects PMM and Platform on Percona Portal, this list gets bigger and the set of advisors is updated. 
  3. The final step happens with a Percona Platform subscription. If a user subscribes to Percona Platform, we provide the most advanced list of Advisors, which cover a lot of edge cases and check database environments.

See the full list of Advisors and various tiers in our documentation here

As an open source company, we are always eager to engage the community and invite them to innovate with us. 

Here you can find the developer guides on how to create your own Advisors.

How to register a Percona Account?

There are several options to create a Percona account. The first way is to specify your basic data – email, last name, first name, and password.

  1. Go toDon’t have an account? Create one” on the landing page for Percona Portal. 
  2. Enter a minimal set of information (work email, password, first and last name), confirm that you agree with Percona’s Terms of Service and the Privacy Policy agreement, and hit Create.
  3. register percona accountTo complete your registration, check your email and follow the steps provided there. Click the confirmation link in order to activate your account. You may see messages coming from Okta, this is because Percona Platform uses Okta as an identity provider.
  4. After you have confirmed your account creation, you can log in to Percona Portal.

You can also register a Percona Account if you already have a Google or Github account created.

When you create a Percona account with Google and Github, Percona will store only your email and authenticate you using data from the given identity providers.

  1. Make sure you have an account on Google/Github.
  2. On the login page, there are dedicated buttons that will instruct you to confirm account information usage by Percona.
  3. Confirm you are signing in to your account if 2FA for your Google is enabled.
  4. Hurray! Now you have an active account on Percona Portal.

The next option to register a Percona Account is to Continue with Github. The process is similar to Google. 

  1.  An important precondition has to be met prior to account usage and registration: Set your email address in Github to Public.
  2. From Settings, go to the Emails section and uncheck the Keep my email address private option. These settings will be saved automatically. If you do not want to change this option in Github, so you could use other accounts like Google, or create your own with email.
  3. If you already registered an account, you are ready to go with Percona Portal. Use your Google/Github credentials every time you log in to your account.

Conclusions

Start your Percona Platform experience with Percona Monitoring & Management – open source database monitoring, management, and observability solution for MySQL, PostgreSQL, and MongoDB.

Set up Percona Monitoring and Management (version >2.27.0) following PMM Documentation

The next step is to start exploring Percona Platform and get more value and experience from Percona database experts by creating a Percona Account on Percona Portal. The key benefits of Percona  Platform include: 

  • A Percona Account as a single authentication mechanism to use across all Percona resources, 
  • Access to Percona content like blogs and forums, knowledge base.
  • Percona Advisors that help optimize, manage and monitor database environments.

Once you create a Percona account, you will get basic advisors, open source software, and access to community support and forums.

When connecting Percona Monitoring and Management to Percona Account you will get a more advanced set of advisors for your systems security, configuration, performance, and data design.

Percona Platform subscription is offering even more advanced advisors for Percona customers and also a fully supported software experience, private DBaaS, and an assigned Percona Expert to ensure your success with the Platform. 

Please also consider sharing your feedback and experience with Percona on our Forums.

Visit Percona Platform online help to view Platform-related documentation, and follow our updates on the Platform what’s new page.

May
31
2022
--

KMIP in Percona Distribution for MongoDB, Amazon KWS in Percona XtraBackup: Release Roundup May 31, 2022

Percona Release Roundup May 31 2022

It’s time for the release roundup!

Percona Release Roundup May 31 2022Percona 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.

Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download.

Today’s post includes those releases and updates that have come out since May 16, 2022. Take a look!

 

Percona Distribution for MongoDB 4.4.14-14

On May 25, 2022, we released Percona Distribution for MongoDB 4.4.14-14, a freely available MongoDB database alternative, giving you a single solution that combines enterprise components from the open source community, designed and tested to work together. The aim of Percona Distribution for MongoDB is to enable you to run and operate your MongoDB efficiently with the data being consistently backed up.

This release of Percona Distribution for MongoDB includes improvements and bug fixes, provided by MongoDB and included in Percona Server for MongoDB. The most notable of them are the following:

  • Support of the master key rotation for data encrypted using the Keys Management Interoperability Protocol (KMIP) protocol (tech preview feature). This improvement allows users to comply with regulatory standards for data security.
  • Fixed the issue where having a large number of split points causes the chunk splitter to not function correctly and huge chunks would not be split without manual intervention. This can be caused when having small shard key ranges and a very high number of documents and where more than 8192 split points would be needed.
  • Added the repairShardedCollectionChunksHistory command to restore history fields for some chunks. This aims to fix broken snapshot reads and distributed transactions.
  • Fixed incorrect logging of queryHash/planCacheKey for operations that share the same $lookup shape
  • Added a new startup parameter that skips verifying the table logging settings on restarting as a replica set node from the standalone mode during the restore. This speeds up the restore process.

Download Percona Distribution for MongoDB 4.4.14-14

 

Percona Distribution for MongoDB 4.2.20

Percona Distribution for MongoDB 4.2.20 was released on May 23, 2022. Bug fixes, provided by MongoDB and included in Percona Server for MongoDB 4.2.20-20 and Percona Distribution for MongoDB 4.2.20 are the following:

  • Support of the master key rotation for data encrypted using the Keys Management Interoperability Protocol (KMIP) protocol (tech preview feature). This improvement allows users to comply with regulatory standards for data security.
  • Abort the WiredTiger transaction after releasing Client lock to avoid deadlocks.
  • Check if the host has cgroups v2 enabled and read the memory limits according to that.
  • Return the shutdown error as the top-level error when batch writing command fails due to mongos shutdown.
  • Fixed the double free state for the DocumentSource::optimizeAt() pipeline by making sure all pointers are in place before disposing of the pipeline prefix.

Download Percona Distribution for MongoDB 4.2.20

 

Percona Server for MongoDB 4.4.14-14

On May 25, 2022, Percona Server for MongoDB 4.4.14-14  was released. It is an enhanced, source-available, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 4.4.14 Community Edition. It supports MongoDB 4.4.14 protocols and drivers. A release highlight is that it now supports the master key rotation for data encrypted using the Keys Management Interoperability Protocol (KMIP) protocol (tech preview feature). This improvement allows users to comply with regulatory standards for data security.

Download Percona Server for MongoDB 4.4.14-14

 

Percona Server for MongoDB 4.2.20-20

May 23, 2022, saw the release of Percona Server for MongoDB 4.2.20-20. Improvements and bug fixes introduced by MongoDB and included in Percona Server for MongoDB are the following:

  • SERVER-64983 – Abort the WiredTiger transaction after releasing Client lock to avoid deadlocks
  • SERVER-60412 – Check if the host has cgroups v2 enabled and read the memory limits according to that.
  • SERVER-64642 – Return the shutdown error as the top-level error when batch writing command fails due to mongos shutdown.
  • SERVER-59435 – Fixed the double free state for the DocumentSource::optimizeAt() pipeline by making sure all pointers are in place before disposing of the pipeline prefix

Download Percona Server for MongoDB 4.2.20-20

 

Percona XtraDB Cluster 5.7.37-31.57

On May 18, 2022, Percona XtraDB Cluster 5.7.37-31.57 was released. It supports critical business applications in your public, private, or hybrid cloud environment. Our free, open source, enterprise-grade solution includes the high availability and security features your business requires to meet your customer expectations and business goals.

The following lists a number of the notable updates and fixes for MySQL 5.7.37, provided by Oracle, and included in Percona Server for MySQL:

  • The performance on debug builds has been improved by optimizing the buf_validate() function in the InnoDB sources.
  • Fix for when a query using an index that differs from the primary key of the partitioned table results in excessive CPU load.
  • Enabling PAD_CHAR_TO_FULL_LENGTH SQL mode on a replica server added trailing spaces to a replication channel’s name in the replication metadata repository tables. Attempts to identify the channel using the padded name caused errors. The SQL mode is disabled when reading from those tables.

Find the complete list of bug fixes and changes in MySQL 5.7.37 Release Notes.

Download Percona XtraDB Cluster 5.7.37-31.57

 

Percona XtraBackup 8.0.28-21

Percona XtraBackup 8.0.28-21 was released on May 25, 2022. It enables MySQL backups without blocking user queries. Percona XtraBackup is ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, Percona XtraBackup drives down backup costs while providing unique features for MySQL backups. Percona XtraBackup adds support for the Amazon Key Management Service (KMS) component.

Download Percona XtraBackup 8.0.28-21

 

That’s it for this roundup, and be sure to follow us on Twitter to stay up-to-date on the most recent releases! Percona is a leader in providing best-of-breed enterprise-class support, consulting, managed services, training, and software for MySQL, MongoDB, PostgreSQL, MariaDB, and other open source databases in on-premises and cloud environments.

Powered by WordPress | Theme: Aeros 2.0 by TheBuckmaker.com