Product Solutions Support
Try MemSQL

5.8 Release Notes

MemSQL 5.8 brings support for SAML 2.0 authentication, security audit logging capabilities, manageability enhancements, and other improvements.

Security Enhancements

A number of security enhancements have been added in MemSQL 5.8.

SAML 2.0 Authentication

Users can now authenticate to MemSQL by using SAML 2.0 third-party authentication. When properly configured, a MemSQL cluster can now receive and validate SAML 2.0 assertions about a user during authentication with the database. For more information, see the SAML Authentication documentation.

Audit Logging

MemSQL now provides audit logging capability that records all database activity and writes log files to a external location. Numerous logging levels are provided to allow system administrators to adjust both the verbosity and types of queries that can be logged. For more information, see the Audit Logging documentation.

Info

As of the time of this publication, audit logging feature is made available and licensed only as part of the MemSQL Advanced Security Option. Before using or implementing this functionality, please consult with your enterprise’s licensing administrator to confirm that your enterprise has purchased the necessary Advanced Security Option license from MemSQL.

MemSQL Ops Agent Authentication

MemSQL Ops now supports inter-agent authentication using unique API tokens. When the primary agent generates a new token, agents on other hosts can follow the primary agent by specifying its unique API token. For more information, see the following topics in the documentation:

Workload Profiling and Management Views

MemSQL 5.8 introduces a new set of management views to help diagnose performance problems. These views allow you to determine where queries and system tasks are spending time, what resources are being consumed, and where bottlenecks may exist in the cluster. For more information, see the following topics in the documentation:

MemSQL Ops Upgrade to 6.0

When you upgrade MemSQL Ops to version 6.0 using:

sudo memsql-ops agent-upgrade --file-path memsql-ops-6.0.6.tar.gz

you will see a warning like:

Additionally, upgrading MemSQL may require manual intervention on rollback (read more at http://docs.memsql.com/docs/58-release-notes). It is highly recommended that you back up all your data before continuing. Would you like to proceed? [y/N]

The manual intervention on rollback mentioned in the message is no longer needed. We recommend that you do a backup before upgrading. Then enter y and proceed.

Streamliner Deprecation

MemSQL Streamliner will be deprecated in MemSQL 6.0. For current Streamliner users, we recommend migrating to MemSQL Pipelines instead. MemSQL Pipelines provides increased stability, improved ingest performance, and exactly-once semantics. For more information about Pipelines, see the MemSQL Pipelines documentation.

What Do I Do With My Old Streamliner Spark Cluster?

To upgrade to MemSQL 6.0, you must first remove each of your Streamliner pipelines, and then uninstall the Spark Cluster co-located with your MemSQL cluster. Once each of the pipelines has been removed, simply run memsql-ops spark-uninstall to uninstall the Spark Cluster.

Can I Still Use Spark With MemSQL?

Yes, MemSQL supports Spark integration via the MemSQL Spark Connector. The connector allows you to leverage your existing Spark clusters to write data directly to MemSQL via a performant and easy-to-use API. For more information on the MemSQL Spark Connector, please see the MemSQL Spark 2.0 Connector GitHub page.

How Do I Get Started With Pipelines?

For more information on Pipelines, please see:

Fixed Issues

Maintenance Release Changelog

The changelog below contains MemSQL improvements and bug fixes introduced in maintenance or revision releases. For a similar list for MemSQL Ops, see MemSQL Ops Releases.

2017-11-01 Version 5.8.8 (LATEST)

2017-08-25 Version 5.8.7

2017-08-15 Version 5.8.6

2017-07-19 Version 5.8.5

2017-06-07 Version 5.8.4

2017-05-04 Version 5.8.2

Was this article useful?