Side by side
Mycat2 vs ShardingSphere-Proxy
Both stand on database proxy software. Which one you can start free with, which one lets you read the code, and what each costs once you pay.
Choose Mycat2 if you need free, open-source middleware for distributed SQL queries in a self-hosted Linux deployment. Its MySQL protocol support, query engine, and configurable algorithms are central capabilities. Consider its Java 8 runtime requirement and the stated ClickHouse auto-increment limitation when assessing fit.
Visit Mycat2
ShardingSphere-Proxy provides database sharding, routing, transactions, and federation in a free self-hosted package. Check its runtime and MySQL connector requirements, as well as the noted limits for system databases and tables.
Visit ShardingSphere-ProxyThe facts
| Mycat2 | ShardingSphere-Proxy | |
|---|---|---|
| Free plan | Yes | Yes |
| Open source | Not published | Not published |
| Runs on | Linux, Self-hosted | Linux, Mac, Self-hosted, Windows |
| Lowest paid plan | Free or on request | Free or on request |
| Plans published | 1 | 1 |
| Maker | Not published | Not published |
| Website | github.com | shardingsphere.apache.org |
| On database proxy software | #11 of 31 | #15 of 31 |
Mycat2: what it does well
- Supports distributed SQL queries and the MySQL communication protocol.
- Connects to multiple backends through the Java ecosystem.
- Includes rule-based and cost-based query optimization.
- Supports connection pooling, query routing, and load balancing.
- Sharding and load balancing algorithms can be customized and loaded.
What to know first
- The README says the runtime supports Java 8 only.
- Deployment is self-hosted on Linux.
- ClickHouse support described in the v1.22 notes lacks returned auto-increment values.
ShardingSphere-Proxy: what it does well
- Free, self-hosted deployment.
- Offers binary, Docker, and Helm deployment options.
- Read balancing uses SQL semantics and database topology.
- Includes distributed transactions and data migration.
- Lists MySQL, PostgreSQL, openGauss, and Firebird protocols.
What to know first
- Binary distribution requires Java JRE 8 or higher.
- MySQL backend requires an added connector JAR.
- System database and table support is limited.
- Some graphical database clients may show errors.
Alternatives to Mycat2 Alternatives to ShardingSphere-Proxy The whole list