May
16
2022
--

KMIP in Percona Distribution for MongoDB, Preview Release of PMM 2.28.0: Release Roundup May 16, 2022

Percona Releases May 16 2022

It’s time for the release roundup!

Percona Releases May 16 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 2, 2022. Take a look!

Percona Distribution for MongoDB 5.0.8

On May 10, 2022, we released Percona Distribution for MongoDB 5.0.8. 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. It includes Percona Server for MongoDB and Percona Backup for MongoDB. This release of Percona Distribution for MongoDB includes the support of master key rotation for data encrypted using the Keys Management Interoperability Protocol (KMIP) (tech preview feature). Thus, users can comply with regulatory standards for data security.

Download Percona Distribution for MongoDB 5.0.8

 

Percona Server for MongoDB 5.0.8-7

Percona Server for MongoDB 5.0.8-7 was released on May 10, 2022. It is an enhanced, source available, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 5.0.8 Community Edition. It supports MongoDB 5.0.8 protocols and drivers. It now supports 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 5.0.8-7

 

Percona Operator for MongoDB 1.12.0

On May 5, 2022, Percona Operator for MongoDB 1.12.0 was released. It automates 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. Release highlights include the ability to use the Amazon Web Services feature of authenticating applications running on EC2 instances based on Identity and Access Management (IAM) roles assigned to the instance, support for the Multi Cluster Services (MCS), and the OpenAPI schema is now generated for the Operator CRD, which allows Kubernetes to perform Custom Resource validation and saves users from occasionally applying deploy/cr.yaml with syntax typos

Download Percona Operator for MongoDB 1.12.0

 

Percona Monitoring and Management 2.28.0

Percona Monitoring and Management 2.28.0 was released on May 12, 2002. It is an open source database monitoring, management, and observability solution for MySQL, PostgreSQL, and MongoDB. Highlights in this release include Advisor checks enabled by default, Ubuntu 22.04 LTS support, and VictoriaMetrics upgraded to 1.76.1.

Download Percona Monitoring and Management 2.28.0

 

Updates to Percona Distribution for PostgreSQL 11.15, 12.10, 13.6, 14.2

Percona Distribution for PostgreSQL provides the best and most critical enterprise components from the open-source community, in a single distribution, designed and tested to work together. Patroni, pgBackRest, pg_repack, and pgaudit are amongst the innovative components we utilize.

Released on May 5, 2022, these updates include the GA version of pg_stat_monitor 1.0.0.

https://docs.percona.com/postgresql/14/release-notes-v14.2.upd2.html

https://docs.percona.com/postgresql/13/release-notes-v13.6.upd2.html

https://docs.percona.com/postgresql/12/release-notes-v12.10.upd2.html

https://docs.percona.com/postgresql/11/release-notes-v11.15.upd2.html

 

Percona Distribution for MySQL (PS-Based Variant) 8.0.28

On May 12, 2022, Percona Distribution for MySQL (PS-based variant) 8.0.28 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. This release is focused on the Percona Server for MySQL-based deployment variant and is based on Percona Server for MySQL 8.0.28-19.

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

  • 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 Distribution for MySQL (PS-based variant) 8.0.28

 

Percona Server for MySQL 8.0.28-19

Percona Server for MySQL 8.0.28-19 was released on May 13, 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. Improvements in this release include when using the SET_VAR syntax, MyRocks variables can be set dynamically, and the ability to change log file locations dynamically is restricted.

Note: Starting with Percona Server for MySQL 8.0.28-19, the TokuDB storage engine is no longer supported. We have removed the storage engine from the installation packages and the storage engine is disabled in our binary builds.

Download Percona Server for MySQL 8.0.28-19

 

Percona XtraBackup 2.4.26

On May 9, 2022, we released Percona XtraBackup 2.4.26. 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. Note: Percona XtraBackup 2.4 does not support making backups of databases created in MySQL 8.0, Percona Server for MySQL 8.0, or Percona XtraDB Cluster 8.0. Use Percona XtraBackup 8.0 to make backups for these versions.

