All pages
Powered by GitBook
1 of 32

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

MariaDB MaxScale 2.5 Release Notes

Learn about the new features, bug fixes, and changes in MariaDB MaxScale 2.5 releases. This section provides detailed release notes for these specific versions.

MariaDB MaxScale 2.5.29 Release Notes

Release 2.5.29 is a GA release.

Released: 25 Oct 2023

This document describes the changes in release 2.5.29, when compared to the previous release in the same series.

If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

External CVEs resolved.

  • Fixed by Update pcre2 to 10.42

  • Fixed by Update pcre2 to 10.42

  • Fixed by Update pcre2 to 10.42

  • Fixed by Update pcre2 to 10.36

  • Fixed by Update pcre2 to 10.36

  • Fixed by Update pcre2 to 10.36

  • Fixed by Update libhiredis to 1.0.2.

  • Fixed by Update libmicrohttpd to version 0.9.76

Bug fixes

  • MaxScale does not always report the OS version correctly

  • GUI caching issue

  • log_throttling should be disabled if log_info is on

  • log_throttling is hard to modify via MaxCtrl

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 supported the Linux distributions.

Packages can be downloaded .

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 .

MXS-4738 The fact that disable_master_failback does not work with root_node_as_master is not documented

  • MXS-4735 Connection IDs are missing from error messages

  • MXS-4724 slave_selection_criteria should accept lowercase version of the values

  • MXS-4717 information_schema is not invalidated as needed

  • MXS-4706 Cache does not invalidate when a table is ALTERed, DROPed or RENAMEd

  • CVE-2022-1586
    MXS-4806
    CVE-2022-1587
    MXS-4806
    CVE-2022-41409
    MXS-4806
    CVE-2017-7186
    MXS-4804
    CVE-2017-8399
    MXS-4804
    CVE-2017-8786
    MXS-4804
    CVE-2020-7105
    MXS-4757
    CVE-2023-27371
    MXS-4751
    MXS-4807
    MXS-4756
    MXS-4749
    MXS-4747
    here
    here

    MaxScale 2.5 Limitations and Known Issues

    This document lists known issues and limitations in MariaDB MaxScale and its plugins. Since limitations are related to specific plugins, this document is divided into several sections.

    • Limitations and Known Issues within MariaDB MaxScale

      • Configuration limitations

        • Multiple MaxScales on same server

      • Security limitiations

        • MariaDB 10.2

      • MariaDB Default Values

      • Query Classification

      • Prepared Statements

      • Protocol limitations

        • Limitations with MySQL/MariaDB Protocol support (MariaDBClient)

      • Authenticator limitations

        • Limitations in the GSSAPI authenticator

        • Limitations in the MySQL authenticator (MariaDBAuth)

      • Filter limitations

        • Database Firewall limitations (dbfwfilter)

        • Tee filter limitations (tee)

      • Monitor limitations

        • Limitations with Galera Cluster Monitoring (galeramon)

      • Router limitations

    Configuration limitations

    In versions 2.1.2 and earlier, the configuration files are limited to 1024 characters per line. This limitation was increased to 16384 characters in MaxScale 2.1.3. MaxScale 2.3.0 increased this limit to 16777216 characters.

    In versions 2.2.12 and earlier, the section names in the configuration files were limited to 49 characters. This limitation was increased to 1023 characters in MaxScale 2.2.13.

    Multiple MaxScales on same server

    Starting with MaxScale 2.4.0, on systems with Linux kernels 3.9 or newer due to the addition of SO_REUSEPORT support, it is possible for multiple MaxScale instances to listen on the same network port if the directories used by both instances are completely separate and there are no conflicts which can cause unexpected splitting of connections. This will only happen if users explicitly tell MaxScale to ignore the default directories and will not happen in normal use.

    Security limitiations

    MariaDB 10.2

    The parser of MaxScale correctly parses WITH statements, but fails to collect columns, functions and tables used in the SELECT defining the WITH clause.

    Consequently, the database firewall will not block WITH statements where the SELECT of the WITH clause refers to forbidden columns.

    MariaDB Default Values

    MaxScale assumes that certain configuration parameters in MariaDB are set to their default values. These include but are not limited to:

    • autocommit: Autocommit is enabled for all new connections.

    • tx_read_only: Transactions use READ WRITE permissions by default.

    Query Classification

    Follow the Jira issue to track the progress on this limitation.

    XA transactions are not detected as transactions by MaxScale. This means that all XA commands will be treated as unknown commands and will be treated as operations that potentially modify the database (in the case of readwritesplit, the statements are routed to the master).

    MaxScale will not track the XA transaction state which means that any SELECT queries done inside an XA transaction can be routed to servers that are not part of the XA transaction.

    This limitation can be avoided on the client side by disabling autocommit before any XA transactions are done. The following example shows how a simple XA transaction is done via MaxScale by disabling autocommit for the duration of the XA transaction.

    Prepared Statements

    For its proper functioning, MaxScale needs in general to be aware of the transaction state and autocommit mode. In order to be that, MaxScale parses statements going through it.

    However, if a transaction is commited or rolled back, or the autocommit mode is changed using a prepared statement, MaxScale will miss that and its internal state will be incorrect, until the transaction state or autocommit mode is changed using an explicit statement.

    For instance, after the following sequence of commands, MaxScale will still think autocommit is on:

    To ensure that MaxScale functions properly, do not commit or rollback a transaction or change the autocommit mode using a prepared statement.

    Protocol limitations

    Limitations with MySQL/MariaDB Protocol support (MariaDBClient)

    • Compression is not included in the server handshake.

    • If a KILL [CONNECTION] <ID> statement is executed, MaxScale will intercept it. If the ID matches a MaxScale session ID, it will be closed, similarly to how MariaDB does it. If the KILL CONNECTION USER <user> form is given, all connections with a matching username will be closed.

    • MariaDB MaxScale does not support KILL QUERY ID <query_id> type statements. If a query by a query ID is to be killed, it needs to be done directly on the backend databases.

    Authenticator limitations

    Limitations in the GSSAPI authenticator

    Currently, MariaDB MaxScale only supports GSSAPI authentication when the backend connections use GSSAPI authentication. Client side GSSAPI authentication with a different backend authentication module is not supported.

    Limitations in the MySQL authenticator (MariaDBAuth)

    • MySQL old style passwords are not supported. MySQL versions 4.1 and newer use a new authentication protocol which does not support pre-4.1 style passwords.

    • When users have different passwords based on the host from which they connect MariaDB MaxScale is unable to determine which password it should use to connect to the backend database. This results in failed connections and unusable usernames in MariaDB MaxScale.

    • Only a subset of netmasks are supported for the Host-column in the mysql.user-table (and related tables). Specifically, if the Host is of the form base_ip/netmask, then the netmask must only contain the numbers 0 or 255. For example, a netmask of 255.255.255.0 is fine while 255.255.255.192 is not.

    Filter limitations

    Database Firewall limitations (dbfwfilter)

    The Database Firewall filter does not support multi-statements. Using them will result in an error being sent to the client.

    Tee filter limitations (tee)

    The Tee filter does not support binary protocol prepared statements. The execution of a prepared statements through a service that uses the tee filter is not guaranteed to succeed on the service where the filter branches to as it does on the original service.

    This possibility exists due to the fact that the binary protocol prepared statements are identified by a server-generated ID. The ID sent to the client from the main service is not guaranteed to be the same that is sent by the branch service.

    Monitor limitations

    A server can only be monitored by one monitor. Two or more monitors monitoring the same server is considered an error.

    Limitations with Galera Cluster Monitoring (galeramon)

    The default master selection is based only on MIN(wsrep_local_index). This can be influenced with the server priority mechanic described in the Galera Monitor manual.

    Router limitations

    Refer to individual router documentation for a list of their limitations.

    MariaDB MaxScale 2.5.13 Release Notes

    Release 2.5.13 is a GA release.

    Released: 4 Jun 2021

    This document describes the changes in release 2.5.13, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    Bug fixes

    • qc_sqlite handles current_timestamp etc. explicitly

    • Maxscale tries to execute write statement on slave

    • query classifier crashes after upgrade from 2.5.11 to 2.5.12

    • [readwritesplit] Failed to execute session command

    • Replicator component doesn't check node state for every operation

    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 supported the Linux distributions.

    Packages can be downloaded .

    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 .

    MariaDB MaxScale 2.5.26 Release Notes

    Release 2.5.26 is a GA release.

    Released: 23 May 2023

    This document describes the changes in release 2.5.26, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    Bug fixes

    MariaDB MaxScale 2.5.14 Release Notes

    Release 2.5.14 is a GA release.

    Released: 21 Jul 2021

    This document describes the changes in release 2.5.14, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    Bug fixes

    MariaDB MaxScale 2.5.23 Release Notes

    Release 2.5.23 is a GA release.

    Released: 28 Nov 2022

    This document describes the changes in release 2.5.23, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    Bug fixes

    MXS-3589
    MXS-3586
    MXS-3585
    MXS-3582
    MXS-3581
    here
    here

    MXS-4615 Partially executed multi-result queries are not treated as partial results

  • MXS-4614 Query classifier does not recognize BEGIN NOT ATOMIC ... END

  • MXS-4611 Readwritesplit prefers idle primary over busy replicas

  • MXS-4586 transaction_replay_max_size default is 1GiB instead of 1MiB

  • MXS-4560 Not all passwords were obfuscated in the maxctrl report

  • MXS-4550 Regular expression documentation is inaccurate and lacking

  • MXS-4502 KB pages reference mysqlauth and mysqlauth is deprecated for mariadbauth

  • 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 supported the 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.

    our Jira

    MXS-3650 Maxscale crashes while logging to GUI

  • MXS-3623 Race condition in persistent connections

  • MXS-3622 Backend connection isn't closed right after authentication failure

  • MXS-3617 writeq throttling can lose response packets

  • MXS-3615 Clarify session_track_system_variables requirement for readwritesplit's causal_reads parameter

  • MXS-3595 Listener subresource returns wrong response on service-listener mismatch

  • MXS-3590 MaxCtrl documentation for the reload command is broken

  • MXS-3588 BULK pipelining error

  • MXS-3578 Unexpected result state when using connection_keepalive

  • MXS-3574 Output examples in the REST API documentation are out of date

  • MXS-2890 5.5.5 prefix is always added even with version_string=8.0.16

  • 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 supported the 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.

    our Jira

    MXS-4348 Full SASL support is not enabled for kafka modules

  • MXS-4317 Smartrouter interrupts the wrong query

  • 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 supported the 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.

    our Jira

    Any KILL commands executed using a prepared statement are ignored by MaxScale. If any are executed, it is highly likely that the wrong connection ends up being killed.

  • The change user command (COM_CHANGE_USER) only works with standard authentication.

  • If a COM_CHANGE_USER succeeds on MaxScale yet fails on the server the session ends up in an inconsistent state. This can happen if the password of the target user is changed and MaxScale uses old user account data when processing the change user. In such a situation, MaxScale and server will disagree on the current user. This can affect e.g. reconnections.

  • MXS-1350
    SET autocommit=0;
    XA START 'MyXA';
    INSERT INTO test.t1 VALUES(1);
    XA END 'MyXA';
    XA PREPARE 'MyXA';
    XA COMMIT 'MyXA';
    SET autocommit=1;
    set autocommit=1
    PREPARE hide_autocommit FROM "set autocommit=0"
    EXECUTE hide_autocommit

    MariaDB MaxScale 2.5.28 Release Notes

    Release 2.5.28 is a GA release.

    Released: 21 Aug 2023

    This document describes the changes in release 2.5.28, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    Bug fixes

    • Case-sensitiveness of enumerations is not documented

    • Galeramon does not update replication lag of replicating servers

    • Implement an option to switch to the old "ping" behaviour in MaxScale

    • Connection init sql file execution can hang

    • qc_sqlite does not properly parse a RENAME statement

    • GTID update may block the REST-API

    • Binlogrouter treats GTID sequences as 32-bit integers

    • Readwritesplit does not detect unrecoverable situations

    • Binlogrouter always opens a new binlog on startup

    • Binlogrouter cannot write binlog files larger than 4GiB

    • Binlogrouter runs out of memory on very large transactions

    • Detect ALTER EVENT failure on MariaDB 11.0

    • Encrypted passwords are persisted in plaintext

    • MaxScale BinlogRouter skips large transactions causing data Inconsistency on attached slave

    • Switchover fails with 'Unknown thread id' error

    • Document grants needed for MariaDB 11.1

    • xpandmon diagnostics are not useful

    • binlogrouter shows MaxScale's binary log coordinates in SHOW SLAVE STATUS

    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 supported the Linux distributions.

    Packages can be downloaded .

    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 .

    MariaDB MaxScale 2.5.24 Release Notes

    Release 2.5.24 is a GA release.

    Released: 4 Jan 2023

    This document describes the changes in release 2.5.24, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    Bug fixes

    • 6.4 no longer provides full certificate chain in TLS HELLO

    • Lost connection to backend server: network error (server1: 104, Connection reset by peer)

    • Maxscale is failing with Resource temporarily unavailable errors

    • Rebalancing is not always initiated from the affected worker/thread

    • Maxscale: KafkaCDC writes to current_gtid.txt causes high disk utilisation.

    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 supported the Linux distributions.

    Packages can be downloaded .

    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 .

    MariaDB MaxScale 2.5.19 Release Notes

    Release 2.5.19 is a GA release.

    Released: 11 Feb 2022

    This document describes the changes in release 2.5.19, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    Bug fixes

    • Rebalancing may cause MaxScale to crash

    • Binlog router appends -BinlogRouter to master version string again and again ...

    • Session capabilities are not frozen on session startup

    • MariaDBMonitor does not log connection error on startup

    • Transaction replay doesn't reset transaction on implicit commit

    • MaxScale stalls and crashes occasionally

    • "transaction" is always parsed as a reserved word

    • Read-only transaction behavior is not documented

    • Xpand monitor doesn't show full configuration in diagnostic output

    • Hang in RoutingWorker::execute_concurrently semaphore.hh:146

    • Shutdown bug

    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 supported the Linux distributions.

    Packages can be downloaded .

    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 .

    MariaDB MaxScale 2.5.22 Release Notes

    Release 2.5.22 is a GA release.

    Released: 11 Oct 2022

    This document describes the changes in release 2.5.22, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    Bug fixes

    MariaDB MaxScale 2.5.5 Release Notes

    Release 2.5.5 is a GA release.

    Released: 21 Oct 2020

    This document describes the changes in release 2.5.5, when compared to the previous release in the same series.

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

    New signature key for the packages

    Now packages are signed by MariaDB Enterprise key. Public key is here

    MariaDB MaxScale 2.5.15 Release Notes

    Release 2.5.15 is a GA release.

    Released: 18 Aug 2021

    This document describes the changes in release 2.5.15, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    Bug fixes

    MariaDB MaxScale 2.5.10 Release Notes

    Release 2.5.10 is a GA release.

    Released: 25 Mar 2021

    This document describes the changes in release 2.5.10, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    Bug fixes

    MXS-4722
    MXS-4721
    MXS-4720
    MXS-4719
    MXS-4714
    MXS-4701
    MXS-4700
    MXS-4696
    MXS-4695
    MXS-4691
    MXS-4690
    MXS-4684
    MXS-4681
    MXS-4677
    MXS-4675
    MXS-4672
    MXS-4664
    MXS-4613
    here
    here
    MXS-4450
    MXS-4440
    MXS-4439
    MXS-4423
    MXS-4404
    here
    here
    MXS-3989
    MXS-3978
    MXS-3973
    MXS-3966
    MXS-3959
    MXS-3958
    MXS-3949
    MXS-3947
    MXS-3932
    MXS-3886
    MXS-3865
    here
    here

    MXS-4332 REST API reports unknown parameters with warnings and not errors

  • MXS-4331 Altering servers fails if SSL is enabled

  • MXS-4321 Error from missing --secure option is not helpful

  • MXS-4313 MaxCtrl misinterprets some arguments

  • MXS-4312 REST API accepts empty resource IDs

  • MXS-4304 MariaDB-Monitor spams log with connection errors if server is both [Maintenance] and [Down]

  • MXS-4283 Race condition in KILL command processing

  • MXS-4279 "sub" field not set for JWTs

  • MXS-4269 UPDATE with user variable modification is treated as a session command

  • MXS-4240 MXS-4239 readconnroute module routing read queries to inconsistent slave node

  • MXS-4239 Maxscale shows replication status as [Slave, Running] even when replication credentials are wrong

  • MXS-4227 MaxCtrl incompatibility with MemoryDenyWriteExecute=true is not documented

  • MXS-4224 connection_timeout not documented to only take effect on the top level service

  • MXS-4209 KILL command doesn't work correctly if persistent connections are enabled

  • MXS-4198 MaxScale fails to validate its own certificate when the chain of trust is unknown to OpenSSL

  • MXS-4196 Readconnroute load balancing behavior is not well documented

  • MXS-4156 Update documentation on required monitor privileges

  • MXS-4148 Log warning if reverse name resolution takes significant time

  • MXS-4094 Allow empty token when client is replying to AuthSwitchRequest

  • 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 supported the 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.

    our Jira

    MXS-3719 Readwritesplit logs wrong warning when replication lag is not available

  • MXS-3704 MaxScale always advertises the SESSION_TRACK capability even with servers that don't support it (XPand)

  • MXS-3703 Requirement to use cluster with xpandmon is not documented

  • MXS-3698 "maxctrl classify" fails with an exception

  • MXS-3695 Causal Consistency with MaxScale's Read/Write Split Router issue

  • MXS-3694 MXS - crash when cache is used with invalidate and hard_ttl

  • MXS-3692 Improve host pattern error message

  • MXS-3679 Mismatching user or source prevents session creation

  • MXS-3674 Deadlock in binlogrouter

  • MXS-3673 Draining servers is not documented

  • MXS-3550 write statistic is incremented for slaves

  • MXS-3532 Do not allow Galera master to be set to Drain

  • MXS-3508 causal_reads=global results in missing data reads

  • MXS-3478 admin_host missed on the static configuration parameters list

  • MXS-3474 Strange persistent pool connection stats

  • MXS-3299 Parse error when connecting (through binlog router) from mysql-connector-j

  • 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 supported the 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.

    our Jira

    MXS-3450 COM_FIELD_LIST is classified as a write

  • MXS-3449 Maxscale sets MASTER_GTID_WAIT timeout to zero, when causal_reads_timeout is less than 1s

  • MXS-3448 Unable to disable maxlog

  • MXS-3445 SET DEFAULT ROLE is not classified as a write

  • MXS-3436 Packet received out-of-order. Expected 1; got 3

  • MXS-3433 Monitor does not set session autocommit if it connects to a server first

  • MXS-3427 The 'INFORMATION_SCHEMA.SESSION_STATUS' feature is disabled; see the documentation for 'show_compatibility_56'

  • 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 supported the 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.

    our Jira
    Bug fixes
    • MXS-3244 Default the binlogrouter master port to 3306 (CHANGE MASTER TO)

    • MXS-3242 Hang on repeated master disconnection

    • MXS-3235 Insertstream streams autocommit inserts

    • MXS-3229 Hang with COM_SET_OPTION

    • Monitor re-uses mysql-handle when using extra-port

    • Crash with LOAD DATA LOCAL INFILE

    • Server SSL configuration cannot be defined at runtime

    • Abort due to double free or corruption after "Write to Client DCB ... state DCB_STATE_POLLING failed"

    • MariadbMon documentation needs to take 10.5 privilege changes into account

    • Write MaxGUI system test

    • Misleading error when SSL not used when it is required

    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 supported the 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.

    our Jira
    MariaDB-Enterprise-GPG-KEY

    MariaDB MaxScale 2.5.25 Release Notes

    Release 2.5.25 is a GA release.

    Released: 30 Mar 2023

    This document describes the changes in release 2.5.25, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    Bug fixes

    • RHEL8 Packages for 23.02.1 and 22.08.5

    • Binlogrouter breaks if event size exceeds INT_MAX

    • Maxscale ignores lower_case_table_names=1 on config file

    • The statement canonicalizer cannot handle comments within statements

    • Wrong server version assumption

    • MaxScale leaks sessions if they are closed when writeq throttling is enabled

    • skip_name_resolve is not modifiable at runtime

    • Uncaught exception in binlogrouter

    • IP wildcard values are not permitted in host values while using data masking

    • Replication breaks if binlogfilter excludes events

    • PHP program reports different collation_connection when connecting via Maxscale

    • Memory leak in smartrouter

    • MaxScale hangs with warning about "Worker 1 attempted to send a message to worker 1"

    • Hang in smartrouter under heavy load

    • Schemarouter routing logic documentation is out of date

    • Improve match/exclude documentation for avrorouter and kafkacdc

    • pinloki_start_stop is unstable

    • The rpl_state in binlogrouter is not atomic

    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 supported the Linux distributions.

    Packages can be downloaded .

    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 .

    MariaDB MaxScale 2.5.27 Release Notes

    Release 2.5.27 is a GA release.

    Released: 27 Jul 2023

    This document describes the changes in release 2.5.27, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    New Features

    • Provide a way to show details about all supported MaxScale modules via REST API and/or MaxCtrl

    Bug fixes

    • REST-API documentation is wrong about which server parameters can be modified

    • The fact that readconnroute doesn't block writes with router_options=slave is not documented

    • Listener creation error is misleading

    • Cache filter hangs if statement consists of multiple packets.

    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 supported the Linux distributions.

    Packages can be downloaded .

    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 .

    MariaDB MaxScale 2.5.17 Release Notes

    Release 2.5.17 is a GA release.

    Released: 13 Dec 2021

    This document describes the changes in release 2.5.17, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    Bug fixes

    • MaxScale unconditionally loads global options from /etc/maxscale.cnf.d/maxscale.cnf

    • test_kafkacdc fails in 2.5

    • Kerberos tests are skipped in 2.5

    • The pam_authentication_2fa test fails very often

    • core dumps from system-tests (meta bug)

    • Pinloki initial gtid scan incorrectly reads entire files

    • Errors with causal_reads and read-only transactions

    • Sending binlog events is inefficient

    • Document privileges required for procs_priv system table

    • Allow maintenance mode to be set on Galera cluster master

    • Allow symbolic link for path to directory /usr/share/maxscale/gui

    • The location of the GUI web directory isn't documented

    • Queries are not always counted as reads with router_options=slave

    • maxscale crash

    • maxscale rpl_state is empty

    • SQL_MODE parsing sometimes fails

    • When MariaDBMonitor acquires lock majority, the log message gives the impression that auto_failover is enabled even when it is not configured

    • Unexpected internal state with read-only cursor and result with one row

    • Not enough information in server state change messages

    • session_track_trx_state set to true causes incorrect routing of SELECT

    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 supported the Linux distributions.

    Packages can be downloaded .

    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 .

    MariaDB MaxScale 2.5.11 Release Notes

    Release 2.5.11 is a GA release.

    Released: 4 May 2021

    This document describes the changes in release 2.5.11, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    Bug fixes

    • Syslog output is not filtered according to current log configuration

    • option lazy_connect not fully effective

    • Kafkacdc doesn't reconnect on replication error

    • Old master connection is left open after transaction migration

    • MaxCtrl doesn't strip colors from non-tty output

    • Transaction Replay: transactions not replayed after Xpand group change

    • After "clock has been changed to REALTIME" in syslog maxscale crashes

    • Read statistics are wrong with master_accept_reads and read-only transactions

    • Updates to services don't propagate upwards to other services that use them

    • Malformed packet SQL=LOAD DATA LOCAL INFILE... ERROR 2027

    • Prepared statement inside trx not tracked with transaction_replay

    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 supported the Linux distributions.

    Packages can be downloaded .

    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 .

    MariaDB MaxScale 2.5.12 Release Notes

    NOTE After 2.5.12 was released, a serious regression was noticed. Do not use MaxScale 2.5.12, but install or upgrade to MaxScale 2.5.13 that contains a fix for the regression.

    Release 2.5.12 is a GA release.

    Released: 26 May 2021

    This document describes the changes in release 2.5.12, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    Bug fixes

    • EXPLAIN leaks memory

    • COM_STMT_EXECUTE target selection is too restrictive when no metadata is provided

    • Plugin name comparison is case-sensitive

    • Removal of authenticator_options is not documented in upgrade documents

    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 supported the Linux distributions.

    Packages can be downloaded .

    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 .

    MariaDB MaxScale 2.5.9 Release Notes

    Release 2.5.9 is a GA release.

    Released: 10 Mar 2021

    This document describes the changes in release 2.5.9, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    Bug fixes

    • Regression in max_slave_replication_lag

    • MaxScale with SSL in Azure Cloud not working properly

    • Token authentication doesn't perform authorization

    • causal_reads=global returns an unexpected OK packet

    • Need more GRANTs to be documented for connecting to xpand direct using xpandmon

    • maxscale write in the slave with function

    • Reset implementation on failing prepared statement

    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 supported the Linux distributions.

    Packages can be downloaded .

    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 .

    MariaDB MaxScale 2.5.16 Release Notes

    Release 2.5.16 is a GA release.

    Released: 12 Oct 2021

    This document describes the changes in release 2.5.16, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    Bug fixes

    MariaDB MaxScale 2.5.20 Release Notes

    Release 2.5.20 is a GA release.

    Released: 10 May 2022

    This document describes the changes in release 2.5.20, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    New Features

    MariaDB MaxScale 2.5.18 Release Notes

    Release 2.5.18 is a GA release.

    Released: 12 Jan 2022

    This document describes the changes in release 2.5.18, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    Bug fixes

    MXS-3223
    MXS-3218
    MXS-3212
    MXS-3200
    MXS-3198
    MXS-3157
    MXS-3142
    MXS-4566
    MXS-4557
    MXS-4556
    MXS-4548
    MXS-4524
    MXS-4515
    MXS-4514
    MXS-4510
    MXS-4504
    MXS-4494
    MXS-4489
    MXS-4476
    MXS-4474
    MXS-4473
    MXS-4469
    MXS-4459
    MXS-4197
    MXS-3972
    here
    here

    MXS-4657 Add human readable message text to API errors like 404

  • MXS-4656 Setting session_track_trx_state=true leads to OOM kiled.

  • MXS-4642 Document that the Xpand service-user requires "show databases" privilege

  • MXS-4617 expire_log_duration not working

  • MXS-4541
    MXS-4676
    MXS-4670
    MXS-4665
    MXS-4659
    here
    here
    MXS-3885
    MXS-3872
    MXS-3871
    MXS-3870
    MXS-3858
    MXS-3857
    MXS-3856
    MXS-3845
    MXS-3832
    MXS-3826
    MXS-3824
    MXS-3817
    MXS-3816
    MXS-3815
    MXS-3814
    MXS-3810
    MXS-3809
    MXS-3801
    MXS-3800
    MXS-3782
    here
    here
    MXS-3509
    MXS-3505
    MXS-3504
    MXS-3487
    MXS-3483
    MXS-3472
    MXS-3471
    MXS-3468
    MXS-3462
    MXS-3459
    MXS-3454
    here
    here

    MXS-3536 max_slave_connections=0 doesn't work as expected

  • MXS-3535 user variable is not collected if it's in join clause

  • MXS-3533 MaxScale doesn't advertise the SESSION_TRACK capability

  • MXS-3529 Maxscale is not compatible with the latest cmake 3.20

  • MXS-3528 Maxscale source repo contains old boost-1.73.0.tar.gz which is not buildable with latest cmake on ARM

  • MXS-3524 alter syslog is not supported during runtime

  • MXS-3479 Disabling maxlog doesn't fully prevent it from being written to

  • MXS-3566
    MXS-3565
    MXS-3548
    MXS-3538
    here
    here
    MXS-3428
    MXS-3426
    MXS-3419
    MXS-3416
    MXS-3409
    MXS-3404
    MXS-3392
    here
    here

    MXS-3805 Binlogrouter error messages aren't specific enough

  • MXS-3804 Result size accounting is wrong

  • MXS-3799 Destroyed monitors are not deleted

  • MXS-3798 Race condition in service destruction

  • MXS-3790 Fix luafilter

  • MXS-3788 Debug assertion with default config and transaction_replay=true

  • MXS-3779 binlogrouter logs warnings for ignored SQL

  • MXS-3766 Not able to insert data on Masking enabled table

  • MXS-3759 Client hangs forever when server failed or restarted

  • MXS-3756 KILL behavior is not well documented

  • MXS-3748 Crash when unified log cannot be created

  • MXS-3747 Empty strings aren't serialized as quoted strings

  • MXS-3746 type=listener is added twice in listener serialization

  • MXS-3738 maxctrl show dbusers does nothing

  • MXS-3734 show binlog error msg is incorrect

  • MXS-3728 Binlogrouter crashes when GTID is not found

  • MXS-3718 MaxScale killed by watchdog timeout

  • MXS-3657 CCR Filter ignores PCRE2 option ignorecase

  • MXS-3580 Avrorouter should store full GTID coordinates

  • MXS-3331 Could not bind connecting socket to local address

  • MXS-3298 DNS server failure crashes Maxscale

  • MXS-3254 Monitor failover fails

  • MXS-3063 error : Sync marker mismatch.

  • MXS-3060 Failed to load current GTID

  • MXS-3050 Setting Up MaxScale documentation should include instructions on how to configure the MaxScale grants in ClustrixDB

  • MXS-3049 error : [avrorouter] Reading Avro file failed with error 'MAXAVRO_ERR_VALUE_OVERFLOW'.

  • 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 supported the 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.

    our Jira

    MXS-3938 Debug assert in xpandmon

  • MXS-3934 Linking a service at runtime to an xpandmon doesn't work

  • MXS-3933 Avro reader client can fail

  • MXS-3928 MaxScale logs a warning when users are loaded from a Xpand cluster

  • MXS-3920 Can't connect to MaxScale when schema uses utf8mb4 chars >= U0080

  • MXS-3897 MaxScale crashes when executing CDC process to kafka

  • 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 supported the 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.

    our Jira

    MariaDB MaxScale 2.5.3 Release Notes

    MXS-3997 Name threads for better CPU usage view

  • MXS-3665 Provide more feedback on TLS cipher mismatch

  • Bug fixes

    • MXS-4110 Schemarouter does not ignore the sys schema

    • MXS-4109 The /user/inet endpoint fails schema validation

    • MXS-4103 Binlogrouter doesn't decrypt passwords

    • MXS-4096 Binlog Routers SHOW SLAVE STATUS does not show SSL information

    • User account manager does not detect db-level priv changes

    • schemarouter: duplicate tables found, if table differs on upper lower case only

    • REST API allows deletion of last user

    • Status of boostrap servers not always the same as the status of corresponding runtime servers

    • The cache does not handle multi-statements properly.

    • Add maxctrl command for dumping the whole REST API output

    • Mariadbmon constantly logs errors if event scheduler is disabled

    • Debug assert with connection_keepalive and slow server

    • maxctrl reload service does not bypass the users refresh rate limit

    • Persistent connection pool is not automatically flushed

    • CDC protocol logs a notice message for each new connection

    • Schema auto-generation is not documented

    • Avrorouter doesn't log an error for failed SHOW CREATE TABLE

    • Query classifier cache does not properly record all used memory

    • Race condition in KILL command execution

    • GSSAPI authenticator documentation is out of date

    • KILL commands leave no trace in the log

    • The Cache filter cannot cope with the Redis server closing the connection

    • Binlogrouter creates malformed replication events

    • Got below signal 11 error after upgrading maxscale version maxscale 6.2.1

    • Sync marker mismatch while reading Avro file

    • Check certificates with extendedKeyUsage options set for correct purpose flags

    • Improve Rest API performance

    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 supported the 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.

    our Jira

    MariaDB MaxScale 2.5.21 Release Notes

    Release 2.5.21 is a GA release.

    Released: 8 Jul 2022

    This document describes the changes in release 2.5.21, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    New Features

    • Document MaxScale performance tuning

    Bug fixes

    • Reported size for query classifier cache keeps growing

    • MaxScale w/SSL doesn't work on FIPS RHEL7

    • Filter diagnostics are not shown in maxctrl show filters

    • Servers with priority=0 are selected as Master

    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 supported the Linux distributions.

    Packages can be downloaded .

    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 .

    MariaDB MaxScale 2.5.1 Release Notes

    Release 2.5.1 is a GA release.

    Released: 16 Jul 2020

    This document describes the changes in release 2.5.1, when compared to the previous release in the same series.

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

    New Features

    MariaDB MaxScale 2.5.8 Release Notes

    Release 2.5.8 is a GA release.

    Released: 18 Feb 2021

    This document describes the changes in release 2.5.8, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    Bug fixes

    MXS-4093
    MXS-4092
    MXS-4086
    MXS-4074
    MXS-4053
    MXS-4045
    MXS-4040
    MXS-4039
    MXS-4038
    MXS-4034
    MXS-4024
    MXS-4023
    MXS-4022
    MXS-4008
    MXS-4004
    MXS-4003
    MXS-4002
    MXS-4001
    MXS-4000
    MXS-3954
    MXS-3945
    MXS-3931
    MXS-3808

    MXS-4164 Debug assertion when cat session ends

  • MXS-4160 Maxscale galeramon + max_slave_replication_lag = Could not find valid server for target type TARGET_SLAVE

  • MXS-4152 Schemarouter performance degrades as the number of tables increases

  • MXS-4151 Schemarouter duplicate checks are excessively slow

  • MXS-4146 Xpand MaxScale Tutorial in KB doesn't work

  • MXS-4141 connection_keepalive=0 causes a memory leak

  • MXS-4139 connection_keepalive sends pings even if client is idle

  • MXS-4138 Race condition in binlogrouter

  • MXS-4134 /etc/maxscale.cnf.d/ is not created by package installation

  • MXS-4132 router_options=master ignores rank for first server

  • MXS-4127 MaxCtrl: list services does not include other targets

  • MXS-4121 MaxCtrl is limited to 2GB of memory

  • MXS-4120 Avrorouter crash with a SEQUENCE engine table

  • MXS-4115 Maxscale prints user/pass with CHANGE MASTER command in logfile while failover.

  • MXS-4110 Schemarouter does not ignore the sys schema

  • MXS-4100 connection_keepalive=0 causes a memory leak

  • MXS-2904
    MXS-4194
    MXS-4181
    MXS-4166
    MXS-4165
    here
    here
    MXS-3015 Sort attribute lists returned by maxctrl alphabetically
  • MaxGUI can now be accessed in a testing mode without configuring SSL. For more information, please refer to the MaxGUI document.

  • Bug fixes

    • MXS-3072 Failed to query server 'server1' for user account info. Wrong number of resultsets to multiquery

    • MXS-3052 kafkaCDC how to set GTID

    • MXS-3041 QC bug with keyword handler

    • MXS-2996 Query Type of 'SELECT ... LOCK IN SHARE MODE;'

    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 supported the 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.

    our Jira

    MXS-3408 ASAN reports leaks in the query classifier

  • MXS-3404 maxscale write in the slave with function

  • MXS-3403 The Cache Filter cannot deal with batched requests

  • MXS-3400 maxscale crash with memcache on ubuntu 20

  • MXS-3399 QC heap-buffer-overflow

  • MXS-3396 Default /etc/maxscale.cnf for MaxScale 2.5 comments direct user to MaxScale 2.4 documents

  • MXS-3395 Problems with prepared statements with more than 2^16 columns

  • MXS-3380 MaxScale crash loop with cache filter + Redis

  • MXS-3366 COM_CHANGE_USER rejected by MaxScale

  • 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 supported the 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.

    our Jira

    MariaDB MaxScale 2.5.7 Release Notes

    Release 2.5.7 is a GA release.

    Released: 27 Jan 2021

    This document describes the changes in release 2.5.7, when compared to the previous release in the same series.

    If you are upgrading from an older major version of MaxScale, please read the upgrading document for this MaxScale version.

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

    New Features

    • Allow the binlog router to replicate from Galera cluster with failover.

    Bug fixes

    • Debug assertion with delayed_retry and master failure

    • MaxScale fails to update IP for a existing node that reappears with a IP change

    • Asynchronicity of tee filter isn't documented

    • Missing match setting in filter(s) results in no match at all

    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 supported the Linux distributions.

    Packages can be downloaded .

    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 .

    MariaDB MaxScale 2.5.6 Release Notes

    Release 2.5.6 is a GA release.

    Released: 15 Dec 2020

    This document describes the changes in release 2.5.6, when compared to the previous release in the same series.

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

    NOTE After the release of 2.5.6 it was noticed that configuring the same server for both the persistent pool (configuration settings persistpoolmax and persistmaxtime

    MXS-3360 MaxCtrl option --authenticator-options doesn't work

  • MXS-3354 Duplicate space interpreted as a command

  • MXS-3353 Tee filter loses statements if branch target is slower

  • MXS-3348 KafkaCDC :Failed to read replicated event

  • MXS-3347 Hint syntax documentation isn't exact

  • MXS-3346 When using --basedir, mysql/plugin dir needs to be writable

  • MXS-3342 Persistent connections cause signal 11 when no matching connection is found

  • MXS-3339 Hang with prepared statement and slow servers

  • MXS-3337 galeramon queries only status, not variables

  • MXS-3323 Database grants with wildcards should be matched using LIKE operator

  • MXS-3318 Parsing error with comment

  • MXS-3309 The administration tutorial is lacking

  • MXS-3303 A user with just EXECUTE on PROCEDURE privileges to the database, failing to connect via maxscale with database name mentioned.

  • MXS-3238 REST API SSL Configuration Vulnerabilities

  • MXS-3158 Failover/switchover modifies event character set and collation

  • MXS-2627 Document how to customize MaxScale's systemd unit file

  • MXS-3193
    MXS-3383
    MXS-3374
    MXS-3370
    MXS-3365
    here
    here
    ) and the proxy protocol (configuration setting
    proxy_protocol
    ) may in some situations lead to a crash. Using either one is ok. We will release 2.5.7 with a fix for this as soon as possible (January 2021).

    New Features

    • MXS-3129 Add Switchover to WebGUI

    Bug fixes

    • MXS-3338 Last statement in read-only transaction doesn't trigger transaction replay

    • MXS-3335 MaxScale 2.5.6 and Xpand Direct connection issue with xpandmon

    • MXS-3334 Master failure triggers replay of read-only transaction

    • MXS-3333 Malformed error messages

    • Persistent Connections on Maxscale 2.5 seem to break client authentication

    • Memcachd/Redis cache storage must be disabled if memcached/redis not reachable

    • Host class does not accept all valid domain names.

    • Redis cache storage does not accept dashes in server names.

    • Redis cache storage must be disabled if Redis not connectible

    • MaxScale cache must use timeout when connecting to redis/memcached

    • MaxScale not allowing login and sometimes crashes when cache server not available

    • routed_packets not updated by readconnroute

    • Multiple binlogrouters in the same MaxScale

    • MaxScale does not recognize xpand properly

    • Layout of classify REST API endpoint stores non-parameter data in parameters object

    • Backticks not stripped in USE statements.

    • Unable to execute use database

    • Scramble should be composed of characters

    • Select query inside transactions are routed to slave with session_track_trx_state=true

    • maxctrl not prompt directy for the password

    • dump_last_statements=on_close doesn't log session ID

    • MaxScale 2.5.5 crashes with signal 11

    • The event mechanism is not configured.

    • Match pinloki initial setup to that of MariaDB server

    • Hang on shutdown when executing KILL query

    • "error : (1672) Unexpected result state" with connection_keepalive

    • KafkaCDC read stream data too slow

    • Database grants with escape characters do not work (strip_db_esc)

    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 supported the 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.

    our Jira

    MariaDB MaxScale 2.5.2 Release Notes

    Release 2.5.2 is a GA release.

    Released: 14 Aug 2020

    This document describes the changes in release 2.5.2, when compared to the previous release in the same series.

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

    New Features

    MXS-3328
    MXS-3327
    MXS-3326
    MXS-3325
    MXS-3316
    MXS-3313
    MXS-3312
    MXS-3311
    MXS-3307
    MXS-3301
    MXS-3295
    MXS-3293
    MXS-3292
    MXS-3283
    MXS-3282
    MXS-3272
    MXS-3271
    MXS-3270
    MXS-3264
    MXS-3256
    MXS-3251
    MXS-3248
    MXS-3199
    MXS-3172
    MXS-3099 Add AddNode/RemoveNode to the Columnstore Monitor
  • MXS-2383 Support PAM authentications involving more than simple password exchanges

  • Bug fixes

    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 supported the 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.

    our Jira

    MariaDB MaxScale 2.5.4 Release Notes

    Release 2.5.4 is a GA release.

    Released: 29 Sep 2020

    This document describes the changes in release 2.5.4, when compared to the previous release in the same series.

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

    New Features

    • Allow queuing of switchover/failover

    • Monitor of binlog router

    Bug fixes

    • Additional grants not mentioned in upgrading document

    • Errors can be returned in wrong order

    • Reply with an error if a replica tries to connect with log_file/log_pos

    • New binlog router should clearly says that it does not file/pos based options in CHANGE MASTER

    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 supported the Linux distributions.

    Packages can be downloaded .

    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 .

    MariaDB MaxScale 2.5.0 Release Notes

    Release 2.5.0 is a Beta release.

    Released: 18 Jun 2020

    This document describes the changes in release 2.5.0, when compared to release 2.4.

    For any problems you encounter, please consider submitting a bug report at .

    Changed Features

    MXS-3181 Binlog Router should understand all monitor queries

  • MXS-3177 Fix download link in documentation

  • MXS-3176 MaxGUI logs admin user out after dbfwfilter is added to MaxScale config file

  • MXS-3175 Make pinloki deployment simple and observeable

  • MXS-3171 PHP 7.2 + PDO - invalid HandShakeResponse

  • MXS-3167 Access Denied for User Error when Upgrading to 2.5.x and Using Binlogrouter

  • MXS-3165 cache_inside_transactions vs cache_in_transactions

  • MXS-3164 Handle AuthSwitchRequest-packet properly in standard auth plugin

  • MXS-3163 Wrong type for server and global modules

  • MXS-3160 PLUGIN_AUTH_LENENC_CLIENT_DATA capability not set

  • MXS-3150 MaxGUI should redirect to 404 page if id of details route doesn't exist

  • MXS-3149 Monitor should remove [Master] when starting swithover

  • MXS-3148 Binlogrouter doesn't accept trailing semicolons

  • MXS-3147 Pinloki should not create logically empty binlog files.

  • MXS-3143 FOUND_ROWS() not routed to previous target

  • MXS-3140 Deleting a resource causes navigating to login page.

  • MXS-3130 Documentation for the source parameter is inaccurate

  • MXS-3110 bad handshake error in maxscale 2.5.1

  • MXS-2680 Monitor type not shown in show monitors

  • MXS-1998 Shard map refresh is not logged on any level

  • MXS-2719
    MXS-2692
    MXS-3202
    MXS-3196
    MXS-3194
    MXS-3191
    here
    here
    Network throttling (writeq_high_water and writeq_low_water) is now on by default. This will prevent MaxScale from running out of memory when large database dumps are restored through it. This change will not affect performance in any significant way.
  • Servers with duplicate network details (address and port) are treated as a configuration error. There should exist only one server object in MaxScale for each actual database.

  • Server parameters are now checked and unknown parameters are treated as a configuration error. This can cause old configurations with unknown parameters to fail.

  • Servers without a monitor now start in the Down state instead of the Running state. This means that servers without a monitor need to have their state set manually.

  • connection_keepalive

    Previously this feature was a readwritesplit feature. In MaxScale 2.5.0 it has been converted into a core MaxScale feature and it can be used with all routers. In addition to this, the keepalive mechanism now also keeps completely idle connections alive (MXS-2505).

    User loading timeouts

    The default timeout values for user loading have been changed.

    • auth_connect_timeout changed from 3 to 10 second

    • auth_read_timeout deprecated and ignored

    • auth_write_timeout deprecated and ignored

    Setting a server to maintenance or draining mode

    In the case of a regular MariaDB cluster (monitored by the MariaDB monitor), it is no longer possible to set the master server to maintenance or draining mode, but a switchover must be performed first.

    MariaDB-Monitor deprecated settings

    The settings detect_stale_master, detect_standalone_master and detect_stale_slave are replaced by the more flexible master_conditions and slave_conditions. The old settings may still be used, but will be removed in a later version.

    Password encryption

    The encrypted passwords feature has been updated to be more secure. Users are recommended to generate a new encryption key and re-encrypt their passwords using the maxkeys and maxpasswd utilities. Old passwords still work.

    Authenticator options

    Several changes, see here for more details.

    REST API

    • Listeners are now a separate resource from services. The old listeners entry point is deprecated and its use is discouraged.

    Dropped Features

    MaxAdmin has been removed.

    Use maxctrl or maxgui instead.

    No concept of Unix users anymore

    As maxadmin, that could be used over a unix domain socket, has been removed it is no longer possible to enable/disable unix users as MaxScale administrators.

    Configuration parameters

    The following deprecated parameters have been removed.

    • non_blocking_polls

    • poll_sleep

    • log_trace and log_messages that were synonyms for log_info and log_notice respectively.

    Removed modules

    • The maxinfo-router and the httpd-protocol have been removed.

    Deprecated Features

    • Server parameters protocol and authenticator have been deprecated. Any definitions are ignored.

    Readwritesplit

    • The use of percentage values in max_slave_connections has been deprecated.

    New Features

    • The timeout to maxctrl can now be specified using duration suffixes, e.g. --timeout 5s.

    • The new targets parameter for services can be used to list both servers and other services as routing targets. This allows complex setups to be used where one service routes the query to another service.

    • MariaDB connection attributes are now forwarded to the backend servers.

    MaxGUI

    MaxGUI is a new browser based configuration and management tool for MaxScale that complements the command line tool maxctrl.

    Please see the documentation for more information.

    Cache

    Invalidation

    The MaxScale cache is now capable of performing invalidation of cache entries. See the documentation for more information.

    New Cache Storage Modules

    The following storage modules have been added: storage_memcached storage_redis

    When either of these are used, the cache can be shared between two MaxScale instances.

    User specific cache

    It is now possible to specify that each user should have a cache of his/her own. Having a user-specific cache ensures that it is impossible for a user to obtain access to data he/she should not have access to, something which may be possible if a shared cache is used, as the cache filter is not aware of grants. Please see the documentation for details.

    Load Rebalancing

    If the load of the threads of MaxScale differs by a certain amount, MaxScale is now capable of moving sessions from one thread to another so that all threads are evenly utilized. Please refer to rebalance_period and rebalance_threshold for more information.

    Columnstore support

    The Columnstore monitor is now capable of monitoring Columnstore versions 1.0, 1.2 and 1.5. In addition, some cluster management operations are available for Columnstore 1.5. Please see the documentation for details.

    Cooperative monitoring

    MariaDB-Monitor supports cooperative monitoring. See cooperative monitoring for more information.

    Listener and authenticator settings

    • multiple authenticators per listener

    • connection_init_sql_file

    • mysql_clear_password support for PAM authenticator

    See configuration guide and pam plugin documentation for more details.

    TLS

    • Added support for peer hostname verification in connections that use TLS.

    • Added support for certificate revocation lists

    Readwritesplit

    • The causal reads feature has been extended with a global mode, which uses latest known GTID and waits for slave to replicate, and a fast mode, which routes queries to the master if no up-to-date slave is found.

    Schemarouter

    • The router now supports setups where multiple servers contain the same database or table. This allows a more resilient setup where a failure of one shard doesn't cause a complete outage.

    • The credentials the clients use to connect to the schemarouter no longer need to exist on all of the databases used by the service. This reduces the amount of access required by the clients that use the schemarouter.

    Mirror Router

    • The mirror router is a new router designed for data consistency and database behavior verification during system upgrades. It can export the measured data as JSON into either a file or into a Kafka broker.

    KafkaCDC

    • New module that replicates data changes in a MariaDB master into a Kafka broker formatted as JSON objects. Refer to the KafkaCDC documentation for more details.

    REST API

    • Token authentication via JWT.

    • Sparse fieldsets allow reduced network overhead for requests.

    • Result filtering allows retrieval of a subset of a resource collection.

    • REST API resources now use the SHA1 of the returned result as the object ETag. This fixes the problem where the ETag was not updated even when the result changed due to internal MaxScale processes.

    • Module parameter types are now described for the server and core MaxScale objects.

    • Listeners are now a separate resource from services. The old listeners entry point is deprecated and its use is discouraged.

    Bug fixes

    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 Linux distributions supported by MariaDB Enterprise.

    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 X.Y.Z. Further, master always refers to the latest released non-beta version.

    The source code is available here.

    Jira