matrixone-v0.6.0

We are excited to announce MatrixOne 0.6.0 release. In this release, MatrixOne has upgraded to a disaggregated compute and storage architecture, with a cloud native HTAP engine and many new features. Cheers!

Docker

docker pull matrixorigin/matrixone:0.6.0

Features

• Support distributed ACID transaction with a Snapshot Isolation level.
• Support TEXT, BLOB, TIME, JSON data type.
• Support multi-tenancy with account, user and role.
• Support VIEW.
• Support Java, Python, Golang connector and Mybatis, Spring JPA, SQLAlchemy ORM connection.
• Support import CSV and JSON data from local file system and cloud S3 storage.
• Implemented a MatrixOne dedicated backup tool modump.
• Support composite primary key, unique key and auto-increment constraint.
• Add system_metrics database in the catalog to monitor instance status.
• Add system database in the catalog to record user statements and system logs.
• Support timezone.
• Support TLS encrypted connection.
• Support pre-compilation statements PREPARE, EXECUTE, DEALLOCATE.
• Support EXPLAIN ANALYZE.
• Support UNION, UNION ALL, INTERSECT, MINUS operators.
• Support TEMPORARY TABLE.
• Support EXTERNAL TABLE.
• Support PARTITION BY.
• Add many system variables and tables to maintain MySQL compatibility.
• Add many new JSON, Datetime functions.

Known Issues:

• 0.6.0 data format is not compatible with the previous versions.
• Transactional performance doesn't compete with mature DBMS products.
• Composite Primary Key, Unique Key and Secondary Key doesn't improve any performance #6028 .
• Insert/update into select having more than 100MB data will fail in a distributed setting #6780.
• Execute load data in a loop may cause out of memory #6793.
• Data race happens in a distributed setting #6855, #6926.
• Background jobs have a low probability causing user transaction being aborted due to r-w conflict #6049.
• Insert file into BLOB type might fail #6302.

Contributors

This release includes 1520 commits by 97 authors.

New Contributors

• @lokax made their first contribution in #4186
• @triump2020 made their first contribution in #4414
• @Abirdcfly made their first contribution in #4450
• @yjw1268 made their first contribution in #4472
• @Juneezee made their first contribution in #4609
• @ZoranPandovski made their first contribution in #4767
• @Toms1999 made their first contribution in #4778
• @xy2398437254 made their first contribution in #4927
• @goodMan-code made their first contribution in #5033
• @DanielZhangQD made their first contribution in #5140
• @taofengliu made their first contribution in #5349
• @TszKitLo40 made their first contribution in #5333
• @TheR1sing3un made their first contribution in #5352
• @qqIsAProgrammer made their first contribution in #5382

Full Changelog

v0.5.1...v0.6.0