alibaba /AliSQL
AliSQL is a MySQL branch originated from Alibaba Group. Fetch document from Release Notes at bottom.
★ 5,993⑂ 905👁 460⑃ 19● 163▤ 12
+0
Daily
5,993
stars
905
forks
460
watchers
19
prs
163
issues
12
releases
README
AliSQL Alibaba's MySQL Branch with DuckDB Analytics and Native Vector Search Based on MySQL 8.0.44 and maintained by Alibaba Cloud Database Team Features • Quick Start • Docs • Roadmap • Contributing 简体中文 | English About AliSQL AliSQL is an open-source MySQL branch maintained by 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. The 2026-10-16 update introduces BRR and upgrades the embedded DuckDB snapshot to v1.5.2-dev736, with optional AUTO_INCREMENT and background checkpoints. Analytics Reference Results The included TPC-H SF100 results show more than 200x speedup over InnoDB for several queries in that test environment Native Vector Indexes The VECTOR(N) type and HNSW indexes support vectors with up to 16,383 dimensions MySQL Client Compatibility Applications connect through the MySQL protocol and continue to use MySQL clients and drivers Key Features | Feature | Description | Status | |---------|-------------|--------| | DuckDB Storage Engine | Columnar execution and storage for analytical tables, with automatic compression | Available | | Vector Index (VIDX) | Native vector storage & ANN search with HNSW, supports COSINE & EUCLIDEAN distance | Available | | Native Flashback | Query historical InnoDB data with AS OF TIMESTAMP and retained undo snapshots | Available | | Large TX Optimization | Binlog Cache Free Flush reduces commit-time I/O amplification for large InnoDB transactions | Available | | Binlog Durability | Persist Binlog Into Redo V2 reduces synchronous binlog I/O while retaining crash recovery | Available | | Binlog Realtime Replication (BRR) | Transmit eligible large transactions before commit and optionally apply supported DDL and transactions early on replicas | Available, opt-in | | DDL Optimization | Instant DDL, parallel B+tree construction, non-blocking locks | Planned | | RTO Optimization | Accelerated crash recovery for faster instance startup | Planned | Free Flush targets eligible InnoDB transactions while DuckDB mode is inactive. With DuckDB mode enabled, commit uses the dedicated DuckDB path. BRR reuses Free Flush cache files; this does not by itself imply a Free Flush commit. Quick Start Option 1: Build from Source bash Clone the repository git clone https://github.com/alibaba/AliSQL.git cd AliSQL Build (release mode) sh build.sh -t release -d ~/alisql Install make install Option 2: Set Up a DuckDB Analytical Node Step-by-step guide: How to set up a DuckDB node Initialize & Start Server bash Initialize data directory ~/alisql/bin/mysqld --initialize-insecure --datadir=~/alisql/data Start the server with DuckDB enabled for the example below ~/alisql/bin/mysqld --datadir=~/alisql/data --duckdb_mode=ON Usage Examples Du
Top issues
#124Error during DuckDB node deployment18 comments · 2026-02-05#129mysqld crash at Dir_Walker::is_directory for debug builds4 comments · 2026-03-25#157Corrupt database file3 comments · 2026-06-27#138cannot be converted from type 'varchar(6000(bytes))' to type 'mediumtext'3 comments · 2026-04-07#146部分配置情况下开启主从复制线程会导致服务hang住2 comments · 2026-05-09#123Does it work with strict mode = off?2 comments · 2026-02-04#170Deployment Architecture Issues1 comments · 2026-07-21#156VECTOR INDEX with M=200 returns farthest candidates on 1D monotonic vectors1 comments · 2026-05-29
Discussions
Latest release
AliSQL-8.0.44-3 AliSQL-8.0.44-3 2026-10-16AliSQL 8.0.44-3 Prebuilt AliSQL binaries for Linux x86_64 and aarch64 (glibc 2.17). Binary Packages | Platform | Package | | --- | --- | | Linux x86_64 | alisql-8.0.44-3-linux-glibc2.17-x86_64.tar.xz | | Linux aarch64 | alisql-8.0.44-3-linux-glibc2.17-aarch64.tar.xz | Docker Image The linux/amd64 and linux/arm64 image is built after both binary packages are published. - Image: songhuaxiong/alisql:8.0.44-3 - Build status: GitHub Actions bash docker pull songhuaxiong/alisql:8.0.44-3 Changelog English changelog | Chinese changelog This update adds binlog realtime replication (BRR),