Skip to content
SPECIFICTION
Get listed

kingshard

github.com

LinuxSelf-hosted
Visit github.com
Spec score 7.4 #20 of 31 in Database Proxy Software

Spec sheet

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

Where Specifiction places it

Alternatives to kingshardAll alternatives →