Incubating Project: DB Proxy/Mesh for TiDB

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?

Start by reviewing the proposal body and its listed goals for the TiDB proxy/mesh project. No implementation files, tests, entry points, or RFC are provided, so the scope and completion criteria would need to be established before work can begin.