MariaDB ColumnStore 1.2.4 GA Release Notes
Release date: 29th May 2019
MariaDB ColumnStore 1.2.4 is a GA release of MariaDB ColumnStore. The MariaDB ColumnStore 1.2 series provides several new features and improvements over the MariaDB ColumnStore 1.1 release.
For an overview of MariaDB ColumnStore see MariaDB ColumnStore Architectural Overview
Please provide feedback in JIRA for anything that is not working as expected so that we can fix it before we make the release available for the larger community. For general "how to questions" ask questions here or subscribe to email@example.com
- MCOL-3315 - The base MariaDB server version is now 10.3.15 which include several maintenance and security fixes.
- MCOL-3270 - cpimport performance for dictionary data is up to 2x faster.
- MCOL-2061 - If you are performing a major version upgrade or have in the past there is a new stored procedure called columnstore_info.columnstore_upgrade() should be executed.
Bugs and issues fixed
- MCOL-537 - Some compiler warnings need fixing
- MCOL-1495 - Memory leak in WriteEngineServ
- MCOL-1673 - Different trailing behaviour between columnstore and innodb
- MCOL-1831 - multibyte space (zenkaku) breaks strings comparisation
- MCOL-1951 - Crash when MySQL aggregate UDF is called against Columnstore table
- MCOL-1984 - SystemConfig / WaitPeriod change lost during upgrade
- MCOL-2001 - mscadmin redistributeData parameters are not accepted as suggested by the help information.
- MCOL-2035 - Some regr_* tests aren't deterministic so comparisons are iffy. RANK()
- MCOL-2061 - MariaDB shows warnings and could crash on DDL after upgrade
- MCOL-2089 - High CPU usage and slow performance appears when load data with remote mcsimport
- MCOL-2091 - UDAF doesn't work if there are two count(distinct) in projection list
- MCOL-2244 - There is no way to identify execution thread that causes bottleneck
- MCOL-2267 - Query with SUM() erroring - /rowgroup.h@677: assertion '0' failed
- MCOL-2273 - getSystemDisk showing incorrect root usage and reporting incorrect alarm
- MCOL-3249 - Probably Kafka DA produces '\0' in the end of TEXT or VARCHAR with width > 7
- MCOL-3268 - javamcsapi compatibility test fails
- MCOL-3293 - UPDATE performance improvement contribution
- MCOL-3296 - ctrl+c sometimes leaves DMLProc in bad state
- MCOL-3307 - Non-Columnstore Window function causes debug assert
- MCOL-3311 - regression test212 logs integer expression expected error
- MCOL-3318 - RPM warnings appear when installing ColumnStore's MariaDB Server
- MCOL-593 - support columnstore tables as slaves to innodb master tables
- MCOL-1254 - Add hidden switch for MariaDB async replication
- MCOL-2013 - API .NET support - Alpha
- MCOL-2076 - Allow simple replication to ColumnStore
- MCOL-2129 - Add a new postConfigure flag to resolve submitted hostnames to correct reverse dns names
- MCOL-3267 - Support ORDER BY within UNION subqueries
- MCOL-3270 - Improve cpimport ingest speed into Dictionary columns
- MCOL-2068 - add support for using and defaulting memory based settings to docker image
- MCOL-3315 - Rebase on MariaDB 10.3.15
In addition, all bugs fixed in MariaDB ColumnStore 1.2.3 and earlier are implicitly included in this release.
The following procedure outlines upgrading a 1.1.7 ColumnStore install to 1.2.4:
Multi version upgrades generally will work using the same procedure however we can't test every possible permutation so you should test your specific scenario outside of production first if you wish to try this (and this is good practice regardless).
Known issues and limitations
There are a number bugs and known limitations within this version of MariaDB ColumnStore, the most serious of these are listed below.
- MCOL-1990 - localquery mode tries to turn on replication and fails.
MariaDB ColumnStore Documentation
RPM, Debian, and binary packages are provided for the Linux distributions supported by MariaDB ColumnStore 1.2.4 GA version.
- The supported OS for the GA version are CentOS 6, CentOS 7, Debian 8, Debian 9, RedHat 6, RedHat 7, SUSE 12, Ubuntu 16.04 and Ubuntu 18.04.
- Packages can be downloaded here or can be installed from the repositories.
- An Amazon AWS AMI Image is available for this release, please search for AMI name "MariaDB-ColumnStore-1.2.4". AMI specific installation instructions can be found here.
- Certified to run in Google Cloud Environment in the GA OSs.
The source code of MariaDB ColumnStore is tagged at GitHub with a tag, which is identical with the version of MariaDB ColumnStore. For instance, the tag of version X.Y.Z of MariaDB ColumnStore is columnstore-X.Y.Z. Further, master always refers to the latest released non-beta version.
The source code is available at these locations
- Storage Engine - Source code for engine specific processes on UM and PM node
- MariaDB Server - Source code based on MariaDB Server 10.3.15 modified to support the ColumnStore storage engine
- Tools - Source code for MariaDB ColumnStore Tools
- Write Data API - Source code for Write Data API /SDK
- MaxScale CDC and Kafka Data Adapters - Source Code for data adapters