The Ultimate Guide to High Availability with MariaDB

MariaDB Connector/J 3.5.1 Release Notes

You are viewing an old version of this article. View the current version here.

Note: This page describes features in an unreleased version of MariaDB Connector/J.

Unreleased means there are no official packages or binaries available for download which contain the features. The source code is available on GitHub.

MariaDB Connector/J 3.5.1 is a Stable (GA) release.

For an overview of MariaDB Connector/J see the About MariaDB Connector/J page

The MariaDB Connector/J 3.5 release series is replacing the maintenance releases for the 3.4 release series, as the new release series is fully compatible with 3.4.

Notable changes

PARSEC Authentication - CONJ-1193

Support of the PARSEC Authentication Plugin which is provided starting with MariaDB Server 11.6. See parsec documentation for more details.

This requires java 15+ (to use java native ed25519 Algorithm implementation). For previous versions of java, this will require adding BouncyCastle as dependency.

While initially documented in 3.5.0, this feature was not in the released version.

New High Availability Mode With Loadbalancing For Reads - CONJ-1207

When running a multi-master cluster (i.e. MariaDB Cluster with Galera), writing to more than one node can lead to optimistic locking errors ("deadlocks") in some use cases. Writing concurrently to multiple nodes also doesn't result in performance improvements, due to having to synchronously replicate to all nodes. The new high availability mode “Load-balance-read” permits the use of masters in a failover manner (try first master, the next one if the first master fails) while distributing the load on replicas.

Example of connection string: 

jdbc:mariadb:load-balance-read://127.0.0.5,127.0.0.6,address=(host=127.0.0.7)(type=replica),address=(host=127.0.0.8)(type=replica)/DB

Equivalent of:

jdbc:mariadb:load-balance-read://address=(host=127.0.0.5)(type=primary),address=(host=127.0.0.6)(type=primary),address=(host=127.0.0.7)(type=replica),address=(host=127.0.0.8)(type=replica)/DB

In the example the hosts 127.0.0.5, 127.0.0.6 will be used for writes, in a failover manner. 127.0.0.6,127.0.0.7 are of type replica, read load balancing will be used.

Permit bulk for INSERT ON DUPLICATE KEY UPDATE commands for 11.5.1+ servers - CONJ-1208

Since MDEV-30366, the server can return appropriate detailed answers. This was implemented, but not for specific INSERT ON DUPLICATE KEY UPDATE commands.

Bugs Fixed

  • CONJ-1053 waffle-jna dependency is not declared optional in the module description
  • CONJ-1196 setObject on java.util.Date is en/decode as java.sql.Date and truncates hour/minutes/seconds/ms while it must be en/decode like a java.sql.Timestamp
  • CONJ-1211 JDBC 4.3 enquoteIdentifier missing validation
    • An identifier containing only number must be quoted, even if `alwaysQuote` parameter is set to false
    • Length validation must be done (< 64 characters).
  • CONJ-1213 SQL commands ending with semicolon and trailing space are not using bulk

Changelog

For a complete list of changes made in MariaDB Connector/J 3.5.1, with links to detailed information on each push, see the changelog.

Comments

Comments loading...
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.