# flike/kingshard

A high-performance MySQL proxy

Repository: https://github.com/flike/kingshard
Canonical: https://ross.abutalabs.com/products/kingshard
Language: Go
License Family: other
Topics: mysql, mysql-proxy, kingshard
Last push: 2026-06-05T21:08:57+00:00

## Health v2 (maintenance only)
Score: 62/100 (v2, computed 2026-09-03T02:39:23.370411+00:00)
- activity 86, release rhythm 8, longevity 100
- inputs: {"age_days": 4079, "days_push": 89, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 6401, forks 1217 (observed 2026-08-28T04:09:43.112293+00:00)

## What it is
kingshard is a high-performance MySQL proxy written in Go that sits between applications and MySQL backends. Its core feature is transparent sharding (hash, range, and date-based) along with read/write splitting, connection pooling, and backend HA.

## Use cases
- shard a large MySQL table across multiple nodes
- split read and write queries between master and replicas
- load balance queries across multiple MySQL slaves
- control client access to MySQL with IP ACLs
- take backend MySQL servers online or offline without downtime
- blacklist dangerous SQL statements at the proxy layer

## When to choose
- you need transparent MySQL sharding without changing application code
- you want read/write splitting with load balancing across replicas
- you need a lightweight Go-based proxy with near-native MySQL performance

## When to avoid
- you need distributed transactions spanning multiple shards
- you use advanced SQL beyond basic DML and common functions
- you want a proxy with an active large community or commercial support

## Facets
- artifact type: service
- maturity: maintenance
- function: database, proxy, routing, middleware, load-testing
- domain: databases, backend, microservices, developer-tools
- platform: go, cli, self-hosted
- tags: mysql-proxy, database-sharding, read-write-splitting, sql-proxy, horizontal-scaling, linux, macos

## Member repositories
- flike/kingshard (main) score 62

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:09:43.112293+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T17:45:00.866140+00:00, confidence not recorded.
  - readme: https://github.com/flike/kingshard (fetched 2026-08-28T04:09:43.112293+00:00, sha 3603d811de6f)
- Data as of 2026-08-30T08:39:29.467469+00:00.