ProxySQL

ProxySQL is a high-performance, open-source MySQL proxy and load balancer that sits between client applications and backend MySQL, MariaDB, or Percona Server databases. It enables advanced features like query routing, connection multiplexing, read/write splitting, query caching, rewriting, and…

Key facts

First appeared: 2013
Category: technology
Problem solved: ProxySQL solves challenges in managing high-traffic MySQL environments by providing load balancing, query routing to specific host groups (e.g., writes to masters, reads to slaves), connection multiplexing to reduce backend thread overhead, on-the-fly query rewriting and caching outside the database, and automatic failover detection—capabilities that predecessors like basic MySQL replication lacked in terms of intelligent proxying and zero-downtime reconfiguration.
Platforms: Linux distributions

Related technologies

Percona Server
MariaDB
MySQL Group Replication
MySQL

Notable users

Exotel
PingCAP (TiDB)
Percona