AliSQL

alibaba/AliSQL: AliSQL is a MySQL branch originated from Alibaba Group. Fetch document from Release Notes at bottom.

by

AliSQL is Alibaba’s MySQL branch, built from the official MySQL and used extensively in Alibaba Group’s production environments. It includes various performance optimizations, stability improvements, and features designed for large-scale applications.

🚀 Quick Start (DuckDB)

Quickly create 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 an experience similar to MySQL. By leveraging AliSQL for rapid deployment of DuckDB service nodes, users can easily gain 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-powered applications – such as semantic search and recommendation systems – using the standard SQL interface.

  • ddl optimization (planned):AliSQL provides a fast, secure, and lightweight DDL experience through innovations like improved instant DDL, parallel B+tree construction, a non-blocking lock mechanism, and real-time DDL apply – which significantly improves schema change efficiency and virtually eliminates replication lag.

  • rto customization (planned):AliSQL deeply optimizes the end-to-end crash recovery path to speed up instance startup, shorten RTO, and quickly restore service.

  • replication optimization (planned): AliSQL significantly increases replication throughput and reduces lag by implementing special optimizations for binlog parallel flushes, redo in the binlog, and larger transactions and DDL operations.

Prerequisites: :

  • CMake 3.x or higher
  • Python3
  • C++17 compliant compiler (GCC 7+ or Clang 5+)

manufacturing 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 install

make choices: :

  • -t release|debug:build type (default: debug)
  • -d :installation directory (default: /usr/local/alisql or $HOME/alisql)
  • -s :server suffix (default: alisql-dev)
  • -g asan|tsan:Enable Sanitizer
  • -c:Enable GCC Coverage (gcov)
  • -h, --help: show help

For DuckDB-specific support, see DuckDB Support Options.

AliSQL 8.0 became an open-source project in December 2025 and is actively maintained by Alibaba Group engineers.

Contributions welcome! Please:

  1. fork the repository
  2. create a feature branch
  3. Make your changes with proper tests
  4. 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.



<a href

Leave a Comment