MatrixOne
activeby MatrixOrigin · since 2021 · also known as MatrixOrigin MatrixOne, MatrixOne Cloud
MySQL-compatible cloud-native HTAP database on object storage, with vector search and snapshots.
Overview
MatrixOne is an open-source hyper-converged database from MatrixOrigin, written in Go. It separates stateless compute nodes from a shared log service and object storage (S3-compatible), and uses a single columnar storage format for both transactional and analytical queries, aiming to replace a MySQL plus warehouse combination with one engine. It speaks the MySQL protocol, supports vector types and indexes for AI retrieval, and offers snapshots and point-in-time restore that act like time travel for data. MatrixOrigin also runs a managed MatrixOne Cloud. Adoption is concentrated in China and the project is younger than TiDB or OceanBase, so evaluate maturity carefully.
Strengths & trade-offs
Strengths
- +One engine for transactional and analytical queries over columnar storage
- +Compute/storage separation on cheap object storage
- +MySQL protocol compatibility for existing tools
- +Vector types and indexes for AI retrieval in SQL
- +Snapshots and PITR for data recovery
Trade-offs
- −Young project with frequent breaking changes between releases
- −MySQL compatibility gaps (no triggers or stored procedures)
- −Small community outside China
- −Point-write latency higher than row-store OLTP databases
Great for
- +Consolidating MySQL plus a warehouse into one HTAP engine
- +IoT and time-series ingestion with analytics
- +RAG applications needing vectors and SQL together
- +Cost-sensitive analytics on object storage
Think twice for
- −Mission-critical OLTP needing long production track record
- −Apps relying on MySQL triggers or procedures
- −Edge or embedded use
Capabilities
Native or official first-party support · 13 of 25 tracked
Scale & consistency
- Comfortable data size
- Medium · ≤ 10 TB
- Horizontal scaling
- Native
- Multi-region
- No
- Transactions
- Full ACID
- Consistency
- Strong
- Schema
- Strict
- Architecture
- Distributed, Shared storage, Client server, Serverless
- Query languages
- SQL
Compute nodes scale independently over shared object storage; log service replicated with Raft.
Deployment
available on · AWS · Alibaba Cloud
Ecosystem
Alternatives to MatrixOne
MySQL-compatible distributed SQL with a row store for OLTP and a columnar replica for real-time analytics.
matrixone vs tidb →Alipay-proven distributed SQL with MySQL (and Oracle, in Enterprise) compatibility, HTAP and vector search.
matrixone vs oceanbase →Distributed SQL mixing in-memory rowstore and columnstore for real-time analytics, search and vectors.
matrixone vs singlestore →MPP OLAP database with a fast vectorized engine, real-time upserts and native lakehouse queries.
matrixone vs starrocks →Real-time MPP analytical database with MySQL compatibility, search indexes and lakehouse access.
matrixone vs apache-doris →Rust-built cloud data warehouse on object storage, open source with a managed Databend Cloud.
matrixone vs databend →MatrixOne FAQ
What is MatrixOne?
MatrixOne is a relational database by MatrixOrigin, first released in 2021. MatrixOne is an open-source hyper-converged database from MatrixOrigin, written in Go. It separates stateless compute nodes from a shared log service and object storage (S3-compatible), and uses a single columnar storage format for both transactional and analytical queries, aiming to replace a MySQL plus warehouse combination with one engine. It speaks the MySQL protocol, supports vector types and indexes for AI retrieval, and offers snapshots and point-in-time restore that act like time travel for data. MatrixOrigin also runs a managed MatrixOne Cloud. Adoption is concentrated in China and the project is younger than TiDB or OceanBase, so evaluate maturity carefully.
Is MatrixOne open source?
Yes. MatrixOne is open source. License: Apache License 2.0.
Does MatrixOne support ACID transactions?
Yes. MatrixOne supports full ACID transactions, with strong consistency.
Does MatrixOne scale horizontally?
MatrixOne scales horizontally out of the box, with built-in sharding or partitioning. It is comfortable at medium scale (≤ 10 TB).
How can I run MatrixOne?
You can self-host it, use the vendor's managed cloud and run it serverless. Managed offerings include MatrixOne Cloud. It is available on AWS and Alibaba Cloud.
What is MatrixOne best for?
MatrixOne is a strong fit for consolidating MySQL plus a warehouse into one HTAP engine; IoT and time-series ingestion with analytics; and RAG applications needing vectors and SQL together. Think twice for mission-critical OLTP needing long production track record.
What are the best alternatives to MatrixOne?
Common alternatives to MatrixOne include TiDB, OceanBase, SingleStore, StarRocks and Apache Doris. The right choice depends on your workload, scale and hosting; WhichDB's smart match ranks them against your requirements.
How popular is MatrixOne?
MatrixOne ranks #369 of 844 databases on the WhichDB Score (6.1/100), and #118 among relational databases. The score combines public adoption signals such as package downloads, GitHub activity, job posts and developer discussion.