MatrixOne v220.6.0 Release Notes
We are excited to announce MatrixOne v22.0.6.0 release on 2022/11/29. 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
- @triump2020
- @Abirdcfly
- @yjw1268
- @Juneezee
- @ZoranPandovski
- @Toms1999
- @xy2398437254
- @goodMan-code
- @DanielZhangQD
- @taofengliu
- @TszKitLo40
- @TheR1sing3un
- @qqIsAProgrammer
We appreciate your contribution! Welcome to MatrixOne community.
Full Changelog
https://github.com/matrixorigin/matrixone/compare/v0.5.1...v0.6.0