The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-12-26. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB MaxScale 23.02 Release Notes -- 2023-02-27

MariaDB MaxScale 23.02 Release Notes -- 2023-02-27

Release 23.02.0 is a Beta release.

This document describes the changes in release 23.02, when compared to release 22.08.

For any problems you encounter, please consider submitting a bug report on our Jira.

Changed Features

MariaDBMonitor

MariaDBMonitor now preserves the MASTER_USE_GTID-setting of a replica when redirecting one during switchover and failover. When starting a new replication connection on a previous replica, Slave_Pos is used. When starting a new replication connection on a previous primary, Current_Pos is used.

Dropped Features

The csmon monitor has been dropped.

Was deprecated in 22.08.2.

The auroramon monitor has been dropped.

maxctrl cluster commands have been removed.

Was deprecated in 22.08.2.

New Features

REST-API

ODBC Type SQL Connections

The POST /sql REST-API endpoint can now use an ODBC driver to connect to an external data source. To make the use of these new ODBC connections easier, a new endpoint for canceling active queries was added. The POST /sql/:id/cancel endpoint will interrupt the ongoing operation on the given connection.

For more information on how ODBC type connections differ from native MariaDB connections, refer to the SQL resource documentation.

Asynchronous Query API

The POST /sql/:id/queries now supports the async=true request option. When enabled, the results of the query will be delivered asynchronously via the newly added GET /sql/:id/queries/:query_id endpoint.

To make the use of the API easier, the latest asynchronous query result can be retrieved multiple times. Results can also be explicitly discarded with the new DELETE /sql/:id/queries/:query_id endpoint.

MXS-2709 ETL/Data Migration Service

The newly added ODBC type connections can be used with the new /sql/:id/etl endpoints to perform data migration operations from external ODBC data sources into MariaDB. The initial version supports MariaDB-to-MariaDB and PostgreSQL-to-MariaDB migrations as well as generic migrations done via the ODBC catalog functions.

For more information on the new API functions, refer to the SQL resource documentation.

MXS-3003 Support inbound proxy protocol

MaxScale can read an inbound proxy protocol header and relay the information to backends. See here for more information.

MXS-3262 Add create-backup and restore-from-backup commands to MariaDB-Monitor

These commands backup and restore database contents to/from an external drive. See monitor documentation for more information.

MXS-3269 Make it possible to change at runtime the number of threads used by MaxScale

It is now possible to change at runtime the number of threads MaxScale uses for routing client traffic. See here for more information.

MXS-3708 Cache runtime modification

Some configuration parameters, most notable the rules, can now be changed at runtime.

MXS-3827 Audit log for the REST API

The REST-API calls to MaxScale can now be logged. See here for more information.

MXS-4106 Redis authentication

Authentication can be enabled when Redis is used as the cache storage. See here for more information.

MXS-4107 TLS encrypted Redis connections

SSL/TLS can now be used in the communication between MaxScale and the Redis server when the latter is used as the storage for the cache. See here for more information.

MXS-4182 Session load indicator

maxctrl (list|show) sessions and MaxGUI now show for each session an i/o activity number that gives an indication of the load of a particular session. The number is the count of I/O operations performed for the session during the previous 30 seconds.

MXS-4270 ed25519 authentication support

MariaDB Server ed25519 authentication plugin support added. See here for more information.

MXS-4320 Let maxctrl show datetime values using local client timezone

The maxctrl list and show commands now display timestamps using the locale and timezone of the client computer.

MXS-4330 Xpand parallel replication does not work with maxscale

MaxGUI

Numerous additions have been added and improvements made to MaxGUI. The most notable ones are listed here:

  • MXS-4013 Add Views, Functions, and Indexes to the Query Editor schema sidebar.
  • MXS-4285 Store user preferences.
  • MXS-4430 ETL/Data Migration service GUI. Instructions on using it can be found here

Bug fixes

  • MXS-4490 Query Editor - A query tab becomes unusable when a connection is not successfully reconnected.

Known Issues and Limitations

There are some limitations and known issues within this version of MaxScale. For more information, please refer to the Limitations document.

Packaging

RPM and Debian packages are provided for the supported Linux distributions.

Packages can be downloaded here.

Source Code

The source code of MaxScale is tagged at GitHub with a tag, which is identical with the version of MaxScale. For instance, the tag of version X.Y.Z of MaxScale is maxscale-X.Y.Z. Further, the default branch is always the latest GA version of MaxScale.

The source code is available here.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.