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
Substantive preparation, attention to detail
Sebastian Łubik
A professional and accessible way of transferring knowledge and assistance during training and exercises.
Michal Bialek
Training material was very informative. Learned a lot.
Yaw Asamoah
I really enjoyed the lessons and examples.
Kelly Taylor
He adapted to the experience of the group, gave us great value for a beginners course.
Rich Mickey
Enjoyed the pace, delivery and technical know how of the trainer.
Junaid Kalang
The trainer, he was knowledgeable, engaging, and easy to learn from. He encouraged a lot of hands-on learning.
Shawn McAndrew
It was addressed to the specific topics and questions
Jürgen Demant
very interactive
Martin Seidler
I learned a LOOOOOT.
Kamil Szmid
sql works even if I don't know why
Dominik Gardo
individual approach of the trainer to people participating in the training
Wojciech Gądzikiewicz
tempo of classes, flexibility as to the content of the training related to the expectations of users
Karol
Pace, explanation of issues from a completely different angle. Something that explains how everything works from the server side
P4 Sp. z o.o.
number of issues covered
P4 Sp. z o.o.
adaptation to the needs of the participants, very good exploration of the discussed tasks, comprehensive answers to the asked question
Marcin Gołdyn
Work on a physical database.
P4 Sp. z o.o.
adapting to the needs of the listeners, analyzing the problems they report
P4 Sp. z o.o.
practical exercises
Małgorzata Wieczorek
practical part
Marcin Witosławski
Exercises, the possibility of practical knowledge acquisition, group cooperation in solving problems.
Emil Lewandowski
I enjoyed the backup and restore and multiple instances.
Lakshmi Ponnada - Albany Medical Center
The training exceeded my expectations on what I was hoping to learn.
Ian Matthews - Cision
Small, highly focused group allowed us all to stay involved directly with the instructor the whole time which becomes less tenable as group size grows.
Leading Edge Marketing Inc
I generally liked the hands-on exercises.
Palawan Pawnshop - Palawan Express Pera Padala
I really enjoyed all exercise.
Palawan Pawnshop - Palawan Express Pera Padala
very logical and step by step but not too much
Anne Homer - States of Jersey
He was very friendly and he created a very good environment.
- European Commision, Joint Research Centre
I enjoyed the flexibility to explore different areas outside the set training materials.
- BMW Group
The trainer has extensive knowledge of IT.
Iwan Susanto - Universitas Terbuka
n/d
Artur Bryś - Centrum Innowacji ProLearning
I mostly enjoyed the knowledge about replication database.
Suparman - Universitas Terbuka
Patience, reordering, knowledge
- Santander Bank Polska S.A.
Lots of exercises
Michał Świerkowski - Santander Bank Polska S.A.
Practice
- Santander Bank Polska S.A.
Generally he was good, knowledgeable and understandable in the subject matter
- BMO
Trainer was great
- Clay Solutions
exercise: setting up HAProxy for load balancing Galera cluster lecture: certification based replication
Kateryna Tokar - Clay Solutions
Phil was incredibly knowledgeable, worked at our pace and took the time to talk us through multiple ways of doing different queries. He consistently took the time throughout the sessions to check both myself and my colleague were on board with what was being discussed, no question was too big/too small. This was my first time taking a training course remotely and I'm completely sold on it - Phil is a credit to you.
Chris Teasdale - Openreach
Pace of the training and detail of content was perfect for a virtual session
Chris Hopton - Openreach
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
The practical exercises.
- Clay Solutions
The exercises done during the training.
Melvin Joseph Manalo - Stolt Tankers BV
all topics are interesting
- Stolt Tankers BV
The trainee was friendly and talkative
The variety of exercises and presentation, so we had time to deepen every section before the next started. Also, very good the focus on the participants.
Philine Mitrea - Greentube IES GmbH
What I like most about the training are the exercises which really helps me to learn about basic SQL.
Maverick Ivan Oreste - BOSCH SERVICE SOLUTIONS INC.
The Hands-on part even the training is virtual
Jude De Jesus - Sagesoft Solutions Inc
Logs, enabling variable persistently
Ronaldo Ramos - Sagesoft Solutions Inc
The trainer. He is very knowledgeable in his field.
Elton Aquino - Sagesoft Solutions Inc
Trainer was accommodative. And actually quite encouraging for me to take up the course.
Grace Goh - DBS Bank Ltd
The trainee was friendly and talkative