Personal blog of Yzmir Ramirez

Percona announces the release of Percona Server for MongoDB 3.6.8-2.0 on October 31, 2018. Download the latest version from the Percona website or the Percona Software Repositories.

Percona Server for MongoDB is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 3.6 Community Edition. It supports MongoDB 3.6 protocols and drivers.

Percona Server for MongoDB extends Community Edition functionality by including the Percona Memory Engine storage engine, as well as several enterprise-grade features. Also, it includes MongoRocks storage engine, which is now deprecated. Percona Server for MongoDB requires no changes to MongoDB applications or code.

This release introduces data at rest encryption for the WiredTiger storage engine. Data at rest encryption for WiredTiger in Percona Server for MongoDB is compatible with the upstream implementation. In this release of Percona Server for MongoDB, this feature is of BETA quality and should not be used in a production environment.

Note that Percona Server for MongoDB 3.6.8-2.0 is based on  MongoDB 3.6.8 which is distributed under the GNU AGPLv3 license. Subsequent releases of Percona Server for MongoDB will change its license to SSPL when we move to the SSPL codebase released by MongoDB. For more information, see Percona Statement on MongoDB Community Server License Change.

This release also contains a fix for bug PSMDB-238

The Percona Server for MongoDB 3.6.8-2.0 release notes are available in the official documentation.

Following the alpha release announced earlier, Percona announces the release candidate of Percona Server for MySQL 8.0.12-2rc1 on October 31, 2018. Download the latest version from the Percona website or from the Percona Software Repositories.

This release is based on MySQL 8.0.12 and includes all the bug fixes in it. It is a Release Candidate quality release and it is not intended for production. If you want a high quality, Generally Available release, use the current Stable version (the most recent stable release at the time of writing in the 5.7 series is 5.7.23-23).

Percona provides completely open-source and free software.

Installation

As this is a release candidate, installation is performed by enabling the testing repository and installing the software via your package manager.  For Debian based distributions see apt installation instructions, for RPM based distributions see yum installation instructions.  Note that in both cases after installing the current percona-release package, you’ll need to enable the testing repository in order to install Percona Server for MySQL 8.0.12-2rc1.  For manual installations you can download from the testing repository directly through our website.

New Features

• #4550: Native Partitioning support for MyRocks storage engine
• #3911: Native Partitioning support for TokuDB storage engine
• #4946: Add an option to prevent implicit creation of column family in MyRocks
• #4839: Better default configuration for MyRocks and TokuDB
• InnoDB changed page tracking has been rewritten to account for redo logging changes in MySQL 8.0.11.  This fixes fast incremental backups for PS 8.0
• #4434: TokuDB ROW_FORMAT clause has been removed, compression may be set by using the session variable tokudb_row_format instead.

Improvements

• Several packaging changes to bring Percona packages more in line with upstream, including split repositories. As you’ll note from our instructions above we now ship a tool with our release packages to help manage this.

Bugs Fixed

• #4785: Setting version_suffix to NULL could lead to handle_fatal_signal (sig=11) in Sys_var_version::global_value_ptr
• #4788: Setting log_slow_verbosity and enabling the slow_query_log could lead to a server crash
• #4947: Any index comment generated a new column family in MyRocks
• #1107: Binlog could be corrupted when tmpdir got full
• #1549: Server side prepared statements lead to a potential off-by-second timestamp on slaves
• #4937: rocksdb_update_cf_options was useless when specified in my.cnf or on command line.
• #4705: The server could crash on snapshot size check in RocksDB
• #4791: SQL injection on slave due to non-quoting in binlogged ROLLBACK TO SAVEPOINT
• #4953: rocksdb.truncate_table3 was unstable

Other bugs fixed:

• #4811: 5.7 Merge and fixup for old DB-937 introduces possible regression
• #4885: Using ALTER … ROW_FORMAT=TOKUDB_QUICKLZ leads to InnoDB: Assertion failure: ha_innodb.cc:12198:m_form->s->row_type == m_create_info->row_type
• Numerous testsuite failures/crashes

