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 (9)
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
The training can use relevant examples in your work.
Aisha - Iziko Museums
Course - MySQL Database Administration
I like this training because it was interactive
Amalia - Banca Transilvania
Course - SQL Fundamentals
The trainer explained everything with a lot o detail, and it was always engaging us.
Florian Lipianu - SERVICIUL DE TELECOMUNICATII SPECIALE
Course - MariaDB Database Administration
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
Course - SQL in MySQL
Was well organized Instructor ability to explain concepts, in a manner that is easy to understand
Oana Bunea - SERVICIUL DE TELECOMUNICATII SPECIALE
Course - MariaDB Galera Cluster Administration
I really like the Exercises and balance between theory and practice
Damian Kajewski - Glosel Sp. z o. o. Sp. k.
Course - Advanced MariaDB for High Availability and Performance
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 quality of training and wealth of experience !