MyCATApache/Mycat2

Health v2 · maintenance only

Adoption not part of the score

1733 stars · 476 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

Mycat2 is a distributed database middleware written in Java that acts as a MySQL-protocol-compatible proxy, providing transparent data sharding, distributed SQL queries, and read/write splitting across multiple backend databases. It uses a Calcite-based query optimizer and Java NIO/Vert.x for asynchronous, high-throughput connection handling.

Use cases

• shard a large MySQL table across multiple database nodes transparently
• scale out MySQL reads with read-write splitting behind a single endpoint
• run distributed SQL joins across sharded MySQL databases
• add a proxy layer in front of MySQL or MariaDB without changing client applications
• implement XA distributed transactions across multiple database slices
• migrate a monolithic MySQL database to a horizontally scaled cluster

When to choose

• you need MySQL-compatible sharding middleware in the Java ecosystem
• you want transparent horizontal scaling of MySQL without rewriting application SQL
• you need read/write splitting and load balancing across MySQL replicas
• you require distributed transactions (XA) across sharded backends

When to avoid

• you use a database other than MySQL/MariaDB as your primary backend
• you need a fully managed distributed SQL database rather than middleware
• your project requires active community development - releases have slowed since 2023
• you need non-Java 8 runtime support, which is not yet available

Facets

service · maturity maintenance

database proxy routing middleware databases microservices backend developer-tools jvm cross-platform self-hosted mysql-proxy database-sharding sql-middleware read-write-splitting calcite xa-transactions sql linux

Member repositories

For agents

markdown · JSON · MCP: product_card(name="MyCATApache/Mycat2")