- Home
- Database Proxy Software
- kingshard
On the recordRead 8 Oct 202622 facts
kingshard
On the record
- Access controls
- It lists client IP ACL control and an SQL blacklist among its features.github.com · read 8 Oct 2026
- Availability
- It lists high availability for MySQL backends and allows backend databases to be set online or offline dynamically.github.com · read 8 Oct 2026
- Connections
- It supports setting a maximum number of connections to MySQL databases and transactions on a single node.github.com · read 8 Oct 2026
- Cross-node transaction limit
- The guide says transactions are supported only within one database and return errors if they span multiple databases.github.com · read 4 Oct 2026
- Cross-node update limit
- The guide says an update routed across multiple databases returns an error.github.com · read 4 Oct 2026
- Deployment
- The documented installation uses Go, Git clone, make, a YAML configuration file, and a locally run kingshard binary.github.com · read 4 Oct 2026
- Installation
- The documented installation uses Go, a source clone, make, a configuration file, and running the built binary.github.com · read 8 Oct 2026
- License
- The repository says kingshard is licensed under Apache 2.0.github.com · read 8 Oct 2026
- Manual setup limit
- The guide says sharded subtables must be created manually in the appropriate database.github.com · read 4 Oct 2026
- Operations
- It supports MySQL backend high availability, connection limits, dynamic backend online/offline changes, and runtime configuration changes.github.com · read 4 Oct 2026
- Performance claim
- The README says performance is about 80% of connecting directly to MySQL.github.com · read 8 Oct 2026
- Prepared statements
- It supports prepared statement operations including COM_STMT_PREPARE and COM_STMT_EXECUTE.github.com · read 8 Oct 2026
- Product
- kingshard is a Go-powered, high-performance proxy for MySQL.github.com · read 4 Oct 2026
- Purpose
- kingshard is a Go-powered MySQL proxy that routes read and write SQL and aims to simplify MySQL sharding.github.com · read 8 Oct 2026
- Query capabilities
- It lists support for prepared statements, single-node transactions, last_insert_id(), and common aggregate functions including max, min, count, and sum.github.com · read 4 Oct 2026
- Query features
- For sharded queries, it lists max, min, count, and sum functions, plus join, limit, order by, and group by.github.com · read 8 Oct 2026
- Read scaling
- It supports multiple slave databases and load balancing between slaves.github.com · read 8 Oct 2026
- Read/write routing
- It splits read and write SQL statements and can balance reads across multiple slave databases.github.com · read 4 Oct 2026