Download Percona XtraBackup 2.4.26

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.

May
02
2022
--

KMIP for Percona Distribution for MongoDB, Updates to Percona XtraBackup: Release Roundup May 2, 2022

Percona Updates May 2 2022

It’s time for the release roundup!

Percona Updates May 2 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 April 18, 2022. Take a look!

 

Percona Distribution for MongoDB 5.0.7

On April 20, 2022, we released Percona Distribution for MongoDB 5.0.7.  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. This release of Percona Distribution for MongoDB includes the support of Keys Management Interoperability Protocol (KMIP). Thus, users can store encryption keys in their favorite KMIP-compatible key manager to set up encryption at rest. This is a tech preview feature.

Download Percona Distribution for MongoDB 5.0.7

 

Percona Server for MongoDB 5.0.7-6

Percona Server for MongoDB 5.0.7-6 was released on April 20, 2022. It’s an enhanced, source-available and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 5.0.7 Community Edition. It supports MongoDB 5.0.7 protocols and drivers. Percona Server for MongoDB now supports Keys Management Interoperability Protocol (KMIP) so that users can store encryption keys in their favorite KMIP-compatible key manager to set up encryption at rest. This is a tech preview feature.

Download Percona Server for MongoDB 5.0.7-6

 

Percona Backup for MongoDB 1.7.0

On April 18, 2022, Percona Backup for MongoDB 1.7.0 was released. 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 single replica set), and for restoring those backups to a specific point in time. A release highlight is support for physical backups in Percona Server for MongoDB starting from versions 4.2.15-16 and 4.4.6-8 and higher. Physical backups drastically speed up backup and restore performance for large databases (several terabytes). This is a technical preview feature.

Download Percona Backup for MongoDB 1.7.0

 

Percona Monitoring and Management 1.17.5

Percona Monitoring and Management 1.17.5 was released on April 21, 2022. It is a free and open source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance.

Important: This note aims to draw attention to the end of life of PMM1. As of May 2022, PMM1 goes End-of-life, and as such, there will be no updates (security or non-security), free or paid support, or online technical content updates. Thus, it is highly recommended to switch over to PMM2.

Download Percona Monitoring and Management 1.17.5

 

Percona XtraBackup 8.0.28-20

On April 26, 2022, Percona XtraBackup 8.0.28-20 was released. It 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. A release highlight is an improvement in the log statements structure. The uniformity of the headers makes it easier to follow an operation’s progress or review the log to diagnose issues. The improved log structure is displayed in the backup, prepare, move-back/copy-back error logs

Download Percona XtraBackup 8.0.28-20

 

Percona XtraBackup 2.4.25

Also on April 26, 2022, we released Percona XtraBackup 2.4.25. Please note: Percona XtraBackup 2.4 does not support making backups of databases created in MySQL 8.0, Percona Server for MySQL 8.0, or Percona XtraDB Cluster 8.0. Use Percona XtraBackup 8.0 to make backups for these versions.

Download Percona XtraBackup 2.4.25

 

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.

Apr
19
2022
--

Make Database Management Easier With Percona Platform

Percona Platform

Percona Software PlatformDatabase management is hard. Not only must your database platform team work to provide consistent and reliable performance, availability, and security, but they also need to meet your developers’ ever-increasing demands to move faster. This strain has led to an environment of increasing complexity, in which you and your teams are tasked with managing hundreds or thousands of siloed databases and their supporting technologies. 

Then, of course, there’s the problem of vendor lock-in. Too often, you’re forced into non-portable platforms or environments, where it’s difficult to reclaim your data, massive and oppressive annual support obligations swell, and vendors are more than happy to hold you hostage over proprietary features. It can seem there’s little way out of the spiral. 

Fortunately, there’s a better way. 

Introducing Percona Platform 

Percona Platform

