The Ultimate Guide to High Availability with MariaDB

MariaDB Connector/Node.js 3.3.0 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/Node.js.

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/Node.js 3.3.0 is a Stable (GA) release.

For an overview of MariaDB Connector/Node.js see the About MariaDB Connector/Node.js page

Notable changes

CONJS-284 pipeline PREPARE and EXECUTE

Previous use of connection.execute was executing PREPARE command first, read PREPARE response, then execute EXECUTE command and finally read EXECUTE response.

New implementation, when using using MariaDB server 10.2+ and with `pipelining` option enable (default value) will execute PREPARE, execute EXECUTE, then only read PREPARE response and read EXECUTE response. This permit to avoid much of the network latency.

Benchmarking results using local database: (distant database would have even better result)



bench

This improvement is for first execution of a specific query, since PREPARE is cached by default, second execution would only execute EXECUTE command

CONJS-264 validate ssl certificates using client password

In order to have SSL connections, there was 3 solutions:

  • Have server certificats generated with trusted node.js Certificate Authorities (CA), like ssl: true.
  • Configure connector with server certificate like:ssl: { ca: [ fs.readFileSync('server-cert.pem') ] }
  • disable certificate ssl verification (not secured!) like:ssl: { rejectUnauthorized: true }

Since MariaDB 11.4.1 and MDEV-31855, connector doesn't need to have server certificate anymore, permitting simple configuration like:ssl: true if password is not empty. This permit easier client configuration.

Other changes

  • CONJS-279 Improve query encoding and decoding performance

Issues Fixed

  • CONJS-281 cannot connect to 11.3+ server with character-set-collations = utf8mb4=uca1400_ai_ci
  • CONJS-277 using connection.importFile when connection is not connected to database result in error
  • CONJS-278 Possible buffer overwrite when sending query bigger than 16M
  • CONJS-282 error when using mysql_clear_test password authentication plugin
  • CONJS-283 wrong decoding of binary unsigned MEDIUMINT

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.