It’s time for the release roundup!
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 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.processlistand thesys.x$processlistviews. - Added support for the
IF NOT EXISTSoption for theCREATE FUNCTION,CREATE PROCEDURE, andCREATE TRIGGERstatements. - Added support for
ALTER TABLE ... DROP COLUMN ALGORITHM=INSTANT. - An anonymous user with the
PROCESSprivilege was unable to selectprocesslisttable 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
PathCollisionerror. 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
TransactionCoordinatorhung.
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.
