Official ProxySQL Documentation
ProxySQL is a high-performance, high-availability, protocol-aware proxy for MySQL, PostgreSQL, and their forks and variants.
Quick Guides
Introductory guides for users new to ProxySQL, covering basic configuration concepts and primary use cases.
- Download and Install ProxySQL
- Step by Step Installation Guide
- First steps after installing
- How to configure ProxySQL for MySQL for the first time
- How to configure ProxySQL for PostgreSQL for the first time
- Upgrading ProxySQL
- How to set up ProxySQL Read/Write Split
- How to set up ProxySQL Sharding
Reference Manual
The Basics
Core foundational documentation:
- Multi Layer Configuration System
- Configuration file
- Startup options
- Backend Server Configuration
- MySQL Backend Server Monitoring
- PostgreSQL Backend Server Monitoring
- Global Variables
- Error Log
- Query Rewrite
Security
Configuration topics for ProxySQL security functions:
- User configuration
- Password management
- Authentication methods
- SSL configuration
- SPIFFE configuration
- Audit Logging
- Firewall Whitelisting
- SQL Injection Engine
Features
Advanced functionality documentation:
- Connection Multiplexing
- ProxySQL Cluster
- Query Cache
- Query Logging
- Advanced Event and Query Logging
- Query Annotations
- Prepared Statement Caching
- Mirroring
- Scheduler
- HTTP Web UI Statistic Graphs
- ProxySQL REST API
- ProxySQL Threads
- Thread Watchdog
- Client Error Limit
- MySQL BinLog Reader
- DNS Cache
- Prometheus Exporter
- ProxySQL Bootstrap Mode
- ProxySQL Internal Session
- Coredumper Support
- PostgreSQL Extended Query Protocol
- PostgreSQL Prepared Statement Cache
- Applying Query Rules in Extended Query Protocol
- Proxy Protocol
ProxySQL Admin
Configuration management via ProxySQL Admin DB:
- ProxySQL Configuration CLI
- Main (runtime) tables
- Disk (persisted)
- Stats (statistics)
- Stats (history)
Miscellaneous
- Information about MySQL 8.0
- ProxySQL Design Goals
- Packaging ProxySQL
- Version Checking
- ProxySQL Admin Backups
- Memory Leak Detection
- Error Codes
- Frequently Asked Questions
Commercial Support
| Service | Description |
|---|---|
| Enterprise Support | SLA-backed support with defined response times |
| DBRE Services | Dedicated database reliability engineering |
| Consulting | Architecture reviews and migration planning |
| Training | Structured programs for engineering teams |
| Feature Development | Custom feature development |