All Products
Search
Document Center

PolarDB:PolarProxy release notes

Last Updated:May 07, 2026

This topic describes the release notes for PolarProxy for PolarDB for MySQL.

Version management

The database proxy for PolarDB for MySQL follows two versioning tracks:

  • New Purchase Version: The version number assigned to new instances.

  • Stable Version: The target version number for proxy minor version upgrades.

The risk level of a new version determines its release track. Bug-fix releases become both a new purchase version and a stable version. Major feature releases start as a new purchase version. A new purchase version becomes a stable version two to three months after its release.

Version number

Log on to the PolarDB console. On the Settings and Management > Version Management page for the target cluster, you can view the PolarProxy version information.数据库代理版本信息

PolarProxy for PolarDB for MySQL has two major versions: 1.x.x and 2.x.x.

  • 1.x.x

    This is the PolarProxy version for clusters that were created before February 1, 2021. This version no longer receives new feature updates. It only receives bug fixes.

  • 2.x.x

    This is the PolarProxy version for clusters that were created on or after February 1, 2021. It is the current mainstream version. This version supports all new features, such as persistent connections and data masking.

Note
  • To upgrade from version 1.x.x to 2.x.x, your cluster's kernel version must meet the following requirements:

    • If your cluster runs PolarDB for MySQL 8.0.2, there are no kernel version requirements.

    • If your cluster runs PolarDB for MySQL 8.0.1, the minor version must be 8.0.1.1.10 or later.

    • If your cluster runs PolarDB for MySQL 5.7, the minor version must be 5.7.1.0.6 or later.

    • If your cluster runs PolarDB for MySQL 5.6, the minor version must be 5.6.1.0.24 or later.

  • To learn how to upgrade the PolarProxy version, see minor version management.

PolarProxy release log

Database proxy 2.x.x release notes

Note

