Documentation

The Basics

Before delving into the ProxySQL configuration specifics it is crucial to understand the Multi Layer Configuration System and how ProxySQL’s supported backend servers are configured and monitored in ProxySQL.

• Multi Layer Configuration System

• • Backend Server Configuration
    • AWS Aurora Configuration
    • ClickHouse Server Configuration
      
    • Galera / Percona XtraDB Cluster Configuration
    • Oracle Group Replication Configuration
  • Backend Server Monitoring

ProxySQL’s general behavior is controlled by the Global Variables. ProxySQL Admin Variables are controlled separately to MySQL traffic and monitoring variables.

• • Global Variables
    • Admin Variables
    • General MySQL Variables
    • MySQL Monitor Variables

Security

All ProxySQL security functions are configurable via the ProxySQL Admin interface and are documented in the pages found here.

• User configuration
  • Password management
• SSL configuration
• Audit Logging
• Firewall Whitelisting
  • SQL Injection Engine

Features

Here you will find configuration details for specific ProxySQL features.

• Query Cache
• Query Logging
• Mirroring
• Scheduler
• ProxySQL Cluster
• HTTP Web UI Statistic Graphs
• ProxySQL REST API

ProxySQL Internals

Here you will find interesting information related to the inner workings of ProxySQL. Topics cover various design aspects that are of interest to more advanced end-users and project contributors.

• Connection Multiplexing
• ProxySQL Threads
• Thread Watchdog
• Error Codes