The Ultimate Guide to High Availability with MariaDB

MariaDB ColumnStore 22.08.1 Release Notes

Contents

  1. Overview
  2. Notable Changes
    1. JOINs
    2. Query Performance
    3. Functions
    4. Tooling
    5. Operating Systems
    6. CPU Compatibility
    7. Internal Processes
  3. Platforms
  4. Installation Instructions
  5. Upgrade Instructions

Overview

MariaDB Enterprise ColumnStore 22.08.1 is a maintenance release of MariaDB Enterprise ColumnStore . MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server. This is the first release in the Enterprise ColumnStore 22.08 series.

MariaDB Enterprise ColumnStore 22.08.1 was released on 2022-09-12. This release is of General Availability (GA) maturity.

MariaDB Enterprise ColumnStore 22.08 replaces MariaDB Enterprise ColumnStore 6 in MariaDB Enterprise Server 10.6.

This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.6.9-5.

This release has been withdrawn. Users of MariaDB Enterprise ColumnStore 22.08.1 should upgrade to MariaDB Enterprise ColumnStore 22.08.3.

Notable Changes

JOINs

  • Support has been added for JOINs with an ON clause that reference tables that are not involved in the join. (MCOL-5167)
  • Support has been added for circular outer JOINs. (MCOL-4699)
  • Support has been added for complex JOINs in views. (MCOL-5061, MCOL-4902)
  • Support has been added for combining outer JOINs and IS NULL filters. (MCOL-4715)

Query Performance

  • In single-node ColumnStore, query performance has been improved by removing a network hop. (MCOL-5166)
  • Performance has been enhanced for queries that filter on numbers. (MCOL-5140, MCOL-4995)
  • Performance has been enhanced for DELETE queries. (MCOL-5021)

Functions

  • Support for CHAR and VARCHAR have been added for the MODA() function. (MCOL-5161)
  • Distributed implementations of most JSON functions have been added to ColumnStore. (MCOL-785)
    • This feature does not include JSON_ARRAYAGG, JSON_OBJECTAGG, or JSON_TABLE.
  • ColumnStore's functions that use the cal prefix have been changed to use the mcs prefix. (MCOL-4984)

Tooling

  • ColumnStore now includes Cluster Management API (CMAPI) 22.08.1.
  • Some internal improvements have been made to the mcsRebuildEM utility. (MCOL-5172)

Operating Systems

  • Operating system compatibility has changed, as designated in MariaDB Engineering Policy, including:
    • Support for Debian 11, Red Hat Enterprise Linux 9, Rocky Linux 9, and Ubuntu 22.04 have been added.
    • Support for Debian 9, Debian 10, and Ubuntu 18.04 have been removed.

CPU Compatibility

  • When ColumnStore is installed and started, ColumnStore's binaries check the system's CPU to confirm that the CPU supports the SIMD instructions required by ColumnStore. (MCOL-5180)
    • On x86_64, ColumnStore requires SSE4.2.
    • On ARM64, ColumnStore requires NEON.
    • If the ColumnStore installation scripts determine that the required SIMD instructions are not supported, the following error is raised: 
error: this machine CPU lacks of support for Intel SSE4.2 or ARM Advanced SIMD instructions. Columnstore requires one of this instruction sets, installation aborted

If the ColumnStore binaries are started and determine that the required SIMD instructions are not supported, the following error is raised:

Unsupported CPU architecture. ARM Advanced SIMD or x86_64 SSE4.2 required; aborting.

Internal Processes

  • Internal stability improvements have been made to the processes that write data. (MCOL-5163)
    • The WriteEngineServer, DMLProc, and DDLProc processes have been improved.
  • PrimProc thread pool has been changed to use a fair scheduler. (MCOL-5044)
  • The ExeMgr process has been merged with the PrimProc process. (MCOL-5001, MCOL-5109)

Platforms

In alignment to the enterprise lifecycle, MariaDB Enterprise ColumnStore 22.08.1 is provided for:

  • CentOS 7 (x86_64)
  • Debian 11 (x86_64, ARM64)
  • Red Hat Enterprise Linux 7 (x86_64)
  • Red Hat Enterprise Linux 8 (x86_64, ARM64)
  • Red Hat Enterprise Linux 9 (x86_64, ARM64)
  • Rocky Linux 8 (x86_64, ARM64)
  • Rocky Linux 9 (x86_64, ARM64)
  • Ubuntu 20.04 (x86_64, ARM64)
  • Ubuntu 22.04 (x86_64, ARM64)

Installation Instructions

Upgrade Instructions

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.
Back to Top