We are excited to announce MatrixOne 1.2.0 release!
MatrixOne is a hyper-converged cloud-native database. It is designed to provide a cloud-native, high-performance, highly scalable, MySQL-compatible HTAP database. MatrixOne enables users to handle mixed workloads such as transactions, analytics, time-series, and streaming processing through a one-stop data processing solution.
What's New in v1.2.0?
Snapshot Backup and Restore (Beta)
Database snapshot is an efficient technology for database backup and recovery, providing a read-only static copy of the database at a specific point in time. It assists database administrators and developers in performing various operations while ensuring the consistency and integrity of the data.
- Support for tenant-level snapshot backup and restore using the mo_br tool and sql statement.
- Support for uninterrupted database operation during the snapshot creation process.
- Support for rapidly restoring data to the state at the time of backup, effectively reducing the Recovery Time Objective (RTO).
Incremental Physical Backup(Enterprise Edition)
On the basis of full backup in the mo_backup tool, we support for incremental backup feature , which only backs up the newly changed data, significantly reducing the backup time and storage space requirements.
CTAS
Support for CTAS (Create Table As Select).CTAS is an SQL statement used to quickly create a new table based on existing data. It combines the functionality of table creation with a select query, providing an efficient way to create snapshots of tables, perform data transformations, or build data models for reporting and analysis.
BITMAP Fast Deduplication
BITMAP is a set of built-in functions for handling bitmaps, mainly used for rapid deduplication of large volumes of data.
- Support for rapid data deduplication using BITMAP functions.
- Support for determining the bucket number with the BITMAP_BUCKET_NUMBER() function.
- Support for returning the relative bit position within a bucket using the BITMAP_BIT_POSITION() function.
- Support for constructing bitmaps with the BITMAP_CONSTRUCT_AGG() function.
Vector Index
- Support for using vector indexing to accelerate KNN queries.
Other New Features
SQL Statements
- Support for
INSERT IGNORE - Support for
CREATE TABLE ... LIKE - Support for
CREATE INDEX ... USING IVFFlat - Support for
ALTER TABLE ... ALTER REINDEX - Support for
LOAD DATA ... CHARACTER SET - Support for
CREATE SNAPSHOT - Support for
SHOW SNAPSHOTS - Support for
RESTORE ACCOUNT - Support for
DROP SNAPSHOT - Optimized
ALTER PUBLICATION - Optimized
SHOW PUBLICATIONS - Optimized
SHOW SUBSCRIPTIONS
Date Type
- Support for
bit
Indexes and Constraints
- Support for Vector Index
Built-in Functions and Operators
- Added SYSDATE date function.
- Added TO_BASE64 and FROM_BASE64 encoding and decoding functions.
- Added MD5 and SHA1/SHA encryption functions.
- Added SUBVECTOR function for extracting subvectors.
- Added SERIAL_EXTRACT function for extracting sub-elements.
- Added CLUSTER_CENTERS cluster centers function.
- Support operations between vector and scalar.
System Parameters
- Added keep_user_target_list_in_result.
- Added foreign_key_checks.
MySQL Compatibility
- Refactored the CSV reader and CSV splitting to maintain compatibility with MySQL.
Known Issues
- Vector Index works only in l2_distance.
- Only support tenant-level snapshot backup and restore.
- Snapshot restore works as logical restore, requiring quite a lot of CPU and memory resources.
- Memory leak occasionally happens and may lead to an OOM error.
- Occasional system hung under high concurrency workload.
Full Changelog:v1.1.3...v1.2.0