Incubating Project: DB Proxy/Mesh for TiDB

[niubell]

trafficstars

Project Incubating Request

A Proxy/Mesh for TiDB that can replace Layer 4 load balancing such as SLB+Haproxy. It works in Proxy or Mesh(like Envoy) mode but can understand sql semantics, we call it weir.

Describe the project you want to incubate:

Summary

TiDB is adopted by PalFish(伴鱼) since 2016 and is the most important OLTP/OLAP database in our company. We use SLB+Haproxy as the Layer 4 load balancing before, but we want more features in L4 Proxy to keep tidb safe.

Motivation

This proposal will offer features as follows:

• Auto-Detect Rate limiting、Circuit breaker.
• Multi-tenancy.
• Service discovery with smart client.
• Connection pool.
• Database Mesh for TiDB.
• Web Application Firewall (WAF) for sql.
• More metrics, such as tenant-dashboard which have hot/slow sql fingerprint.
• Route across multi data centers.
• SQL audit、slow sql statistics、session statistics、shadow database for benchmark and so on.

Estimated Time

6 months

Initial Team Members

徐成选(cx3ptr) 曹东瑜(eastfisher)

Your RFC/Proposal?

[winkyao]

Great project, LGTM @siddontang

[siddontang]

approved

[winkyao]

Repo created: https://github.com/pingcap-incubator/weir