Upcoming Features

• New encryption features in Percona Server for MySQL 5.7 will be ported forward to Percona Server for MySQL 8.0
• Adding back in column compression with custom data dictionaries

To resolve a critical regression, Percona announces the release of Percona XtraDB Cluster 5.7.23-31.31.2 on October 2, 2018 Binaries are available from the downloads section or from our software repositories.

This release resolves a critical regression in the upstream wsrep library and supersedes 5.7.23-31.31

Percona XtraDB Cluster 5.7.23-31.31.2 is now the current release, based on the following:

• Percona Server 5.7.23-23
• Galera Replication library 3.24
• Galera/Codership WSREP API Release 5.7.23

All Percona software is open-source and free.

Fixed Bugs

• #2254: A cluster conflict could cause a crash in Percona XtraDB Cluster 5.7.23 if autocommit=off.

Help us improve our software quality by reporting any bugs you encounter using our bug tracking system. As always, thanks for your continued support of Percona!

The post CRITICAL UPDATE for Percona XtraDB Cluster users: 5.7.23-31.31.2 Is Now Available appeared first on Percona Database Performance Blog.

Alpha Build of Percona Server 8.0 released

An alpha version of Percona Server 8.0 is now available in the Percona experimental software repositories. This is a 64-bit release only. 

You may experiment with this alpha release by running it in a Docker container:

$ docker run -d -e MYSQL_ROOT_PASSWORD=password -p 3306:3306 perconalab/percona-server:8.0.12.alpha

When the container starts, connect to it as follows:

$ docker exec -ti $(docker ps | grep -F percona-server:8.0.12.alpha | awk '{print $1}') mysql -uroot -ppassword

Note that this release is not ready for use in any production environment.

Percona Server 8.0 alpha is available for the following platforms:

• RHEL/Centos 6.x
• RHEL/Centos 7.x
• Ubuntu 16.04 Xenial
• Ubuntu 18.04 Bionic
• Debian 8 Jessie
• Debian 9 Stretch

Note: The list of supported platforms may be different in the GA release.

Fixed Bugs:

• PS-4814: TokuDB ‘fast’ replace into is incompatible with 8.0 row replication
• PS-4834: The encrypted system tablespace has empty uuid

Other fixed bugs: PS-4788, PS-4631, PS-4736, PS-4818, PS-4755

Unfinished Features

The following features are work in progress and are not yet in a working state:

• Column compression with Data Dictionaries
• Native Partitioning for TokuDB and for MyRocks
• Encryption
  • Key Rotation
  • Scrubbing

Known Issues

• PS-4788: Setting log_slow_verbosity and enabling the slow_query_log could lead to a server crash
• PS-4803: ALTER TABLE … ADD INDEX … LOCK crash | handle_fatal_signal (sig=11) in dd_table_has_instant_cols
• PS-4896: handle_fatal_signal (sig=11) in THD::thread_id likely due to enabling innodb_print_lock_wait_timeout_info
• PS-4820: PS crashes with keyring_vault encryption
• PS-4796: 8.0 DD and atomic DDL breaks DROP DATABASE for engines that store files in database directory
• PS-4898: Crash during PAM authentication plugin installation.
• PS-1782: Optimizer chooses wrong plan when joining 2 tables
• PS-4850: Toku hot backup plugin dumps tons of info to stdout with no way to disable it
• PS-4797: rpl.rpl_master_errors failing, likely due to binlog encryption
• PS-4800: Recovery of prepared XA transactions seems broken in 8.0
• PS-4853: Installing audit_log plugin causes server to crash
• PS-4855: Replace http with https in http://bugs.percona.com in server crash messages
• PS-4857: Improve error message handling for compressed columns
• PS-4895: Improve error message when encrypted system tablespace was started without keyring plugin
• PS-3944: Single variable to control logging in QRT
• PS-4705: crash on snapshot size check in RocksDB
• PS-4885: Using ALTER … ROW_FORMAT=TOKUDB_QUICKLZ leads to InnoDB: Assertion failure: ha_innodb.cc:12198:m_form->s->row_type == m_create_info->row_type