This list includes only mainstream versions of PolarProxy. Your version number may not be listed.

  • 2.9.21 (Released on: 2026-04-23)

    Category

    Description

    New Features

    • Supports socket hot migration for zero-downtime proxy upgrades. Client connections remain active while PolarProxy is upgraded to a new version.

      Note

      This feature is currently in a canary rollout and is disabled by default. To enable it, submit a ticket to contact us.

    • Supports monotonic read consistency. Within a single session, each read is guaranteed to return data at least as recent as the previous read, preventing stale-data regressions.

    • Introduces document database protocol (NoSQL) support, covering CRUD operations, aggregation pipelines, index management, and user authentication.

    Performance Optimizations

    • Reduced SQL parsing overhead by eliminating redundant Query Classifier (QC) parsing calls on the critical execution path.

    • When no columnstore index read-only nodes are available under a service, requests carrying the force_imci_nodes hint now gracefully fall back to row-store read-only (RO) nodes instead of returning an error.

    • Improved connection retention during primary-standby failover when both binary logging and hot standby nodes are enabled.

    Bug Fixes

    • Fixed a proxy crash in data masking or encryption scenarios where non-ping-pong packet mode could cause out-of-order state transitions.

    • Fixed a proxy crash triggered by abnormal subquery handling logic in data masking scenarios.

    • Fixed a proxy crash when pulling binary logs through a cluster endpoint. Legitimate packets larger than 16 MB were misidentified as error packets.

    • Fixed a connection reuse failure during the transaction-level connection pool handshake when the client specified an invalid character set number.

    • Fixed incorrect query routing where EXPLAIN SELECT statements were sent to columnstore index read-only nodes when the cluster endpoint had no row-store read-only (RO) nodes available.

    • Fixed an issue where DECIMAL(m,n) in CONVERT functions was misidentified as a user-defined function, causing read requests to be incorrectly sent to the primary node.

    • Fixed inaccurate average request latency metrics on the PolarProxy monitoring page in the console when broadcast commands such as PING accounted for a high proportion of traffic.

  • 2.9.20 (Released on: 2026-04-03)

    Category

    Description

    Bug Fixes

    • Fixed a proxy crash issue introduced in version 2.9.17. When a binlog session was established via a PolarDB read/write splitting endpoint, if the first binlog packet exceeded 16 MB and the byte at the packet splitting position had a value of 0xFF, the proxy could misinterpret the normal packet as an error packet and crash during parsing.

  • 2.9.19 (Released on: 2025-12-25)

    Category

    Description

    Performance Optimizations

    • Optimized the internal execution flow for Prepared Statements.

    Bug Fixes

    • Fixed a memory leak that occurred when executing a binary PREPARE statement with a hint on a cluster endpoint that includes a columnstore index read-only node.

    • Fixed an issue where a session could hang and fail to terminate properly due to a timeout while waiting for client authentication information.

    • Fixed a compatibility issue with PolarDB Always-confidential when executing certain SQL statements.

    • Fixed an issue where the DROP TABLE statement could hang when deleting a large number of tables.

  • 2.9.18 (Released on: 2025-11-19)

    Category

    Description

    Performance Optimizations

    • Optimized the proxy's health check logic for columnstore index read-only nodes. This enhancement prevents session hangs caused by health check anomalies and improves the stability of analytical queries.

    Bug Fixes

  • 2.9.17 (Released on: 2025-11-07)

    Category

    Description

    Performance Optimizations

    • Optimized routing for Multi-master Cluster (Limitless) Edition. Requests for SHOW TABLE STATUS from db_name statements are routed to a specified read/write (RW) node to ensure data consistency when retrieving table status information.

    • Optimized the read-only transaction processing mechanism. Sessions now remain connected if a node locked for a read-only transaction fails. This improves cluster high availability and business continuity during node failures.

    • Optimized the binlog pull performance for a global database network (GDN). This resolves the issue of slow binlog pulling from the cluster endpoint of a secondary cluster.

      Note

      This optimization is disabled by default. If you require this feature, submit a ticket to have it enabled.

    Bug Fixes

    • Fixed an issue where read-only transactions could cause a cluster to crash in specific scenarios, enhancing overall cluster stability.

    • Fixed an issue where the SQL firewall feature could cause a cluster to crash when processing certain SQL statements, improving cluster stability when the SQL firewall is enabled.

    • Fixed a data decryption failure that occurred after upgrading a PolarProxy to a version between 2.9.12 and 2.9.16 on clusters configured with PolarDB Always-confidential encryption rules.

  • 2.9.16 (Released on: 2025-09-17)

    Category

    Description

    Performance Optimizations

    • Optimized the error message for routing failures that occur when using the /*FORCE_IMCI_NODES*/ hint.

    • Optimized the rule matching logic for the dynamic data masking feature.

    Bug Fixes

    • Fixed a routing issue with SELECT … FOR SHARE statements.

    • Fixed an issue where the SQL parser could not recognize CHARACTER SET when parsing CAST.

    • Fixed an issue where routing binary PREPARE statements in a Multi-master Cluster (Limitless) Edition could cause unexpected disconnections in specific scenarios.

    • Fixed a routing issue with the advanced transaction splitting feature when processing multi-statement scenarios.

    • Fixed unexpected disconnections caused by the overload protection feature in some scenarios.

    • Fixed an issue where a persistent connection could cause errors in XA requests.

  • 2.9.15 (Released on: 2025-07-17)

    Category

    Description

    New Features

    Added support for configuring global consistency separately on read-only endpoints where the Load balancing policy is set to Active Request-based Load Balancing.

    Performance Optimizations

    Bug Fixes

    • Fixed an issue in global consistency (high-performance mode) where a client might receive an error. This occurred when the timeout configuration was changed from 0, Send the request to the primary node (default) to 2, Timeout and downgrade (if a global consistency read times out, the query is automatically downgraded to a non-consistent read, and the client does not receive an error message).

    • Fixed an issue where a slow query in a PREPARE statement with a /*FORCE_MASTER*/ hint was not correctly routed to a columnstore index read-only node for execution.

    • Fixed high query response times (RT) in low-concurrency scenarios under global consistency (traditional mode).

    • Fixed an issue in a Multi-master Cluster (Limitless) Edition where concurrently executing CREATE DATABASE statements on multiple nodes to create a database with the same name could cause the command to fail due to conflicts.

    • Fixed an issue in a Multi-master Cluster (Limitless) Edition where the MySQL parser could cause a service crash when processing CREATE TABLE statements, enhancing system stability.

  • 2.9.13 (Released on: 2025-05-22)

    Category

    Description

    Bug Fixes

    Fixed an issue where CPU utilization monitoring displayed inaccurate results.

  • 2.9.12 (Released on: 2025-05-15)

    Category

    Description

    New Features & Performance Optimizations

    • Optimized global consistency (high-performance mode) by changing its scope from system-level to connection-level, making it configurable for each PolarProxy endpoint.

    • Optimized the persistent connection switching process.

    • Optimized SQL parsing.

    • Optimized the transaction-level connection pool.

    • Optimized statistical metrics.

    Bug Fixes

    • Fixed Orca (Redis-compatible) Scan command node binding issues and related unexpected disconnections due to wait timeout.

    • Fixed an issue where the last_used command caused on-demand connections to disconnect.

    • Fixed a routing error in a Multi-master Cluster (Limitless) Edition when SET autocommit=0 or SET autocommit=1 was used in multi-statement transactions.

    • Fixed a compatibility issue between the transaction-level connection pool and HTAP.

    • Fixed an issue where read-only transactions did not meet consistency requirements.

    • Fixed compatibility issues with some drivers.

    • Fixed an issue where connection reuse could select the wrong database in certain scenarios when the transaction-level connection pool was enabled.

  • 2.9.10 (Released on: 2025-02-14)

    Category

    Description

    Bug Fixes

    • Fixed a query routing error for temporary tables created with the CREATE TEMPORARY TABLE * AS SELECT * FROM * statement.

    • Fixed an execution error for XA transactions on read-only endpoints configured with load balancing based on the number of active requests.

    • Fixed a routing error for XA transactions in a Multi-master Cluster (Limitless) Edition.

    • Fixed table creation errors in some scenarios in a Multi-master Cluster (Limitless) Edition.

    • Fixed an error that occurred on read-only endpoints configured with load balancing based on the number of active requests. The error was caused by using the force_master or force_node hint to specify the primary node.

    • Fixed an issue where a session was unexpectedly disconnected after the wait_timeout period expired when pulling binlogs from a cluster endpoint.

  • 2.9.8 (Released on: 2024-11-25)

    Category

    Description

    New Features & Performance Optimizations

    • Added support for routing requests that contain built-in GIS functions, such as ST_Distance_Sphere, to read-only nodes.

    • Added support for configuring timeout policies for global consistency (high-performance mode): forward to the primary node, report an error, or downgrade.

    • Added support for global consistency in Multi-master Cluster (Limitless) Edition.

    • Added support for selecting specific primary nodes for custom endpoints.

    • Optimized the load balancing capability for read-only nodes in Multi-master Cluster (Limitless) Edition.

    Bug Fixes

    • Fixed an issue that could cause a proxy out-of-memory (OOM) error in high-concurrency data read scenarios.

    • Fixed an issue where transaction resumption failed in some scenarios.

    • Fixed an issue where accounts using caching_sha2_password were not compatible with the pymysql driver.

    • Fixed an issue where the force_node hint became invalid during a primary/secondary failover.

    • Fixed a crash issue caused by proxy exceptions in some Multi-master Cluster (Limitless) Edition scenarios.

    • Fixed an issue where the proxy incorrectly identified the Standby role in some Multi-master Cluster (Limitless) Edition scenarios.

    • Fixed an issue where a primary/secondary failover could cause connection reuse to select the wrong database after the transaction-level connection pool was enabled.

  • 2.9.4 (Released on: 2024-08-29)

    Category

    Description

    New Features & Performance Optimizations

    Always-confidential encryption now supports key updates.

    Bug Fixes

    • Fixed an issue where accessing a temporary table created in a stored procedure failed.

    • Fixed an issue where CREATE TABLE LIKE and RENAME TABLE statements failed to execute in a Multi-master Cluster (Limitless) Edition.

    • Fixed slow request responses in high-concurrency scenarios for PolarDB for AI.

    • Fixed proxy blocking and restart issues in some scenarios.

  • 2.9.2 (Released on: 2024-07-29)

    Category

    Description

    New Features & Performance Optimizations

    • Added support for MySQL 8.0 caching_sha2_password authentication.

    • Added support for using wildcards in encryption rules.

    • Optimized the routing policy for statements related to Global Transaction Identifiers (GTIDs).

    • Added support for JSON syntax using ->> or ->.

    Bug Fixes

    • Fixed an issue where thread ID rotation in short-lived connection scenarios occasionally caused connection establishment to fail.

    • Fixed an error with nested transactions in multi-statement queries.

    • Fixed proxy exceptions caused by parsing failures for some specific SQL statements.

  • 2.8.47 (Released on: 2024-12-02)

    Category

    Description

    New Features & Performance Optimizations

    Added support for routing requests that contain built-in GIS functions, such as ST_Distance_Sphere, to read-only nodes.

    Bug Fixes

    • Fixed an issue that could cause a proxy out-of-memory (OOM) error in high-concurrency data read scenarios.

    • Fixed an issue where transaction resumption failed in some scenarios.

    • Fixed an issue where a primary/secondary failover could cause connection reuse to select the wrong database after the transaction-level connection pool was enabled.

  • 2.8.46 (Released on: 2024-09-13)

    Category

    Description

    New Features & Performance Optimizations

    • Optimized download throughput for cross-region access or in extreme network conditions.

    • Optimized the routing for SELECT information_schema.processlist. Requests are now routed to the primary node by default to prevent gh-ost lock-free schema migration failures.

    Bug Fixes

    • Fixed slow requests on read-only endpoints connected to only one read-only (AP) node.

    • Fixed an issue where incorrect routing of a user variable caused an Illegal mix of collations error in the application.

  • 2.8.45 (Released on: 2024-07-19)

    Category

    Description

    New Features & Performance Optimizations

    • Optimized read-after-write splitting for transactions in some scenarios.

    • Optimized persistent connections in some scenarios.

    • Optimized the processing of non-business data packets for data masking and encryption.

    Bug Fixes

    • Fixed on-demand connection establishment failures in some scenarios.

    • Fixed a compatibility issue between on-demand connection establishment and automatic request distribution between row and column stores.

    • Fixed incorrect request routing for automatic request distribution between row and column stores in some scenarios.

    • Fixed an issue where the proxy unexpectedly restarted during data decryption or encryption.

    • Fixed an issue where overload protection did not recover promptly in specific scenarios, causing slow request responses.

    • Fixed unexpected disconnections that occurred when executing a binlog dump command on a cluster endpoint.

    • Fixed incorrect request routing for multi-statement queries that use temporary tables.

    • Fixed a compatibility issue with read-only endpoints that use connection-based load balancing in some scenarios.

    • Fixed an issue where the transaction-level connection pool was not reused correctly in COM_RESET_CONNECTION scenarios.

    • Fixed an issue that unexpectedly routed requests to the primary database under global consistency.

    • Fixed a potential connection leak in the proxy caused by frequent use of the KILL CONNECTION command.

    • Fixed an issue that could cause connection blocking in some scenarios.

  • 2.8.35 (Release date: 2024-02-26)

    Category

    Description

    New features and performance optimizations

    Bug fixes

    • Fixed a disconnection issue with binlog_dump when BINLOG_DUMP_NON_BLOCK is enabled.

    • Fixed an issue where some database connections were blocked for extended periods in certain scenarios when automatic traffic redirection was enabled.

    • Fixed a potential error when using SET OPTION with the session-level connection pool.

    • Fixed an issue that could cause connection blocking in certain scenarios when using STMT_SEND_LONG_DATA.

    • Fixed an issue where some persistent connections failed to exit as expected.

    • Fixed an issue where some monitoring metrics were inaccurate in certain scenarios.

    • Fixed an issue that caused exceptions on some proxy nodes.

  • 2.8.28 (Release date: 2024-01-08)

    Category

    Description

    New features and performance optimizations

    • Supports intra-transaction traffic distribution for cluster endpoints using automatic traffic redirection when their Read-write mode is set to Read-only and their Load balancing policy is set to Active Request-based Load Balancing.

    • In automatic traffic redirection mode, deleting an AP node now affects existing connections.

    • Supports configuring server weights at the endpoint level.

    • Optimized persistent connection scenarios.

    • SSL supports only TLS 1.2.

    Bug fixes

    • Fixed an issue that caused clients to receive error code 9000 when using automatic traffic redirection with PolarDB for MySQL 8.0.2.

    • Fixed an issue where SQL statements containing special syntax caused clients to receive error code 9000 during automatic traffic redirection.

    • Fixed an issue where the EXPLAIN SELECT operation failed in some scenarios.

    • Fixed an issue that briefly blocked user requests when a read-only node was deleted in some scenarios.

    • Fixed an issue where connections could become unresponsive in some scenarios when using the transaction-level connection pool.

    • Fixed an issue that caused exceptions on some proxy nodes.

    • Fixed an issue where automatic traffic redirection caused proxy exceptions or unresponsive connections in some scenarios when the cluster endpoint's Consistency level was set to Session consistency or Global consistency.

    • Fixed a routing error caused by temporary tables in SQL statements.

  • 2.8.25 (Release date: 2023-08-30)

    Category

    Description

    New features and performance optimizations

    Optimized persistent connection scenarios.

    Bug fixes

    • Fixed an issue where internal keepalive messages or large packets could cause user sessions to hang.

    • Fixed an issue where SELECT statements with custom variables were routed to the primary database.

    • Fixed an issue where multi-statement queries with comments were routed to read-only nodes.

  • 2.8.24 (Release date: 2023-08-08)

    Category

    Description

    New Features & Performance Optimizations

    Optimized the logic for the internal monitor detection template.

    Bug Fixes

    • Fixed an issue where SHOW WARNINGS would time out and fail on read-only endpoints.

    • Fixed a PolarProxy exception that occurred when the transaction-level connection pool was enabled.

  • 2.8.21 (Release date: 2023-06-25)

    Category

    Description

    New Features & Performance Optimizations

    • Optimized the performance of some internal modules.

    • Added support for routing EXPLAIN SELECT statements to read-only nodes.

    • Added support for routing SHOW STATUS statements to the previous node.

    • Added support for query encryption.

    Bug Fixes

    • Fixed an issue where a session could hang when an AP node was restarted while automatic request distribution for row and column stores was enabled.

    • Fixed an issue where a session could hang when a node was restarted while parallel query was enabled.

    • Fixed an issue where OPTIMIZE statements were incorrectly routed to a read-only node.

    • Fixed an issue where parsing errors in some WITH ... SELECT scenarios caused requests to be routed to the primary node.

    • Fixed an issue where the polar_proxy_encode database was unexpectedly visible to users.

    • Fixed request response time (RT) jitter that occurred when a read-only node was added.

    • Fixed an issue that prevented dynamic data masking from taking effect.

    • Fixed various exceptions on proxy nodes.

  • 2.8.12 (Release date: 2023-03-01)

    Category

    Description

    New Features & Performance Optimizations

    Improved the performance of short-lived connections by 10%.

    Bug Fixes

    • Fixed an issue where ROW_NUMBER() was routed to the primary node.

    • Fixed various PolarProxy exceptions.

    • Fixed an issue where a read-only node exception caused a PolarProxy monitor detection failure, which led to user disconnections.

    • Fixed an issue where using PREPARE and EXECUTE failed when automatic request distribution for row stores was enabled.

    • Fixed an issue that prevented dynamic data masking from taking effect.

  • 2.8.11 (Release date: 2023-02-22)

    Category

    Description

    New Features & Performance Optimizations

    Automatic request distribution for row and column stores now supports transactions, session consistency, and global consistency.

    Bug Fixes

    • Fixed a routing error for SQL statements that contain temporary tables and are longer than 64 KB.

    • Fixed an issue where the transaction state was lost during transaction splitting, which caused transient disconnections for PHP 8.0 clients.

    • Fixed an authentication failure on read-only endpoints.

    • Fixed a connection establishment failure when using the session-level connection pool.

  • 2.8.8 (Release date: 2022-12-15)

    Category

    Description

    New Features & Performance Optimizations

    • Read/write splitting now supports weight-based dynamic load balancing. For more information, see Weight-based dynamic load balancing.

    • Read-only endpoints now support request-level load balancing.

    • In HTAP scenarios, automatic request distribution for row and column stores now supports routing transactional processing (TP) requests to AP nodes.

    • Changes to the Elastic Parallel Processing (EPP) setting now take effect on existing connections.

    Bug Fixes

    Fixed an issue that caused connections to terminate.

  • 2.8.3 (Release date: 2022-11-04)

    Category

    Description

    New Features & Performance Optimizations

    • Added support for overload protection.

    • Added support for readable hot replicas.

    Bug Fixes

    • Fixed unexpected disconnections in multi-statement queries when using automatic request distribution for row and column stores in HTAP scenarios.

    • Fixed several internal exceptions that caused response time (RT) jitter.

  • 2.7.9 (Release date: 2022-08-01)

    Category

    Description

    New Features & Performance Optimizations

    Bug Fixes

    • Fixed an issue in the session-level connection pool where environment variables were lost on newly added database nodes, which led to inconsistent states.

    • Fixed an incorrect routing issue for UPDATE statements when a read-only transaction was enabled in a multi-statement scenario.

    • Fixed an incorrect routing issue for COM_STMT_FETCH in consistency scenarios.

  • 2.7.5 (Release date: 2022-07-15)

    Category

    Description

    New Features & Performance Optimizations

    • The sql firewall feature now supports SHOW syntax.

    • Added support for read/write cluster endpoints.

    Bug Fixes

    • Fixed an issue that prevented the Accept Reads on Primary Node feature from applying to existing connections.

    • Fixed several internal exceptions.

  • 2.4.35 (Release date: 2022-07-05)

    Category

    Description

    Bug Fixes

    • Fixed a session exception that occurred when a SET request was received during a primary node restart while persistent connections were enabled.

    • Fixed several issues with inaccurate internal monitoring and diagnostic tools.

  • 2.4.33 (Release date: 2022-05-07)

    Category

    Description

    Bug Fixes

    • Fixed an issue in the transaction-level connection pool where environment variables were not replayed, which caused incorrect connection reuse in sessions.

    • Fixed an error that occurred when executing prepare exec with HTAP automatic load balancing.

    • Fixed an issue where the transaction state in the packet status was lost due to transaction splitting. This issue might affect PHP 8.0 clients.

    • Fixed various PolarProxy exceptions.

  • 2.4.30 (Release date: 2022-03-08)

    Category

    Description

    New Features & Performance Optimizations

    Optimized the session consistency level.

    Bug Fixes

    • Fixed routing errors with automatic request distribution for row and column stores in HTAP scenarios.

    • Fixed a PolarProxy exception that occurred when the proxy specifications exceeded 32 cores.

    • Fixed a condition that could cause PolarProxy to crash.

    • Fixed an incorrect routing issue with PREPARE SELECT ... FOR UPDATE in specific scenarios.

  • 2.4.27 (Release date: 2021-12-30)

    Category

    Description

    New Features & Performance Optimizations

    Added support for automatic request distribution for row and column stores.

    Bug Fixes

    • Fixed an issue where KILL SESSION failed.

    • Fixed an issue where COM_STMT_EXECUTE failed when parameter types were frequently modified.

    • Fixed an issue where read requests were incorrectly routed to a read-only node after SELECT ... FOR UPDATE was executed within a transaction.

    • Fixed an issue where new connections created during a primary node restart failed to insert special characters of the utf8mb4 type.

    • Fixed a session consistency issue where the latest data could not be read after a transaction was committed.

  • 2.4.22 (Release date: 2021-09-10)

    Category

    Description

    Bug Fixes

    • Fixed an issue where PolarProxy did not properly close prepared statements, which led to high database memory usage.

    • Fixed persistent connection failures.

    • Fixed a PolarProxy exception that occurred when the default cluster endpoint was changed to read-only mode.

    • Fixed a condition that could cause PolarProxy to crash.

  • 2.4.18 (Release date: 2021-08-12)

    Category

    Description

    Bug Fixes

    • Fixed a garbled text issue in JDBC applications that did not specify a character set. The issue occurred during a node restart or an account authentication failure.

    • Fixed connection failures for Flink clients.

    • Fixed routing errors for temporary tables.

  • 2.4.17 (Release date: 2021-07-14)

    Category

    Description

    New Features & Performance Optimizations

    • PolarDB for MySQL 5.7 now supports persistent connections for transactions in failover scenarios.

    • Added internal monitoring metrics.

    Bug Fixes

    • Reduced long response times during MySQL account authentication failures.

    • Optimized connection establishment to quickly bypass an abnormal read-only node.

    • Fixed connection failures when parallel query was enabled on a read-only endpoint.

    • Fixed a routing error for CURRENT_TIMESTAMP.

    • Fixed an incorrect routing issue for FOR UPDATE statements.

    • Fixed a routing error caused by an incorrect syntax analysis of @a in a JOIN clause.

    • Fixed authentication failures for MySQL 8.0 clients that used an empty password.

    • Fixed an issue where some named PREPARE statements failed to execute.

  • 2.4.12 (Release date: 2021-05-20)

    Category

    Description

    New Features & Performance Optimizations

    Added support for dynamic data masking.

    Bug Fixes

    Fixed various PolarProxy exceptions.

  • 2.4.7 (Release date: 2021-03-15)

    Category

    Description

    New Features & Performance Optimizations

    Added support for persistent connections.

    Bug Fixes

    Fixed an incorrect routing issue for LOCK IN SHARE MODE.