Percona is different. Since day one, we’ve stood for Keeping Open Source Open. Whatever your environment, any cloud or on-premises, and whatever “enterprise” features you need, we offer ultimate freedom and flexibility. It’s what you’d expect from a company committed to the ideals of free and open source software and why many of you have trusted us for years.

Today, we’re proud to announce that we’re bringing together many of your favorite Percona offerings into a new product called Percona Platform. 

Percona Platform combines our software and services into a subscription-based offering that gives you all the tools and expertise you need to succeed: Whether that’s our fully open, performance-optimized database servers, our Percona-curated distributions, which include best-of-breed solutions for high availability, security, and backup, or Percona Monitoring and Management (PMM).  And we’re backing it up with our world-class services, delivered however you need them — whether that’s support for self-managed installations, or providing you with fully managed database environments.

Take a look at everything included:

Percona software and services

This commitment to giving our customers greater control of availability and access to their data and saving them time on managing databases is why RedMonk wrote: 

“There has been an explosion of data tools available to enterprises, which in turn has led to rampant fragmentation and highly complex, disjointed workflows. Organizations that prize velocity are looking for ways to integrate various data tools into their broader development workflows and monitor them.  This is the opportunity that Percona Platform is built for. The combination of software and services in this space is intended to help customers better manage their database deployments.” –   Rachel Stephens, Sr. Analyst, RedMonk

But you really don’t have to look any further than our customers, who love the combination of Percona software and services. It’s why more than two-thirds of our Support customers run Percona Software, and 58% of our Managed Services customers choose to run Percona databases in addition to their Percona Software.

Here’s what some of them had to say: 

“Percona’s drop-in database software replacement was a big factor as migrations can be tricky! … We have more control with Percona.” – Carpages.ca

“Percona has the best engineers in the world.” –  Appsuite 

“Percona have provided us with the best solutions and identified opportunities for improvement in many areas of MySQL, Postgres, and MongoDB.” – Solera

Percona Platform is designed based on decades of experience from Percona experts, and its production-ready database software is battle-tested in mission-critical environments with the most demanding scale and performance needs.

Discover how the Percona Platform can make database management easier for you. 

 

Apr
18
2022
--

The Newest Percona Monitoring and Management, Percona Distribution for PostgreSQL Version Updates: Release Roundup April 18, 2022

Percona Software Update April 18 2022

Percona Software Update April 18 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 April 4, 2022. Take a look!

Percona Operator for PostgreSQL 1.2.0

On April 6, 2022, we released Percona Operator for PostgreSQL 1.2.0. It is based on best practices for the 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 are key.

Release highlights include

  • With this release, the Operator turns to a simplified naming convention and changes its official name to Percona Operator for PostgreSQL
  • Starting from this release, the Operator automatically generates TLS certificates and turns on encryption by default at cluster creation time. This includes both external certificates which allow users to connect to pgBouncer and PostgreSQL via the encrypted channel, and internal ones used for communication between PostgreSQL cluster nodes
  • Various cleanups in the deploy/cr.yaml configuration file simplifies the deployment of the cluster, making no need in going into YAML manifests and tuning them

Download Percona Operator for PostgreSQL 1.2.0

 

Updates of Percona Distribution for PostgreSQL 11.15, 12.10, 13.6, and 14.2

On April 14, 2022, we released updates to the releases of Percona Distribution for PostgreSQL 11.15, 12.10, 13.6, and 14.2. This update of Percona Distribution for PostgreSQL includes pg_stat_monitor 1.0.0-rc.2 – the new version of the statistics collection tool for PostgreSQL. Release notes:

https://docs.percona.com/postgresql/14/release-notes-v14.2.upd.html

https://docs.percona.com/postgresql/13/release-notes-v13.6.upd.html

https://docs.percona.com/postgresql/12/release-notes-v12.10.upd.html

https://docs.percona.com/postgresql/11/release-notes-v11.15.upd.html

 

Percona Distribution for PostgreSQL 11.15

On April 11, 2022, Percona Distribution for PostgreSQL 11.15 was released. 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.

