AliSQL
AliSQL is a MySQL branch originated from Alibaba Group. Fetch document from Release Notes at bottom.
What is AliSQL?
AliSQL is a MySQL branch originated from Alibaba Group. Fetch document from Release Notes at bottom.
Overview of AliSQL
What it is
AliSQL is an open-source MySQL branch maintained by the Alibaba Cloud Database Team. This release is based on MySQL 8.0.44 and adds a DuckDB analytical storage engine, HNSW vector indexes, Native Flashback, binlog realtime replication (BRR), and binlog optimizations while retaining the MySQL client protocol.
Key features
- DuckDB Storage Engine: Columnar execution and storage for analytical tables, with automatic compression.
- Vector Index (VIDX): Native vector storage and ANN search with HNSW, supports COSINE and EUCLIDEAN distance.
- Native Flashback: Query historical InnoDB data with AS OF TIMESTAMP and retained undo snapshots.
- Large TX Optimization: Binlog Cache Free Flush reduces commit-time I/O amplification for large InnoDB transactions.
- Binlog Durability: Persist Binlog Into Redo V2 reduces synchronous binlog I/O while retaining crash recovery.
- Binlog Realtime Replication (BRR): Transmit eligible large transactions before commit and optionally apply supported DDL and transactions early on replicas.
Use cases
Analytical queries on large datasets using the DuckDB engine, AI applications requiring vector similarity search (e.g., document embeddings), historical data recovery with point-in-time queries, and high-throughput transaction processing with optimized binlog handling.
Getting started
bash# Clone the repositorygit clone https://github.com/alibaba/AliSQL.gitcd AliSQL# Build (release mode)sh build.sh -t release -d ~/alisql# Installmake install# Initialize data directory~/alisql/bin/mysqld --initialize-insecure --datadir=~/alisql/data# Start the server with DuckDB enabled~/alisql/bin/mysqld --datadir=~/alisql/data --duckdb_mode=ON
License and pricing
The license is not explicitly stated in the repository (NOASSERTION). The project is open source.
Based on the project's public README and repository metadata.