Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

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.