Skip to content
logo
Percona Server for MySQL
Percona Server for MySQL 8.0.30-22 Update (2022-11-21)
Initializing search
    percona/psmysql-docs
    percona/psmysql-docs
    • Home
      • The Percona XtraDB storage engine
      • List of features available in Percona Server for MySQL releases
      • Percona Server for MySQL feature comparison
      • Changed in Percona Server 8.0
      • Understand version numbers
      • Install Percona Server for MySQL
        • Install using APT repository
        • Files in DEB package
        • Build APT packages
        • Install from downloaded DEB packages
        • Apt pinning
        • Run Percona Server for MySQL
        • Uninstall
        • Install using a RPM repository
        • Files in RPM package
        • Install from downloaded RPM packages
        • Run Percona Server for MySQL
        • Uninstall
        • Install with binary tarballs
        • Binary tarballs available
        • Install Percona Server for MySQL from a source tarball
        • Compile Percona Server for MySQL 8.0 from source
      • Post-installation
      • Percona Server for MySQL in-place upgrading guide: from 5.7 to 8.0
      • Upgrade using the Percona repositories
      • Upgrade from systems that use the MyRocks or TokuDB storage engine and partitioned tables
      • Upgrade using Standalone Packages
      • Downgrade Percona Server for MySQL
      • Running Percona Server for MySQL in a Docker Container
      • Docker environment variables
      • Improved InnoDB I/O scalability
      • Adaptive network buffers
      • Multiple page asynchronous I/O requests
      • Thread pool
      • XtraDB performance improvements for I/O-bound highly-concurrent workloads
      • Prefix index queries optimization
      • Limit the estimation of records in a Query
      • Jemalloc memory allocation profiling
      • The ProcFS plugin
      • Binary logs and replication improvements
      • Compressed columns with dictionaries
      • Extended SELECT INTO OUTFILE/DUMPFILE
      • Extended SET VAR optimizer hint
      • Improved MEMORY storage engine
      • Suppress warning messages
      • Limiting the disk space used by binary log files
      • Support for PROXY protocol
      • SEQUENCE_TABLE(n) function
      • Slow query log rotation and expiration
      • Trigger updates
      • Extended mysqlbinlog
      • Extended mysqldump
      • InnoDB full-text search improvements
      • Too many connections warning
      • Handle corrupted tables
      • Percona Toolkit UDFs
      • Kill idle transactions
      • XtraDB changed page tracking
      • Enforcing storage engine
      • Expanded fast index creation
      • Backup locks
      • Audit log plugin
      • Start transaction with consistent snapshot
      • Extended SHOW GRANTS
      • Utility user
      • Working with SELinux
      • Working with AppArmor
      • PAM authentication plugin
      • Server variables
      • SSL improvements
      • Data masking
        • Using LDAP authentication plugins
        • LDAP authentication plugin system variables
        • Data at Rest Encryption
        • Use the keyring component or keyring plugin
          • Using the Key Management Interoperability Protocol (KMIP)
          • Use the Amazon Key Management Service (AWS KMS)
          • FIDO authentication plugin
        • Encryption functions
        • Encrypt File-Per-Table Tablespace
        • Encrypt schema or general tablespace
        • Encrypt system tablespace
        • Encrypt temporary files
        • Encrypt Binary Log Files and Relay Log Files
        • Encrypting the Redo Log data
        • Encrypt the undo tablespace
        • Rotate the master key
        • Advanced encryption key rotation
        • Encrypt doublewrite buffers
        • Verify the encryption for tables, tablespaces, and schemas
      • User statistics
      • Slow query log
      • Extended show engine InnoDB status
      • Show storage engines
      • Process list
      • Misc. INFORMATION_SCHEMA tables
      • Thread based profiling
      • InnoDB page fragmentation counters
      • Stacktrace
      • Libcoredumper
      • Manage group replication flow control
      • Group replication system variables
      • Percona MyRocks introduction
      • Percona MyRocks installation guide
      • Updated supported features
      • MyRocks limitations
      • Differences between Percona MyRocks and Facebook MyRocks
      • MyRocks Information Schema tables
      • MyRocks server variables
      • MyRocks status variables
      • Gap locks detection
      • Data loading
      • Installing and configuring Percona Server for MySQL with ZenFS support
      • TokuDB introduction
      • TokuDB installation
      • Use TokuDB
      • Fast updates with TokuDB
      • TokuDB files and file types
      • TokuDB file management
      • TokuDB background ANALYZE TABLE
      • TokuDB variables
      • TokuDB status variables
      • TokuDB fractal tree indexing
      • TokuDB troubleshooting
      • TokuDB Performance Schema integration
      • Frequently asked questions
      • Migrate and removing the TokuDB storage engine
      • Percona TokuBackup
      • Release notes index
      • Percona Server for MySQL 8.0.32-24 (2023-03-20)
      • Percona Server for MySQL 8.0.31-23 (2023-02-09)
      • Percona Server for MySQL 8.0.30-22 Update (2022-11-21)
        • Release highlights
        • New features
        • Improvements
        • Bug fixes
        • Platform support
        • Deprecation and removal
        • Useful links
      • Percona Server for MySQL 8.0.30-22 (2022-11-21)
      • Percona Server for MySQL 8.0.29-21 (2022-08-08)
      • Percona Server for MySQL 8.0.28-20 (2022-06-20)
      • Percona Server for MySQL 8.0.28-19 (2022-05-12)
      • Percona Server for MySQL 8.0.27-18 (2022-03-02)
      • Percona Server for MySQL 8.0.26-17 (2022-01-26)
      • Percona Server for MySQL 8.0.26-16 (2021-10-20)
      • Percona Server for MySQL 8.0.25-15 (2021-07-13)
      • Percona Server for MySQL 8.0.23-14 (2021-05-12)
      • Percona Server for MySQL 8.0.22-13 (2020-12-14)
      • Percona Server for MySQL 8.0.21-12 (2020-10-13)
      • Percona Server for MySQL 8.0.20-11 (2020-07-21)
      • Percona Server for MySQL 8.0.19-10 (2020-03-23)
      • Percona Server for MySQL 8.0.18-9
      • Percona Server for MySQL 8.0.17-8
      • Percona Server for MySQL 8.0.16-7
      • Percona Server for MySQL 8.0.15-6
      • Percona Server for MySQL 8.0.15-5
      • Percona Server for MySQL 8.0.14
      • Percona Server for MySQL 8.0.13-4
      • Percona Server for MySQL 8.0.13-3
      • Percona Server for MySQL 8.0.12-2rc1
      • List of variables introduced in Percona Server for MySQL 8.0
      • Development of Percona Server for MySQL
      • Trademark policy
      • Index of INFORMATION_SCHEMA tables
      • Frequently asked questions
      • Copyright and licensing information
      • Glossary

    • Release highlights
    • New features
    • Improvements
    • Bug fixes
    • Platform support
    • Deprecation and removal
    • Useful links

    Percona Server for MySQL 8.0.30-22 Update (2022-11-21)¶

    Release date November 21, 2022
    Install instructions Install Percona Server for MySQL
    Download this version Percona Server for MySQL

    Percona Server for MySQL 8.0.30-22 includes all the features and bug fixes available in the MySQL 8.0.30 Community Edition in addition to enterprise-grade features developed by Percona.

    Percona Server for MySQL is a free, fully compatible, enhanced, and open source drop-in replacement for any MySQL database. It provides superior performance, scalability, and instrumentation.

    Percona Server for MySQL is trusted by thousands of enterprises to provide better performance and concurrency for their most demanding workloads. It delivers more value to MySQL server users with optimized performance, greater performance scalability and availability, enhanced backups, and increased visibility.

    For training, contact Percona Training - Start learning now

    This update to the release notes adds the Deprecation and removal section.

    Release highlights¶

    The following features are Generally Available (GA):

    • Amazon Key Management Service

    • Key Management Interoperability Protocol

    The following features, variables, or options are available only in tech preview:

    • SASL-based LDAP plugin

    • SASL-based LDAP variables

    • Fallback server variables for simple LDAP and SASL-based LDAP

    • FIDO authentication plugin

    • Group Replication options

    Improvements and bug fixes introduced by Oracle for MySQL 8.0.30 and included in Percona Server for MySQL are the following:

    • Supports Generated Invisible Primary Keys(GIPK). This feature automatically adds a primary key to InnoDB tables without a primary key. The generated key is always named my_row_id. The GIPK feature is not enabled by default. Enable the feature by setting sql_generate_invisible_primary_key to ON.

    • The InnoDB_doublewrite system has two new settings:

    • DETECT_ONLY. This setting allows only metadata to be written to the doublewrite buffer. Database page content is not written to the buffer. Recovery does not use the buffer to fix incomplete page writes. Use this setting only when you need to detect incomplete page writes.

    • DETECT_AND_RECOVER. This setting is equivalent to the current ON setting. The doublewrite buffer is enabled. Database page content is written to the buffer and the buffer is accessed to fix incomplete page writes during recovery.

    • The -skip_host_cache server option is deprecated and will be removed in a future release. Use SET GLOBAL host_cache_size= 0 or set host_cache_size = 0.

    Find the full list of bug fixes and changes in the MySQL 8.0.30 Release Notes.

    New features¶

    • PS-8255: Added support to enable users to authenticate using FIDO authentication.

    • PS-6002: Added the global variable --replica-enable-event to maintain the create/alter event state on replicas.

    • PS-7980: Added the global system variables --authentication_ldap_simple_group_role_mapping and --authentication_ldap_sasl_group_role_mapping. When a user logs in with LDAP authentication, the server checks if the LDAP user is a member of any group specified in this variable. If the check is successful, the matching MySQL roles are automatically granted to the user.

    • PS-8275: Implements the ability to eject a cluster node when the node exceeds the flow control threshold by adding a MAJORITY mode to group_replication_flow_control_mode and a global system variable group_replication_auto_evict_timeout.

    Improvements¶

    • PS-8385: Adds the ability to call user-defined functions to register a redo log consumer. A consumer reading the redo log blocks files from being deleted or purged.

    • PS-8169: Adds the ability to use Simple Authentication and Security Layer (SASL) to send secure messages within the LDAP protocol with the SASL-based LDAP authentication. The authentication_ldap_sasl plugin performs the SASL-based LDAP authentication on the server. The client must use the authentication_ldap_sasl_client plugin.

    • PS-8155: Implements support for multiple LDAP server for the simple LDAP authentication plugin and the SASL-based LDAP authentication plugin. If the appropriate system variable is set, and if the primary server is unavailable, the authentication plugin attempts to connect and authenticate using a fallback server. A user can also specify multiple fallback servers. The following global system variables are:

    • authentication_ldap_simple_fallback_server_host

    • authentication_ldap_simple_fallback_server_port

    • authentication_ldap_sasl_fallback_server_host

    • authentication_ldap_sasl_fallback_server_port

    Bug fixes¶

    • PS-8204: A fix for when the audit_log_format was set to XML and the logged queries were truncated after a newline character.

    • PS-8246: Adapted the Encryption UDF MTR test cases to OpenSL 3.0.x. The tests failed because OpenSSL 3.0.x has a different default set of hash functions and PEM reading and writing routines generate different error messages.

    • PS-8351: The SHOW ENGINE INNODB STATUS would output unreadable UTF characters.

    • PS-8364: When using Docker, the data directory for ICU regular expressions was missing.

    • PS-8175: While a thread executes fil_io_set_encryption(), another thread may change the space->encryption_type. If this happens, an assertion in fil_io_set_encryption() caused an unexpected server exit.

    • PS-8428: A fix for an unexpected server exit when --innodb_encrypt_online_alter_logs=ON and ALTER TABLE <tablename> ADD FULLTEXT was executed.

    Platform support¶

    • Percona Server for MySQL 8.0.30 supports Oracle Linux/Red Hat Enterprise Linux 9.

    • Percona Server for MySQL 8.0.30 supports Ubuntu 22.04.

    Deprecation and removal¶

    This release removes the Data Scrubbing feature.

    The master_key and keyring_key options are removed in the innodb_redo_log_encrypt variable. The data type is changed to Boolean.

    Useful links¶

    The Percona Server for MySQL GitHub location

    Contribute to the documentation

    Contact us

    For free technical help, visit the Percona Community Forum.

    To report bugs or submit feature requests, open a JIRA ticket.

    For paid support and managed or consulting services , contact Percona Sales.


    Last update: 2023-01-31
    Percona LLC and/or its affiliates, © 2023
    Made with Material for MkDocs

    Cookie consent

    We use cookies to recognize your repeated visits and preferences, as well as to measure the effectiveness of our documentation and whether users find what they're searching for. With your consent, you're helping us to make our documentation better.