Course Outline
Introduction
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
Troubleshooting
Summary and Conclusion
Requirements
- A general understanding of proxy concepts.
- Experience with MySQL.
- Experience with the Linux command line.
Audience
- Database engineers
- System administrators
Testimonials (5)
The quality of training and wealth of experience !
Edvin - Verizon Connect
Course - MySQL Developer
Was carefully tailored to our needs, very responsive to live questions and situations, gave us lots of practice repeating what we were learning.
Colin - Drax
Course - MySQL Administration
Trainer was accommodative. And actually quite encouraging for me to take up the course.
Grace Goh - DBS Bank Ltd
Course - Python in Data Science
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
Course - SQL in MySQL
exercise: setting up HAProxy for load balancing Galera cluster lecture: certification based replication