ProxySQL Course | HandsOn ProxySQL Tutorial Master Class

ProxySQL is a high performance, high availability, protocol aware proxy for MySQL and forks (like Percona Server and MariaDB). All the while getting the unlimited freedom that comes with a GPL license.

Its development is driven by the lack of open source proxies that provide high performance.ProxySQL’s Training Courses are designed for DBAs, application developers as well as IT generalists. Our training is prepared and delivered by database experts who actively use ProxySQL in Customer environments.

The course focus is on real-world implementation scenarios and hands-on labs to ensure participants acquire all the needed skills to deploy efficient, scalable, and highly available solutions with ProxySQL.

Requirements

• A general understanding of proxy concepts.

• Experience with MySQL.

• Experience with the Linux command line.

What you will learn in this training

• Introduction to ProxySQL Architecture

• How to install and configure ProxySQL

• Changing ProxySQL configuration on Runtime

• Query routing generally called read-write splits

• Changing the configuration of ProxySQL

• Query Cache with ProxySQL

• Enabling Query Logging in ProxySQL

• query fire-walling with ProxySQL

• Advanced performance monitoring and tuning

• Deployment and scaling best practices

• High Availability and advanced ProxySQL topology support

  • ProxySQL Cluster and configuration management

  • How Enabel virtual Ip with Keeplived

• Failover in synchronous & asynchronous replication environments without losing transactions

• ProxySQL use cases and real-world examples

• Securing ProxySQL and implementing SSL

• Application development considerations when using ProxySQL

• Diagnosing issues and troubleshooting ProxySQL

• ProxySQL with Innodb Cluster / Group Replication

• ProxySQL with AWS aroura Cluster

  • Effect of Removing and adding node from Aurora cluster on ProxySQL

Some Of the Lecture are still pending and which are under review and will be added to course in future.