Download Percona Distribution for PostgreSQL 11.15

 

Percona Distribution for MySQL (PXC-based variant) 8.0.27

April 11, 2022, saw the release of Percona Distribution for MySQL (PXC-based variant) 8.0.27. 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. 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.27-17.1.

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

 

Percona XtraDB Cluster 8.0.27-18.1

On April 11, 2022, we released Percona XtraDB Cluster 8.0.27-18.1, which 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 bug fixes for MySQL 8.0.27, provided by Oracle, and included in Percona Server for MySQL:

  • The default_authentication_plugin is deprecated. Support for this plugin may be removed in future versions. Use the authentication_policy variable.
  • The binary operator is deprecated. Support for this operator may be removed in future versions. Use CAST(... AS BINARY).
  • Fix for when a parent table initiates a cascading SET NULL operation on the child table, the virtual column can be set to NULL instead of the value derived from the parent table.

Download Percona XtraDB Cluster 8.0.27-18.1

 

Percona Monitoring and Management 2.27.0

April 14, 2022, saw the release of Percona Monitoring and Management 2.27.0, a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance.

Important – We recommend using the latest version of the PMM instance. This ensures that you access the latest features of the underlying components, such as VictoriaMetrics, with all the bug fixes in place. One of the critical features of VictoriaMetrics is stream parsing mode, which enhances the performance of PMM and saves memory when scraping targets exposing millions of metrics.

Download Percona Monitoring and Management 2.27.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.

Apr
04
2022
--

Percona Distributions for MongoDB 4.4.13, PostgreSQL 13.6: Release Roundup April 4, 2022

Percona Software Release April 4 2022

Percona Software Release April 4 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 March 21, 2022. Take a look!

Percona Distribution for MongoDB 4.4.13

Percona Distribution for MongoDB 4.4.13 was released on March 23, 2022. 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. This release includes improvements and bug fixes, provided by MongoDB and included in Percona Server for MongoDB. The most notable of them are the following:

  • Added support for Keys Management Interoperability Protocol (KMIP) so that users can store encryption keys in their favorite KMIP-compatible key manager to set up encryption at rest. This is a tech preview feature.
  • 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.13

 

Percona Server for MongoDB 4.4.13-13

Percona Server for MongoDB 4.4.13-13 was released on March 23, 2022, and is an enhanced, source-available, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 4.4.13 Community Edition supporting MongoDB 4.4.13 protocols and drivers. Percona Server for MongoDB now supports Keys Management Interoperability Protocol (KMIP) so that users can store encryption keys in their favorite KMIP-compatible key manager to set up encryption at rest. This is a tech preview feature.

Download Percona Server for MongoDB 4.4.13-13

 

Percona Distribution for PostgreSQL 13.6

On March 22, 2022, we released Percona Distribution for PostgreSQL 13.6, 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 13.6.

Download Percona Distribution for PostgreSQL 13.6

 

Percona Distribution for PostgreSQL 12.10

Percona Distribution for PostgreSQL 12.10 was released on March 30, 2022. It provides the best and most critical enterprise components from the open-source community, in a single distribution, designed and tested to work together. Patroni, pgBackRest, pg_repack, and pgaudit are amongst the innovative components we utilize. This release of Percona Distribution for PostgreSQL is based on PostgreSQL 12.10.

Download Percona Distribution for PostgreSQL 12.10

 

Percona Server for MySQL 5.7.37-40

On March 31, 2022, we released Percona Server for MySQL 5.7.37-40. It includes all the features and bug fixes available in MySQL 5.7.37 Community Edition in addition to enterprise-grade features developed by Percona. Release highlights include 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 buf_validate() function in the InnoDB sources.
  • Fix for when a query using an index that differs from the primary key of partitioned table results in excessive CPU load.

Download Percona Server for MySQL 5.7.37-40

 

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.

Mar
21
2022
--

Percona Distribution for PostgreSQL 14.2: Release Roundup March 21, 2022

Percona Software Releases March 21

