ProxySQL Course | HandsOn ProxySQL Tutorial Master Class

Udemy Certificate USD 19.99
Enroll now →
ProxySQL Course | HandsOn ProxySQL Tutorial Master Class

About this course

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.RequirementsA general understanding of proxy concepts.Experience with MySQL.Experience with the Linux command line.What you will learn in this trainingIntroduction to ProxySQL ArchitectureHow to install and configure ProxySQLChanging ProxySQL configuration on RuntimeQuery routing generally called read-write splitsChanging the configuration of ProxySQLQuery Cache with ProxySQLEnabling Query Logging in ProxySQLquery fire-walling with ProxySQLAdvanced performance monitoring and tuningDeployment and scaling best practicesHigh Availability and advanced ProxySQL topology supportProxySQL Cluster and configuration managementHow Enabel virtual Ip with KeeplivedFailover in synchronous & asynchronous replication environments without losing transactionsProxySQL use cases and real-world examplesSecuring ProxySQL and implementing SSLApplication development considerations when using ProxySQL

What you'll learn

  • Understand ProxySQL architecture
  • Install and configure ProxySQL
  • Manage ProxySQL configuration at runtime
  • Implement read-write splits for query routing
  • Utilize query caching and logging
  • Monitor and tune performance
  • Deploy high availability configurations
  • Manage ProxySQL clusters
  • Implement failover strategies
  • Secure ProxySQL with SSL

Skills you'll gain

Related courses

Course details are provided by the platform and may change — always confirm on the provider's site. Links may be affiliate links.