The post Announcement: Alpha Build of Percona Server 8.0 appeared first on Percona Database Performance Blog.

Percona announces the release of Percona Server for MongoDB 3.4.17-2.15 on September 27, 2018. Download the latest version from the Percona website or the Percona Software Repositories.

Percona Server for MongoDB 3.4 is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 3.4 Community Edition. It supports MongoDB 3.4 protocols and drivers.

Percona Server for MongoDB extends MongoDB Community Edition functionality by including the Percona Memory Engine and MongoRocks storage engines, as well as several enterprise-grade features:

• External Authentication
• Audit Logging
• Profiling Rate Limiting
• Hot Backup
• Log Redaction

Percona Server for MongoDB requires no changes to MongoDB applications or code.

This release is based on MongoDB 3.4.17. There are no additional improvements or new features on top of those upstream fixes.

The post Percona Server for MongoDB 3.4.17-2.15 Is Now Available appeared first on Percona Database Performance Blog.

Percona is glad to announce the release of Percona XtraDB Cluster 5.7.23-31.31 on September 26, 2018. Binaries are available from the downloads section or from our software repositories.

Percona XtraDB Cluster 5.7.23-31.31 is now the current release, based on the following:

• Percona Server for MySQL 5.7.23
• Galera Replication library 3.24
• Galera/Codership WSREP API Release 5.7.23

The post Percona XtraDB Cluster 5.7.23-31.31 Is Now Available appeared first on Percona Database Performance Blog.

Percona announces the release of Percona Server for MongoDB 3.2.21-3.12 on September 18, 2018. Download the latest version from the Percona web site or the Percona Software Repositories.

Percona Server for MongoDB is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 3.2 Community Edition. It supports MongoDB 3.2 protocols and drivers.

Percona Server for MongoDB extends MongoDB Community Edition functionality by including the Percona Memory Engine, as well as several enterprise-grade features. It requires no changes to MongoDB applications or code.

This release updates the MongoDB portion of the Percona Server for MongoDB code base to
to 3.2.21.

The Percona Server for MongoDB 3.2.21-3.12 release notes are available in the official documentation.

The post Percona Server for MongoDB 3.2.21-3.12 Is Now Available appeared first on Percona Database Performance Blog.

Percona announces the release of Percona XtraDB Cluster 5.6.41-28.28 (PXC) on September 18, 2018. Binaries are available from the downloads section or our software repositories.

Percona XtraDB Cluster 5.6.41-28.28 is now the current release, based on the following:

• Percona Server for MySQL 5.6.41
• Codership WSREP API Rrelease 5.6.41
• Codership Galera library 3.24

Help us improve our software quality by reporting any bugs you encounter using our bug tracking system. As always, thanks for your continued support of Percona!

The post Percona XtraDB Cluster 5.6.41-28.28 Is Now Available appeared first on Percona Database Performance Blog.

Percona announces the release of Percona Server for MongoDB 3.6.7-1.5 on September 17, 2018. Download the latest version from the Percona web site or the Percona Software Repositories.

Percona Server for MongoDB is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 3.6 Community Edition. It supports MongoDB 3.6 protocols and drivers.

Percona Server for MongoDB extends MongoDB Community Edition functionality by including the Percona Memory Engine, as well as several enterprise-grade features. Percona Server for MongoDB requires no changes to MongoDB applications or code.

This release is based on MongoDB 3.6.7 and does not include any additional changes.

The Percona Server for MongoDB 3.6.7-1.5 release notes are available in the official documentation.

The post Percona Server for MongoDB 3.6.7-1.5 Is Now Available appeared first on Percona Database Performance Blog.

Percona announces the release of Percona Server for MySQL 5.7.23-23 on September 12, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.23, including all the bug fixes in it. Percona Server for MySQL 5.7.23-23 is now the current GA release in the 5.7 series. All of Percona’s software is open-source and free.