Percona Software Releases March 21It’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 March 7, 2022. Take a look!

Percona Distribution for PostgreSQL 14.2

On March 16, 2022, we released Percona Distribution for PostgreSQL 14.2, 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 is based on PostgreSQL 14.2.

Download Percona Distribution for PostgreSQL 14.2

 

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.

Mar
07
2022
--

Updated Percona Distribution for MySQL, Percona Server for MongoDB 4.0.28-23: Release Roundup March 7, 2022

Percona Software Releases March 7 2022

Percona Software Releases March 7 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 February 21, 2022. Take a look!

 

Percona Distribution for MySQL (PS-Based variant) 8.0.27

March 2, 2022, saw the release of Percona Distribution for MySQL (PS-based variant) 8.0.27. 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. The following list is some of the bug fixes for MySQL 8.0.27, provided by Oracle, and included in Percona Server for MySQL and Percona Distribution for MySQL:

  • The default_authentication_plugin is deprecated. Support for this plugin may be removed in future versions. Use the authentication_policy variable.
  • The binary operator is deprecated. Support for this operator may be removed in future versions. Use CAST(... AS BINARY).
  • Fix for when a parent table initiates a cascading SET NULL operation on the child table, the virtual column can be set to NULL instead of the value derived from the parent table.

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

 

Percona Server for MongoDB 4.0.28-23

On February 23, 2022, we released Percona Server for MongoDB 4.0.28-23, an enhanced, source available, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 4.0.28 Community Edition, supporting MongoDB 4.0.28 protocols and drivers.

Download Percona Server for MongoDB 4.0.28-23

 

Percona Server for MySQL 8.0.27-18

Percona Server for MySQL 8.0.27-18 was released on March 2, 2022. It is a free, fully compatible, enhanced, and open source drop-in replacement for any MySQL database. Improvements in this release include the enablement of ZenFS functionality on standard Percona Server packages on Debian 11 and Ubuntu 20.04, implementation of a Slow Query Log Rotation and Expiration in Percona Server for MySQL 8.0., and a deprecation warning when using XtraDB changed page tracking.

Download Percona Server for MySQL 8.0.27-18

 

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.

Feb
21
2022
--

Updated Percona Distributions for MongoDB, PMM 2.26.0: Release Roundup February 21, 2022

Percona Software Release Feb 21 2022

It’s time for the release roundup!

Percona Software Release Feb 21 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 February 7, 2022. Take a look!

 

Percona Distribution for MongoDB 4.4.12

On February 7, 2022, we released Percona Distribution for MongoDB 4.4.12. 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. This release includes improvements and bug fixes provided by MongoDB and included in Percona Server for MongoDB. The most notable from them are the following:

  • Defined a timeout for a health check process and throw an error when the process fails to complete within a timeout. This prevents health check to hang.
  • Added the ability to transition through the valid states of the fault manager, and the interface to observer and log its state transitions.
  • Fixed broken OP_QUERY exhaust cursor implementation
  • Added the repairShardedCollectionChunksHistory command to restore history fields for some chunks. This aims to fix broken snapshot reads and distributed transactions.

Download Percona Distribution for MongoDB 4.4.12

 

Percona Distribution for MongoDB 5.0.6

Percona Distribution for MongoDB 5.0.6 was released on February 10, 2022. It is based on Percona Server for MongoDB 5.0.6-5 and Percona Backup for MongoDB 1.6.1 and includes bug fixes provided by MongoDB and included in Percona Server for MongoDB. The most notable from them are the following:

  • Fixed an issue with inconsistent data observed during the direct upgrade from 4.4.3 and 4.4.4 to 4.4.8+ and 5.0.2+. Data inconsistency was caused by the incorrect checkpoint metadata to sometimes be recorded by MongoDB versions 4.4.3 and 4.4.4. WiredTiger used this metadata during node startup that could lead to data corruption and could cause the DuplicateKey error. The fix requires the upgrade to versions 4.4.11+ or 5.0.5+. For details, refer to WT-8395.
  • Fixed issue unavailability of a shard in sharded clusters. Affects MongoDB versions 5.0.0 – 5.0.5.
  • Fixed time-series bucket OID collisions by adding the difference between the actual timestamp and the rounded timestamp to the instance portion of the OID.

