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)
Learned new things and advanced myself with knowledge
Todor - MYPOS TECHNOLOGIES
Course - SQL Fundamentals
The way the trainer made the course interactive
Stefan - Verizon Connect
Course - MySQL Developer
Interactive illustration of concepts and features
Josheel - Verizon Connect
Course - MySQL Developer
The training can use relevant examples in your work.
Aisha - Iziko Museums
Course - MySQL Database Administration
practical examples.
Kesh Mulloo - Vodacom
Course - MySQL Database Administration
I like this training because it was interactive
Amalia - Banca Transilvania
Course - SQL Fundamentals
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
Exercises, balance between theory and practice
Damian Kajewski - Glosel Sp. z o. o. Sp. k.
Course - Advanced MariaDB for High Availability and Performance
trainers attitude