New Features

• The max_binlog_files variable is deprecated, and the binlog_space_limit variable should be used instead of it. The behavior of binlog_space_limit is consistent with the variable relay-log-space-limit used for relay logs; both variables have the same semantics. For more information, see #275.
• Starting with 5.7.23-23, it is possible to encrypt all data in the InnoDB system tablespace and in the parallel double write buffer. This feature is considered ALPHA quality. A new variable innodb_sys_tablespace_encrypt is introduced to encrypt the system tablespace. The encryption of the parallel double write buffer file is controlled by the variable innodb_parallel_dblwr_encrypt. Both variables are OFF by default. For more information, see #3822.
• Changing rocksdb_update_cf_options returns any warnings and errors to the client instead of printing them to the server error log. For more information, see #4258.
• rocksdb_number_stat_computers and rocksdb_rate_limit_delay_millis variables have been removed. For more information, see #4780.
• A number of new variables were introduced for MyRocks: rocksdb_rows_filtered to show the number of rows filtered out for TTL in MyRocks tables, rocksdb_bulk_load_allow_sk to allow adding secondary keys using the bulk loading feature, rocksdb_error_on_suboptimal_collation toggling warning or error in case of an index creation on a char field where the table has a sub-optimal collation, rocksdb_stats_recalc_rate specifying the number of indexes to recalculate per second, rocksdb_commit_time_batch_for_recovery toggler of writing the commit time write batch into the database, and rocksdb_write_policy specifying when two-phase commit data are actually written into the database.

Bugs Fixed

• The statement SELECT...ORDER BY produced inconsistent results with the euckr charset or euckr_bin collation. Bug fixed #4513 (upstream #91091).
• InnoDB statistics could incorrectly report zeros in the slow query log. Bug fixed #3828.
• With the FIPS mode enabled and performance_schema=off, the instance crashed when running the CREATE VIEW command. Bug fixed #3840.
• The soft limit of the core file size was set incorrectly starting with PS 5.7.21-20. Bug fixed #4479.
• The option innodb-optimize-keys could fail when a dumped table has two columns such that the name of one of them contains the other as as a prefix and is defined with the AUTO_INCREMENT attribute. Bug fixed #4524.
• When innodb_temp_tablespace_encrypt was set to ON the CREATE TABLE command could ignore the value of the ENCRYPTION option. Bug fixed #4565.
• If FLUSH STATUS was run from a different session, a statement could be counted twice in GLOBAL STATUS. Bug fixed #4570 (upstream #91541).
• In some cases, it was not possible to set the flush_caches variable on systems that use systemd. Bug fixed #3796.
• A message in the MyRocks log file did not clearly inform whether fast CRC32 was supported. Bug fixed #3988.
• mysqld could not be started on Ubuntu if the database recovery had taken longer than ten minutes. Bug fixed #4546 (upstream #91423).
• The ALTER TABLE command was slow when the number of dirty pages was high. Bug fixed #3702.
• Setting the global variable version_suffix to NULL could lead to a server crash. Bug fixed #4785.

Other Bugs Fixed

• #4620 “Enable encryption of temporary tablespace from foreground thread”
• #4727 “intrinsic temp table behaviour shouldn’t depend on innodb_encrypt_tables”
• #4046 “Ship assert failure: ‘res == 0’ (bulk loader)”
• #3851 “Percona Ver 5.6.39-83.1 Failing assertion: sym_node->table != NULL”
• #4533 “audit_log MTR tests should refer to include files without parent directories”
• #4619 “main.flush_read_lock fails with timeout in wait_condition.inc.”
• #4561 “Read after free at Binlog_crypt_data::load_latest_binlog_key()”
• #4587 “ROCKSDB_INCLUDE_RFR macro in wrong file”

Find the release notes for Percona Server for MySQL 5.7.23-23 in our online documentation. Report bugs in the Jira bug tracker.

The post Percona Server for MySQL 5.7.23-23 Is Now Available appeared first on Percona Database Performance Blog.