Download Percona Distribution for MongoDB 5.0.6

 

Percona Server for MongoDB 4.4.12-12

Percona Server for MongoDB 4.4.12-12 was released on February 7, 2022. It is an enhanced, source-available and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB Community Edition. It is based on MongoDB 4.4.11 and 4.4.12 and supports MongoDB 4.4.11 – 4.4.12 protocols and drivers. Bug fixes and improvements provided by MongoDB are included in Percona Server for MongoDB.

Download Percona Server for MongoDB 4.4.12-12

 

Percona Server for MongoDB 5.0.6-5

On February 10, 2022, we released Percona Server for MongoDB 5.0.6-5. A release highlight includes a fix for an issue with inconsistent data observed during the direct upgrade from 4.4.3 and 4.4.4 to 4.4.8+ and 5.0.2+. Data inconsistency was caused by the incorrect checkpoint metadata to sometimes be recorded by MongoDB versions 4.4.3 and 4.4.4. WiredTiger used this metadata during node startup that could lead to data corruption and could cause the DuplicateKey error. The fix requires the upgrade to versions 4.4.11+ or 5.0.5+.

Download Percona Server for MongoDB 5.0.6-5

 

Percona Monitoring and Management 2.26.0

February 8, 2022, saw the release of Percona Monitoring and Management 2.26.0, a free and open source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance. Highlights in this release include new experimental dashboards, SMTP configuration verification, and major changes for Integrated Alerting (Technical Preview).

Download Percona Monitoring and Management 2.26.0

 

Percona XtraDB Cluster 5.7.36-31.55

On February 16, 2022, Percona XtraDB Cluster 5.7.36-31.55 was released. 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. Release highlights are bug fixes for MySQL 5.7.36 provided by Oracle, including:

  • Fix for the possibility of a deadlock or failure when an undo log truncate operation is initiated after an upgrade from MySQL 5.6 to MySQL 5.7.
  • Fix for when a parent table initiates a cascading SET NULL operation on the child table, the virtual column can be set to NULL instead of the value derived from the parent table.
  • On a view, the query digest for each SELECT statement is now based on the SELECT statement and not the view definition, which was the case for earlier versions.

Download Percona XtraDB Cluster 5.7.36-31.55

 

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.

Feb
07
2022
--

Percona Distribution for MySQL Operator 2.0.0-alpha Preview: Release Roundup February 7, 2022

Percona Releases Feb 7 2022

Percona Releases Feb 7 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 January 24, 2022. Take a look!

 

Percona Distribution for MySQL Operator 2.0.0-alpha Preview Release

On January 25, 2022, we released the Percona Distribution for MySQL Operator 2.0.0-alpha Preview Release. The already existing Percona Distribution for MySQL Operator is based on Percona XtraDB Cluster, but this is going to run Percona Server for MySQL and provide both regular asynchronous (with semi-sync support) and virtually-synchronous replication based on Group Replication.

Download Percona Distribution for MySQL Operator 2.0.0-alpha Preview Release

 

Percona Server for MySQL 8.0.26-17

Percona Server for MySQL 8.0.26-17 was released on January 26, 2022. It includes all the features and bug fixes available in the MySQL 8.0.26 Community Edition. in addition to enterprise-grade features developed by Percona and is now the current GA release in the 8.0 series. A release highlight is the integration of a ZenFS RocksDB plugin to Percona Server for MySQL. This plugin places files on a raw zoned block device (ZBD) using the MyRocks File System interface. Percona provides a binary release for Debian 11.1. Other Linux distributions are adding support for ZenFS, but Percona does not offer installation packages for those distributions yet. The libzbd package is now linked statically to the RocksDB storage engine.

