Course Outline


Setting up ProxySQL

Overview of ProxySQL Features and Architecture

How Query Caching Works

Configuring ProxySQL's Rule Engine

Caching MySQL Queries

Routing Queries to Different MySQL Clusters

Case Study: ProxySQL as a “Firewall" for Harmful Queries

Integrating ProxySQL with Third-Party Tools to Enable Failover

Monitoring MySQL Backends

Generating Workload Statistics

Demoting Backend Servers When Errors Are Encountered

Handling Sticky Transactions

Handling Real-time Transactions

Deploying Cascading Proxies


Summary and Conclusion


  • A general understanding of proxy concepts.
  • Experience with MySQL.
  • Experience with the Linux command line.


  • Database engineers
  • System administrators
 14 Hours

Testimonials (5)

Related Categories