Loading...

A High Performance MySQL Proxy

Features at a glance

Application Layer Proxy

ProxySQL is more than a load balancer, it understands the MySQL protocol providing end-to-end MySQL connection handling, real-time statistics and database traffic inspection.

Zero-downtime Changes

ProxySQL’s configuration is inspired by advanced router design principles. Dynamically configure everything in-memory, persist to disk and push to runtime, all with zero-downtime.

Database Firewall

ProxySQL acts as a gatekeeper between the application and the database, allowing DBAs to safeguard the database from malicious activity or problematic application deployments.

Advanced Query Rules

Solve your query routing problems with ProxySQL’s rich query rule definitions to efficiently distribute and cache your data to maximize your database service efficiency.

Data Sharding & Transformation

Scale out by sharding your database across multiple servers based on schema, table or user. Implement advanced query rules to rewrite your data on-the-fly for transformations or data masking.

Failover Detection

ProxySQL automatically detects replication topology changes by continuously monitoring the database backends and re-routing traffic to healthy nodes as the topology changes.

Check out the Official ProxySQL Documentation here

ProxySQL is trusted by countless organizations across the globe to meet their MySQL scalability and High Availability goals

ProxySQL scales millions of connections across hundreds of thousands of backend servers

ProxySQL is MySQL / MariaDB protocol compliant and natively supports popular backends:

  • Amazon (AWS) Aurora & RDS
  • ClickHouse
  • Galera Cluster
  • MySQL / MariaDB Server
  • Oracle MySQL InnoDB Cluster & Group Replication
  • Oracle NDB Cluster
  • Percona Server & XtraDB Cluster
  • SQLite (embedded)

  • With zero vendor lock in, ProxySQL ensures that your applications retain full MySQL compliance ensuring simple and clean integration into your environment.

  • Deploy ProxySQL directly on your application servers, as an intermediate proxy server or combine both approaches by cascading ProxySQL, the freedom is yours.

  • Route writes to primary servers, distribute reads across replica servers and use advanced query rules to define specific routing criteria.

  • ProxySQL’s Connection Multiplexing feature intelligently reduces connection usage by sending multiple frontend connection requests to a single backend connection.

Guarantee uptime in critical situations by complementing your deployment with a ProxySQL Subscription Service

Learn more about ProxySQL Subscription Services