- Home
- Database Proxy Software
- Mycat2
Mycat2
What it is
Mycat2 is free, open-source distributed relational database middleware for Linux and self-hosted deployments. It handles distributed SQL queries and the MySQL communication protocol, while connecting with multiple backend databases through the Java ecosystem. Its distributed query engine supports MySQL syntax and value types, rule-based and cost-based optimization, and an independent physical execution engine. Data fragmentation is described as improving query processing. Sharding, serial-number, and load-balancing algorithms can be customized and loaded. A project DSL can manipulate physical query plans, forward SQL, and cache result sets. Mycat2 includes connection pooling, query routing, and load balancing. The README lists Java 8 as its current runtime requirement. Release v1.22-2022-6-25 supports ClickHouse for SELECT and INSERT, without returning auto-increment values. That release also lists SQL permission interception, RSA encryption for user.json, and inactive-connection recycling with a 180-second default timeout.
For and against
For
- Free open-source software
- Supports distributed SQL queries
- Customizable sharding and load balancing
- ClickHouse backend support listed
- Connection pooling and query routing
Against
- Java 8 only
- Self-hosted deployment required
- Latest listed release is v1.22-2022-6-25
The verdict
Mycat2 combines distributed query processing with configurable routing, sharding, and backend integration. Its Java 8 requirement and self-hosted Linux model are important deployment considerations.
Who it suits
Mycat2 suits teams running Linux or self-hosted database middleware that need distributed SQL, routing, pooling, and customizable sharding. It is aimed at users working with MySQL or JDBC-backed databases and Java 8.
Plans and prices
Mycat2
Open-source software · Java 8 supported
Read 9 Oct 2026 · github.com
On the record
- Backends
- It supports multiple backend databases through the Java ecosystem.github.com · read 9 Oct 2026
- Connection handling
- The release notes describe automatic checking and recycling of inactive backend connections, with a default timeout of 180 seconds.github.com · read 9 Oct 2026
- Customization
- Sharding, serial number, and load balancing algorithms can be customized and loaded.github.com · read 9 Oct 2026
- Database integration
- The v1.22 release notes say ClickHouse is supported as a backend data source, with SELECT and INSERT supported and no auto-increment value returned.github.com · read 9 Oct 2026
- Download
- The release page lists v1.22-2022-6-25 as the latest release.github.com · read 9 Oct 2026
- License
- The repository identifies the project license as Apache License from 2023.8.github.com · read 9 Oct 2026
- Product
- Mycat2 is a distributed relational database middleware that supports distributed SQL queries and the MySQL communication protocol.github.com · read 9 Oct 2026
- Query controls
- A project DSL manipulates physical query plans and supports SQL forwarding and result set caching.github.com · read 9 Oct 2026
- Runtime
- The README says Mycat2 currently supports Java 8 only.github.com · read 9 Oct 2026
- Security feature
- The v1.22 release notes list SQL-type permission interception and RSA encryption support for user.json configuration.github.com · read 9 Oct 2026
- Sharding
- The project says data fragmentation improves query processing capabilities.github.com · read 9 Oct 2026
- SQL engine
- Its distributed query engine supports MySQL syntax and value types, with rule and cost based optimization and an independent physical execution engine.github.com · read 9 Oct 2026
- Support
- The repository links English and Chinese documentation hosted on Yuque.github.com · read 9 Oct 2026
