PolarDB-X is a distributed SQL database designed to support high concurrency, large datasets and complex database workloads. Developed by Alibaba, it combines relational database functionality with a distributed architecture that allows data to be partitioned across multiple storage nodes.
The database separates computing from storage and uses a shared-nothing architecture. Its SQL processing layer coordinates queries and transactions across the distributed system while presenting a MySQL-compatible interface to applications.
PolarDB-X supports transactional and analytical workloads through a combination of distributed transaction processing and massively parallel query execution. The system comprises several components, including compute nodes, data nodes, global metadata services and change data capture facilities. The PolarDB-X SQL repository contains the compute-node component.
This is free and open source software.
Key Features
- Distributed SQL database with horizontal scalability through hash and range-based data sharding.
- MySQL protocol compatibility supports existing MySQL clients, tools and much of the SQL dialect.
- Distributed transactions use multiversion concurrency control (MVCC), timestamp ordering and two-phase commit.
- Hybrid transactional and analytical processing (HTAP) combines OLTP operations with analytical queries.
- Massively parallel processing (MPP) distributes analytical query execution across multiple nodes.
- Compute nodes handle SQL parsing, optimisation, execution and distributed query routing.
- Global metadata services maintain consistent schema information, statistics and transaction timestamps.
- Change data capture provides MySQL-compatible binary logs and replication interfaces.
- Multi-Paxos replication supports strongly consistent data storage and high availability.
- Additional capabilities include global secondary indexes, SQL concurrency control, transparent data encryption and flashback queries.
Website: github.com/polardb/polardbx-sql
Support:
Developer: Alibaba Cloud
License: Apache License 2.0
PolarDB-X is written in Java. Learn Java with our recommended free books and free tutorials.
Related Software
| Relational Databases | |
|---|---|
| MariaDB | High compatibility with MySQL, ensuring drop-in replacement capability |
| PostgreSQL | Award winning Object-relational database management system |
| MySQL | Multithreaded, multi-user SQL database management system |
| SQLite | Embeddable SQL Database Engine |
| TiDB | Cloud-native, distributed SQL database |
| DuckDB | In-process SQL OLAP database management system |
| Turso | In-process relational database engine |
| YugabyteDB | PostgreSQL-compatible distributed SQL database |
| rqlite | Distributed database built on SQLite |
| MonetDB | High performance relational database system for analytics |
| Dolt | Version-controlled SQL database |
| Firebird | Relational database offering many ANSI SQL features |
| H2 | Relational database management system written in Java |
| HSQLDB | JDBC interface, client-server version, query tool, grid and more |
| CUBRID | Database engine with built-in enterprise grade features |
| Apache Cloudberry | Massively parallel processing database |
| Virtuoso | Data Management with Web Application Server and Web Services |
| Apache Derby | Full-featured relational database implemented entirely in Java |
Read our verdict in the software roundup.
 LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |
Please read our Comment Policy before commenting.