It is a database proxy that aims to solve the distributed transaction problems during business development, which provides solutions for read && write splitting, database and table sharding. Through the mesh-based deployment method, DBPack shields complex basic logic, so that business development does not need to rely on a specific SDK, which simplifies the development process and improves development efficiency.
Go Application Features
- support MYSQL protocol.
- event-driven distributed transaction solution inspired by Kubernetes.
- support read && write splitting, customized SQL route through Hint
- support audit log, support SQL tracing.
- sharding: support query on a sharded table, support order by， support limit.
- sharding: support insert, delete, update on the sharded table
- can be deployed as a sidecar so that any programming language can use it to handle the distributed transaction
- more features on the road
Golang and MySQL Prerequisites
- Go >= 1.17
- MYSQL >= 5.7
Architecture
- Listener：parse SQL protocol
- Executor：forward SQL request to actual DB server
- Filter：quota statistics, SQL interception, sensitive information encryption and decryption, etc
- ConnectionFilter：handle SQL interception on the DB connection