Download Percona Server for MySQL 8.0.26-17

 

Percona XtraBackup 8.0.27-19

On February 3, 2022, we released Percona XtraBackup 8.0.27-19, which enables MySQL backups without blocking user queries, making it 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, it drives down backup costs while providing unique features for MySQL backups. The following list contains a number of the bug fixes for MySQL 8.0.27, provided by Oracle, and included in Percona Server for MySQL:

  • The default_authentication_plugin is deprecated. Support for this plugin may be removed in future versions. Use the authentication_policy variable.
  • The binary operator is deprecated. Support for this operator may be removed in future versions. Use CAST(... AS BINARY).
  • When a parent table updated or deleted a row, this operation initiated a cascading SET NULL operation on the child table. On the child table, a virtual column value could be set to NULL instead of the value derived from the base column value.

Download Percona XtraBackup 8.0.27-19

 

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.

Jan
24
2022
--

Updated Percona Distributions for MySQL and MongoDB: Release Roundup January 24, 2022

Percona Software Update Jan 2022

It’s time for the release roundup!

Percona Software Update Jan 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 January 3, 2022. Take a look!

 

Percona Distribution for MySQL (PXC-Based Variant) 8.0.26

Percona Distribution for MySQL (PXC-based variant) 8.0.26 was released on January 17, 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. This release is focused on the Percona XtraDB Cluster-based deployment variant, version 8.0.26-16.1.

The following are some of the notable fixes for MySQL 8.0.26, provided by Oracle, and included:

  • The TLSv1 and TLSv1.1 connection protocols are deprecated.

  • Identifiers with specific terms, such as “master” or “slave” are deprecated and replaced. See the Functionality Added or Changed section in the 8.0.26 Release Notes for a list of updated identifiers.

  • When using semisynchronous replication, either the old version or the new version of system variables and status variables are available. You cannot have both versions installed on an instance. Be aware, the new system variables are available when you use the new version, but the old values are not. The old system variables are available when you use the old version, but the new ones are not.

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

 

Percona XtraDB Cluster 8.0.26-16.1

On January 17, 20202, Percona XtraDB Cluster 8.0.26-16.1 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. While there are a number of the notable fixes for MySQL 8.0.26, provided by Oracle, included in this release, there are also known unfixed issues that you should be aware of. Please read the release notes for further information.

Download Percona XtraDB Cluster 8.0.26-16.1

 

Percona Distribution for MongoDB 4.2.18

On January 20, 2022, we released Percona Distribution for MongoDB 4.2.18. It is a collection of solutions to run and operate your MongoDB efficiently with the data being consistently backed up. Percona Distribution for MongoDB includes Percona Server for MongoDB, a fully compatible open source, drop-in replacement for MongoDB, and  Percona Backup for MongoDB. Release highlights include these bug fixes provided by MongoDB:

  • Added the SetAllowMigrationsCommand command that prevents the balancer to migrate chunks on shards.
  • Added a flag for the config server that prevents new migrations to start and ongoing migrations to commit.
  • Improved the duplicate key handler behavior if the exact key already exists in the table. This fixes availability loss during the index build that was caused by checking many false duplicates.

Download Percona Distribution for MongoDB 4.2.18

 

Percona Server for MongoDB 4.2.18-18

Percona Server for MongoDB 4.2.18-18 was released on January 20, 2022. It is an enhanced, source-available, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 4.2.18 Community Edition, supporting MongoDB 4.2.18 protocols and drivers. Bug fixes and improvements in this release, provided by MongoDB, are the following:

  • Added the SetAllowMigrationsCommand command that prevents the balancer to migrate chunks on shards.
  • Added a flag for the config server that prevents new migrations to start and ongoing migrations to commit.
  • Skip running duplicate key handler if the exact key already exists in the table. This fixes availability loss during the index build that was caused by checking many false duplicates.
  • Added periodic clean-up of logical sessions cache on arbiters.

Download Percona Server for MongoDB 4.2.18-18

 

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