PolarProxy 1.x.x release notes

Note

The following list includes only the mainstream versions of PolarProxy. Your version number may not appear in this list.

  • 1.13.42 (Release Date: 2022-12-15)

    Category

    Description

    Bug fixes

    • Fixed connection failures caused by an excessive number of database connections.

    • Fixed response time (RT) jitter caused by internal scheduled tasks.

  • 1.13.39 (Release Date: 2022-07-20)

    Category

    Description

    New features and performance optimizations

    • Improved PolarProxy performance when handling high volumes of failed authentications.

    • Optimized the account authentication feature. Changed the rate limiting granularity for failed account authentications from global to account-level.

    Bug fixes

    • Fixed an issue where transaction state was lost during transaction splitting.

    • Fixed an issue where environment variables were not replayed in the transaction-level connection pool.

    • Fixed an issue where prepared statements failed to close in XA transactions.

    • Fixed several internal exceptions.

  • 1.13.34 (Release Date: 2022-03-03)

    Category

    Description

    New features and performance optimizations

    • Added support for the MySQL utf8mb3 encoding format.

    • Improved session consistency.

    Bug fixes

    Fixed an incorrect routing issue for SELECT ... FOR UPDATE statements caused by an excessive number of prepared statement parameters.

  • 1.13.30 (Release Date: 2021-12-30)

    Category

    Description

    Bug fixes

    Fixed an issue that prevented reading the latest committed data after a transaction with session consistency was committed.

  • 1.13.27 (Release Date: 2021-11-16)

    Category

    Description

    Bug fixes

    • Fixed SSL compatibility issues with some clients.

    • Optimized the proxy's parsing performance for INSERT statements.

  • 1.13.25 (Release Date: 2021-08-18)

    Category

    Description

    Bug fixes

    • Fixed a proxy memory leak caused by MySQL account authentication failures.

    • Fixed a proxy crash in multi-endpoint scenarios.

  • 1.13.22 (Release Date: 2021-07-21)

    Category

    Description

    New features and performance optimizations

    • Added support for SELECT LAST_INSERT_ID() when the transaction-level connection pool is enabled.

    • Added support for the FOUND_ROWS() function when the transaction-level connection pool is enabled.

    • Added support for routing the COM_STATISTICS protocol to read-only nodes.

    • Optimized the transaction-level connection pool.

    • Optimized global consistency. Requests can be routed to a read-only node if at least one read-only node meets the consistency requirements.

    • Added support for routing GEO functions to read-only nodes.

    • Added internal monitoring metrics.

    Bug fixes

    • Fixed routing errors caused by incorrect parsing of some SQL statements.

    • Fixed an issue where stmt_exec() failed after stmt_long_data() was executed in specific scenarios.

    • Fixed a LOAD DATA INFILE execution failure.

  • 1.13.5 (Release Date: 2020-12-01)

    Category

    Description

    New features and performance optimizations

    • Eventual consistency now supports transaction splitting.

    • Added support for the following HINT syntax:

      • force node connection /*force_proxy_internal*/set force_node = 'pi-aaaaaaaaa';

        All subsequent requests on this connection are sent only to the node pi-aaaaaaaaa. If this node is unhealthy, PolarProxy reports the error message set force node 'pi-aaaaaaaaa' is not found, please check..

      • force node query /*force_node='pi-aaaaaaaa'*/ show processlist;

        This request is executed only on the pi-aaaaaaaa node. If this node is unhealthy, PolarProxy reports the error message 'force hint server node is not found, please check.'.

    • Added internal monitoring metrics.

    Bug fixes

    • Fixed an issue where the select type, status, mode, where gtx_id = '4' FOR UPDATE; statement was routed to a read-only node because it contained the mode keyword.

    • Fixed a load imbalance issue under specific conditions.

    • Fixed a potential stmt_close failure in PREPARE scenarios.

  • 1.12.10 (Release Date: 2020-10-19)

    Category

    Description

    Bug fixes

    • Fixed an SSL connection establishment exception for MySQL 8.0.

    • Fixed an issue where PolarProxy failed to handle new requests to a database node after its status changed from DOWN to RUNNING.

  • 1.12.7 (Release Date: 2020-08-06)

    Category

    Description

    New features and performance optimizations

    • Added support for SHOW FULL PROCESSLIST syntax.

    • Added support for XA transaction syntax.

    Bug fixes

    • Fixed several issues with the transaction-level connection pool.

    • Fixed issues with accessing read-only nodes in a GDN.

    • Fixed an error when executing the SHOW PROCESSLIST command in MySQL 8.0.

    • Fixed several connection establishment failures.

  • 1.11.12 (Release Date: 2020-06-22)

    Category

    Description

    New features and performance optimizations

    • Added support for the transaction-level connection pool.

    • PolarDB for MySQL 8.0 read-only endpoints now support parallel query.

  • 1.10.7 (Release Date: 2020-03-18)

    Category

    Description

    New features and performance optimizations

    Added support for global consistency.

    Bug fixes

    Fixed an exception when initializing system environment variables in the session-level connection pool.

  • 1.9.23 (Release Date: 2020-02-21)

    Category

    Description

    New features and performance optimizations

    • Added support for connecting to a cluster with a root account.

    • Added support for SSL encryption.

    Bug fixes

    • Fixed a CHANGE USER failure.

    • Fixed a LOAD FILE failure.

    • Fixed an issue where an application reported an Exception: Packets out of order error after it received a message with an incorrect sequence.

    • Fixed an issue that caused read-only endpoints to disconnect when the primary node became unavailable.

  • 1.9.14 (Release Date: 2019-12-24)

    Category

    Description

    New features and performance optimizations

    • Added support for HINT syntax, such as /*FORCE_SLAVE*/ and /*FORCE_MASTER*/.

    • Enabled the primary database to accept read requests.

    Bug fixes

    • Fixed garbled characters caused by an incorrect default charset value.

    • Fixed an issue where an incorrect MySQL version string was returned.

Upgrade version

If your cluster is not running the latest version of PolarProxy, you can upgrade the proxy as needed. For detailed instructions, see Manually upgrade the version.