Hyperconverged cloud-edge native database
We are excited to announce MatrixOne 0.8.0 release. After four months' development, MatrixOne completed its architecture design with Proxy module, which ensures workload and tenant isolation. MatrixOne has also made much improvement with its OLTP and OLAP performance, along with its scalability, stability and user experience. This is also a Beta release, open for developers for testing and feedback. Cheers!
docker pull matrixorigin/matrixone:0.8.0
-OLTP performance: 3-7x improvement, reaching MySQL performance in standalone version. -OLAP performance: SSB and TPCH performance align with Snowflake and Clickhouse. -Scalability: archiving near-linear performance growth with CN horizontal scaling.
-Backward compatibility of data storage format. -Deployment and administration tool for both standalone and distributed version. -Improved MySQL compatibility in case sensitivity, information_schema and DDL statements. -Read committed with pessimistic locking implemented in transaction mode. (Experimental)
-Support window function RANK()
, ROW_NUMBER()
and DENSE_RANK()
-Support the BINARY
type and related functions.
-Support data sharing between tenants and PUBLISH
/SUBSCRIBE
functions.
-Support INSERT...ON DUPLICATE KEY UPDATE
statement.
-Add Sequence
and related statements.
-Support ADD [COLUMN] | DROP [COLUMN]
in the ALTER TABLE
statement.
-Support multi-layer foreign key.
-Support RAND()
built-in function.
-Support setting global variables in configuration files.
-Secure initial MatrixOne account by password replacement.
-Several types of partitioning are supported. (Experimental)
-0.8.0 data format is not compatible with the previous versions.
-Secondary Key doesn't improve any performance.
-Memory leak occasionally happens and may lead to an OOM
error.
-Workload isolation is only supported by JDBC.
-DN is a single point of failure for distributed version.
-Occasional system hung under high concurrency workload.
-Pessimistic transaction has a few fatal bugs remaining.
Full Changelog: https://github.com/matrixorigin/matrixone/compare/v0.7.0...v0.8.0
We are excited to announce MatrixOne 0.7.0 release. MatrixOne has made much progress with its stability and performance in this release, along with an increase in MySQL compatibility and many new features. Cheers!
docker pull matrixorigin/matrixone:0.7.0
-Support foreign key -Support adding "cluster by" in DDL statements -Add a MYSQL_COMPATBILITY_MODE to manage MySQL-compatible behaviors -Improve Unique Index behavior -Support to load data from the client machine -Support Alter View -Add query_result() function to get saved query results -Support account suspending -Support system table sharing to accounts -Add aggregation function: group_concat -Add built-in functions: format, replace, curdate, field, substring_index
-0.7.0 data format is not compatible with the previous versions. -Transactional performance doesn't compete with mature DBMS products. -Secondary Key doesn't improve any performance. -Only support up to 100GB benchmark testing. -Out of memory(OOM) error or context deadline will occur after 5 hours of frequent testing. -Query as count(*) performance is unsatisfactory. -Loading several GB tables in distributed cluster will result in OOM error.
This release includes 656 commits by 43 authors.
https://github.com/matrixorigin/matrixone/compare/v0.6.0...v0.7.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 pull matrixorigin/matrixone:0.6.0
modump
.system_metrics
database in the catalog to monitor instance status.system
database in the catalog to record user statements and system logs.This release includes 1520 commits by 97 authors.
https://github.com/matrixorigin/matrixone/compare/v0.5.1...v0.6.0
This release resolved some log replaying and storage GC issues.
docker pull matrixorigin/matrixone:0.5.1
These bugs are fixed by PRs below.
These bugs lead to some stability issues of a MatrixOne instance.
An upgrade from 0.5.0 to 0.5.1 only requires to replace the mo-server
binary file.
We are excited to announce MatrixOne 0.5.0 release. In this release, MatrixOne has a stand-alone columnar storage engine which can support HTAP workloads. Cheers!
docker pull matrixorigin/matrixone:0.5.0
This release includes 811 commits by 73 authors.
We appreciate your contribution! Welcome to MatrixOne community.
https://github.com/matrixorigin/matrixone/compare/v0.4.0...v0.5.0
We are excited to announce MatrixOne 0.4.0 release. Cheers!
docker pull matrixorigin/matrixone:0.4.0
This release includes 259 commits by 50 authors.
We appreciate your contribution! Welcome to MatrixOne community.
https://github.com/matrixorigin/matrixone/compare/v0.3.0...v0.4.0
We are excited to announce MatrixOne 0.3.0 release. Cheers!
docker pull matrixorigin/matrixone:0.3.0
This release includes 157 commits by 21 authors.
We appreciate your contribution! Welcome to MatrixOne community.
https://github.com/matrixorigin/matrixone/compare/v0.2.0...v0.3.0
We are excited to announce MatrixOne 0.2.0 release. Cheers!
docker pull matrixorigin/matrixone:0.2.0
This release includes 243 commits by 21 authors.
We are excited to announce the first release of MatrixOne 0.1.0 on 2021/10/24. Cheers!
docker pull matrixorigin/matrixone:0.1.0
Following SQL statements are supported in this release.
This release includes 453 commits by 16 authors. Special thanks to the first author: Yan Wenze (@nnsgmsone)