Mycat2 vs MySQL
Mycat2
github.com
MySQL
mysql.comSide by side
| Figure | Mycat2 | MySQL |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | Yes |
| Open source | — | — |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | Yes | Yes |
| API | — | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 18 |
| Spec score · Database Proxy Software | 7.6 (#13) | 9.1 (#1) |
| Support | The repository links English and Chinese documentation hosted on Yuque. | MySQL Enterprise technical support provides 24x7 direct access to MySQL support engineers. |
Plans
MySQL
- Community EditionPrice not published
- Community EditionPriced on request
- Standard EditionPriced on request
- Standard EditionPrice not published
- Enterprise EditionPriced on request
- Enterprise EditionPrice not published
- Cluster Carrier Grade EditionPriced on request
- Cluster Carrier Grade EditionPrice not published
- MySQL Cluster Carrier Grade EditionPriced on request
- MySQL Enterprise EditionPriced on request
In their own words
Mycat2
Mycat2 is free, open-source distributed relational database middleware for Linux and self-hosted deployment. It supports distributed SQL queries and the MySQL communication protocol while connecting to multiple backend databases through the Java ecosystem. Its query engine handles MySQL syntax and value types, rule- and cost-based optimization, and an independent physical execution engine. Data fragmentation is described as improving query processing. Users can customize and load sharding, serial-number and load-balancing algorithms. A project DSL manipulates physical query plans, forwards SQL and caches result sets. The README currently supports Java 8 only. Release notes for v1.22-2022-6-25 list ClickHouse as a backend for SELECT and INSERT, without returning auto-increment values. They also describe SQL permission interception, RSA encryption for user.json, and recycling inactive backend connections after a default 180-second timeout. The repository identifies an Apache License from 2023.8.