kingshard
github.com
- Free plan
- Linux
- Self-hosted
6.9 Club score Visit github.com
What the maker publishes
- Access controls
- The README lists client IP ACL controls and an SQL blacklist. source
- Access controls
- It lists client IP ACL control and an SQL blacklist among its features. source
- Availability
- It lists high availability for MySQL backends and allows backend databases to be set online or offline dynamically. source
- Connections
- It supports setting a maximum number of connections to MySQL databases and transactions on a single node. source
- Cross-node transaction limit
- The guide says transactions are supported only within one database and return errors if they span multiple databases. source
- Cross-node update limit
- The guide says an update routed across multiple databases returns an error. source
- Deployment
- The documented installation uses Go, Git clone, make, a YAML configuration file, and a locally run kingshard binary. source
- Installation
- The documented installation uses Go, a source clone, make, a configuration file, and running the built binary. source
- License
- The project states that kingshard is under the Apache 2.0 license. source
- License
- The repository says kingshard is licensed under Apache 2.0. source
- Manual setup limit
- The guide says sharded subtables must be created manually in the appropriate database. source
- Operations
- It supports MySQL backend high availability, connection limits, dynamic backend online/offline changes, and runtime configuration changes. source
- Performance claim
- The README says kingshard performance is about 80% compared with connecting directly to MySQL. source
- Performance claim
- The README says performance is about 80% of connecting directly to MySQL. source
- Prepared statements
- It supports prepared statement operations including COM_STMT_PREPARE and COM_STMT_EXECUTE. source
- Product
- kingshard is a Go-powered, high-performance proxy for MySQL. source
- Purpose
- kingshard is a Go-powered MySQL proxy that routes read and write SQL and aims to simplify MySQL sharding. source
- Query capabilities
- It lists support for prepared statements, single-node transactions, last_insert_id(), and common aggregate functions including max, min, count, and sum. source
- Query features
- For sharded queries, it lists max, min, count, and sum functions, plus join, limit, order by, and group by. source
- Read scaling
- It supports multiple slave databases and load balancing between slaves. source
- Read/write routing
- It splits read and write SQL statements and can balance reads across multiple slave databases. source
- Release
- The GitHub releases page identifies v1.6 as the latest release and describes multi-user support and configuration hot reload. source
- Sharding
- It supports hash and range sharding across multiple nodes; its README also lists date sharding. source
- Sharding
- It supports hash, range, and date sharding across multiple nodes, as well as sending SQL to a specified node. source
Checked against the maker's pages on 8 Oct 2026.