ProxySQL Training Logo

ProxySQL Training

Live Online & Classroom Enterprise Training

Learn how to deploy, configure, and optimize ProxySQL to improve database performance, scalability, and high availability in MySQL-based environments.

Looking for a private batch ?

REQUEST A CALLBACK

Need help finding the right training?

Your Message

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

What is ProxySQL Training about?

ProxySQL is a powerful, high-performance SQL proxy designed to enhance database scalability, query routing, and failover between multiple MySQL servers. This course covers installation, configuration, connection rules, query routing, load balancing, monitoring, and performance tuning within production environments. Participants will gain hands-on expertise integrating ProxySQL with MySQL, MariaDB, Percona XtraDB Cluster, and cloud-based database architectures.

What are the objectives of ProxySQL Training ?

  • Understand ProxySQL architecture and core functionalities.
  • Configure query routing rules and hostgroup management.
  • Implement load balancing and high availability for MySQL databases.
  • Monitor and troubleshoot ProxySQL performance issues.
  • Integrate ProxySQL with clustering and replication solutions.

Who is ProxySQL Training for?

  • Database Administrators
  • MySQL / MariaDB Engineers
  • DevOps and Site Reliability Engineers (SRE)
  • System Architects and Infrastructure Engineers
  • Cloud & Data Platform Engineers

What are the prerequisites for ProxySQL Training?

Prerequisite:

  • Basic understanding of MySQL or MariaDB
  • Familiarity with database replication and clustering
  • Knowledge of Linux system administration
  • Experience with SQL query operations
  • Basic networking concepts (TCP/IP, ports, load balancing)


Learning Path:

  • Introduction to ProxySQL & Architecture
  • Installation and Initial Administration
  • Query Routing and Hostgroup Configuration
  • Load Balancing & High Availability Strategies
  • Monitoring, Logging & Performance Optimization


Related Courses:

  • MySQL Database Administration
  • Percona XtraDB Cluster / Galera Cluster
  • MariaDB High Availability & Clustering
  • HAProxy / NGINX for Load Balancing

Available Training Modes

Live Online Training

3 Days

Course Outline Expand All

Expand All

  • What is ProxySQL?
  • Key features and benefits
  • ProxySQL vs. other MySQL proxies (HAProxy, MaxScale)
  • Installing ProxySQL on Linux and Docker
  • Understanding ProxySQL’s architecture
  • Configuring ProxySQL for MySQL and MariaDB
  • Understanding query routing rules
  • Connection multiplexing and pooling
  • Handling persistent and transient connections
  • How ProxySQL caches queries
  • Configuring query cache TTL and invalidation rules
  • Measuring query performance gains
  • Configuring read/write splitting for MySQL replication
  • Load balancing strategies for high-traffic databases
  • Implementing failover mechanisms
  • Setting up authentication and user management
  • Implementing query whitelisting and firewall rules
  • Protecting against SQL injection and DoS attacks
  • Using ProxySQL’s built-in statistics and logs
  • Monitoring MySQL backend health and query performance
  • Performance tuning best practices
  • Integrating ProxySQL with MySQL replication and clustering
  • Setting up ProxySQL in a multi-node architecture
  • Backup and disaster recovery strategies

Who is the instructor for this training?

The trainer for this ProxySQL Training has extensive experience in this domain, including years of experience training & mentoring professionals.

Reviews