The Ultimate Guide to High Availability with MariaDB

MariaDB ColumnStore 5.5.2 Release Notes

Contents

  1. Overview
  2. Notable Changes
  3. Issues Fixed
    1. Can result in data loss
    2. Can result in a hang or crash
    3. Can result in unexpected behavior
    4. Related to install and upgrade
  4. Platforms
  5. Installation Instructions
  6. Upgrade Instructions

Overview

MariaDB Enterprise ColumnStore is a columnar storage engine that is included with the MariaDB Enterprise Server. This is the fourth release in the Enterprise ColumnStore 5 series.

This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.5.9-6.

This release is of General Availability (GA) maturity.

MariaDB Enterprise ColumnStore 5.5.2 was released on 2021-03-15.

Notable Changes

  • Added the ec2_iam_mode=enabled option to storagemanager.cnf, which enables an EC2 instance to authenticate with S3 using its IAM role. (MCOL-4386)
  • Added support for CREATE TABLE AS SELECT .. COUNT() .. FROM .. GROUP BY .. (MCOL-3785)
  • Removed legacy OAM scripts. (MCOL-4193)
  • Consolidated ColumnStore log files in the /var/log/mariadb/columnstore/ directory. (MCOL-4483)
  • Moved CMAPI log files to the /var/log/mariadb/columnstore/cmapi/ directory. (MCOL-4494)
  • Added more logs to /etc/logrotate.d/columnstore configuration. (MCOL-4319)
  • Refactor ColumnStore systemd services to ensure startup waits for network connectivity. (MCOL-4170)
  • Results from SELECT .. ORDER BY BINARY(col) now match InnoDB. (MCOL-4454)
  • Results from FLOOR() function now match InnoDB for DATETIME, TIMESTAMP, and TIME columns. (MCOL-4263)

Issues Fixed

Can result in data loss

  • Extent map can become corrupted during startup under 5.5.1 with a large extent map and shared storage. (MCOL-4546)

Can result in a hang or crash

  • A join with different collations crashes the ExeMgr process. (MCOL-4470)
  • A time zone conversion results in a hang due to a deadlock in the thread pool. (MCOL-4486)
  • When replication is used, INSERT INTO .. SELECT .. FROM ... results in a hang in the SQL thread. (MCOL-4515)

Can result in unexpected behavior

  • Error message from LOAD DATA INFILE statement mentions wrong path for .err and .bad files. (MCOL-571)
  • Table remains locked when ColumnStore is forced to restart. (MCOL-3324)
  • CREATE TABLE AS SELECT .. LIMIT 0 writes a row to the table. (MCOL-4453)
  • SELECT DISTINCT col FROM TABLE LIMIT offset, limit statement ignores offset. (MCOL-4455)
  • Results from a query with both a left join and an inner join are incorrect. (MCOL-4493)
  • Performance regression for queries that filter on small CHAR columns that use latin1 character set. (MCOL-4527)
  • Queries on big tables that filter on small CHAR columns ignore the collation. (MCOL-4539)
  • Results from a UDAF are incorrect when executed in a non-distributed manner. (MCOL-4585)
  • Configuration files not moved back into place after in-place upgrade. (MCOL-4597)

Platforms

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

  • CentOS 7
  • CentOS 8
  • Debian 9
  • Debian 10
  • Red Hat Enterprise Linux 7
  • Red Hat Enterprise Linux 8
  • SUSE Linux Enterprise Server 12
  • SUSE Linux Enterprise Server 15
  • Ubuntu 16.04
  • Ubuntu 18.04
  • Ubuntu 20.04

Installation Instructions

  • ColumnStore Object Storage Topology with MariaDB Enterprise Server 10.5 and MariaDB Enterprise ColumnStore 5
  • ColumnStore Shared Local Storage Topology with MariaDB Enterprise Server 10.5 and MariaDB Enterprise ColumnStore 5
  • HTAP Topology with MariaDB Enterprise Server 10.5 and MariaDB Enterprise ColumnStore 5
  • Single-Node Enterprise ColumnStore 5 with MariaDB Enterprise Server 10.5 and Object Storage
  • Single-Node Enterprise ColumnStore 5 with MariaDB Enterprise Server 10.5

Upgrade Instructions

  • Major Release Upgrades for MariaDB Enterprise ColumnStore

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