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
C++NOASSERTIONCreated 2016-07-27
Download: AliSQL-8.0.44-3AliSQL-8.0.44-3 ↓32026-10-16
+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

Discussions

Latest release

AliSQL-8.0.44-3 AliSQL-8.0.44-3 2026-10-16
AliSQL 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), 

Snapshot: 2026-11-16T09:23:14Z · Data license Apache-2.0 · JSON