AliSQL: Alibaba's open-source MySQL with vector and DuckDB engines
AliSQL is Alibaba's specialized open-source branch of MySQL, specifically forked and optimized for massive-scale production environments. The latest release, version 8.0.44 (LTS), introduces significant enhancements including the native integration of DuckDB as a storage engine, which provides users with lightweight analytical capabilities using standard SQL interfaces. Furthermore, AliSQL now supports enterprise-grade vector storage with up to 16,383 dimensions, utilizing an optimized HNSW algorithm for high-performance Approximate Nearest Neighbor search, making it a powerful tool for AI-driven applications like semantic search. The project roadmap includes ambitious improvements to DDL efficiency, recovery time objectives (RTO), and replication throughput via parallel processing. These features aim to reduce latency and eliminate replication lag, ensuring high availability and stability for modern, data-intensive organizations.