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.
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.
csmon
monitor has been dropped.Was deprecated in 22.08.2.
auroramon
monitor has been dropped.maxctrl cluster
commands have been removed.Was deprecated in 22.08.2.
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 resourcedocumentation.
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 newDELETE /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 resourcedocumentation.
MaxScale can read an inbound proxy protocol header and relay the information to backends. See here for more information.
These commands backup and restore database contents to/from an external drive. See monitor documentation for more information.
It is now possible to change at runtime the number of threads MaxScale uses for routing client traffic. Seehere for more information.
Some configuration parameters, most notable therules, can now be changed at runtime.
The REST-API calls to MaxScale can now be logged. Seehere for more information.
Authentication can be enabled when Redis is used as the cache storage. Seehere for more information.
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. Seehere for more information.
maxctrl (list|show) sessions
and MaxGUI now show for each session ani/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.
MariaDB Server ed25519 authentication plugin support added. Seehere for more information.
The maxctrl list
and show
commands now display timestamps using the
locale and timezone of the client computer.
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-4490 Query Editor - A query tab becomes unusable when a connection is not successfully reconnected.
There are some limitations and known issues within this version of MaxScale. For more information, please refer to the Limitations document.
RPM and Debian packages are provided for the supported Linux distributions.
Packages can be downloaded here.
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.
This page is licensed: CC BY-SA / Gnu FDL