Clustrix 9 brings new features to the leading scale-out SQL database built specifically for OLTP applications

Last fall, we announced that our most recent generally-available release, ClustrixDB 9, supports deploying a single database across multiple AWS Availability Zones (AZs). With this release, Clustrix continues its commitment to provide application developers with both scale and high-availability so they don’t have to choose one over the other. Clustrix 9 also features numerous enhancement to performance, stability, and supportability.

“The Clustrix mission has always been to provide a highly-scalable, distributed database that also provides high availability and ACID compliance,” said Mike Azevedo, CEO of Clustrix. “With an increasing number of our customers taking advantage of the lower TCO and elastic scalability of the cloud, offering them the additional option to take advantage of AWS Availability Zones seemed a natural extension of our mission.”

An overview of the new features of version 9 include:

Multi Zone Availability

  • Support for multiple Zones: You can now deploy ClustrixDB across multiple fault tolerant zones (e.g. AWS availability zones, racks in a data center, etc). Once ClustrixDB is configured to be zone-aware, there is no data loss if a zone or zone(s) become unavailable.

Modern Data

  • Support for Generated Columns that can be calculated based on other columns
  • Support for JSON (beta): including support for the JSON data type, indexing, and supporting functions.

Assorted Updates

  • Support for RHEL/ CentOS 7.4+. Clustrix recommends migrating to a cluster running RHEL/CentOS 7.4 Upgrading the OS version on nodes already running ClustrixDB is not supported. New installs only.
  • Non-root: Support for running as a user other than the root OS user. New CentOS 7.4 installs only.
  • Support for i3 instances in AWS: Clustrix has completed platform qualification for the i3 instance type running CentOS 7.4. CentOS 7.4 includes official support for the i3 instance type including NVMe. Please check with AWS to review their support for CentOS 7 and i3 instances.
  • Search in any region in Public Images for CentOS Linux 7 x86_64 HVM EBS 1708_11.01-b7ee8a69-ee97-4a49-9e68-afaee216db2e
  • The version global variable is now configurable. Please see ClustrixDB Version and MySQL Version Compatibility.
  • Support for Invisible Indexes, which can be used to evaluate the impact of indexes.
  • Using Encrypted Connections with ClustrixDB
  • The EUCKR collation
  • Support for 4k disk sector size for compatibility with Google Cloud Platform

For a more general overview of Clustrix 9, please take a look at the Clustrix 9 datasheet.