AliSQL is Alibaba's MySQL branch, forked from official MySQL and used extensively in Alibaba Group's production environment. It includes various performance optimizations, stability improvements, and features tailored for large-scale applications.
Quickly build your DuckDB node: How to set up a DuckDB node
- AliSQL Version: 8.0.44 (LTS)
- Based on: MySQL 8.0.44
-
DuckDB Storage Engine:AliSQL integrates DuckDB as a native storage engine, allowing users to operate DuckDB with the same experience as MySQL. By leveraging AliSQL for rapid deployment of DuckDB service nodes, users can easily achieve lightweight analytical capabilities.
-
Vector Storage:AliSQL natively supports enterprise-grade vector processing for up to 16,383 dimensions. By integrating a highly optimized HNSW algorithm for high-performance Approximate Nearest Neighbor (ANN) search, AliSQL empowers users to build AI-driven applications—such as semantic search and recommendation systems—seamlessly using standard SQL interfaces.
-
DDL Optimization (planned):AliSQL delivers a faster, safer, and lighter DDL experience through innovations such as enhanced Instant DDL, parallel B+tree construction, a non-blocking lock mechanism, and real-time DDL apply—significantly improving schema change efficiency and virtually eliminating replication lag.
-
RTO Optimization (planned):AliSQL deeply optimizes the end-to-end crash recovery path to accelerate instance startup, shorten RTO, and restore service quickly.
-
Replication Optimization (planned): AliSQL significantly boosts replication throughput and minimizes lag by implementing Binlog Parallel Flush, Binlog in Redo, and specialized optimizations for large transactions and DDL operations.
Prerequisites:
- CMake 3.x or higher
- Python3
- C++17 compliant compiler (GCC 7+ or Clang 5+)
Build Instructions:
# Clone the repository
git clone https://github.com/alibaba/AliSQL.git
cd AliSQL
# Build the project (release build)
sh build.sh -t release -d /path/to/install/dir
# For development/debugging (debug build)
sh build.sh -t debug -d /path/to/install/dir
# Install the built MySQL server
make installBuild Options:
-t release|debug: Build type (default: debug)-d <dest_dir>: Installation directory (default: /usr/local/alisql or $HOME/alisql)-s <server_suffix>: Server suffix (default: alisql-dev)-g asan|tsan: Enable sanitizer-c: Enable GCC coverage (gcov)-h, --help: Show help
For DuckDB-specific support, see the DuckDB Support Options.
AliSQL 8.0 became an open-source project in December 2025 and is actively maintained by engineers at Alibaba Group.
Contributions are welcome! Please:
- Fork the repository
- Create a feature branch
- Make your changes with appropriate tests
- Submit a pull request
For bug reports and feature requests, please use the GitHub Issues page.
This project is licensed under the GPL-2.0 license. See the LICENSE file for details.
AliSQL is based on MySQL, which is licensed under GPL-2.0. The DuckDB integration follows the same licensing terms.