ProxySQL Course | HandsOn ProxySQL Tutorial Master Class
Learn ProxySQL operations! This training helps you master ProxySQL skills for improved database performance and management.
Course Content
ProxySQL Course | HandsOn ProxySQL Tutorial Master Class is an all-levels Udemy course taught by Mughees Ahmed. It runs 3h 1m, is taught in English, and includes a certificate of completion. Learners rate it 3.7 out of 5 from 45 reviews, with 365 students enrolled. It is a paid course, first published November 2022.
Unlock the power of ProxySQL with our comprehensive training courses! This high-performance, high-availability proxy is designed for MySQL and its forks like Percona Server and MariaDB, all under a permissive GPL license. Developed to address the need for superior open-source proxy solutions, ProxySQL empowers you to build efficient, scalable, and highly available database systems.
Our training is tailored for DBAs, application developers, and IT professionals seeking to master ProxySQL. Learn from database experts with real-world experience implementing ProxySQL in demanding environments. We focus on practical application, using hands-on labs and real-world scenarios to ensure you gain the skills to deploy and manage ProxySQL effectively.
Prerequisites:
- A foundational understanding of proxy concepts.
- Experience working with MySQL.
- Familiarity with the Linux command line.
What You Will Learn:
- ProxySQL Architecture: Gain a deep understanding of how ProxySQL works.
- Installation & Configuration: Learn how to install and configure ProxySQL for your environment.
- Runtime Configuration: Master changing ProxySQL configurations without service interruption.
- Query Routing (Read-Write Splits): Implement effective read-write splitting for optimized performance.
- ProxySQL Query Cache: Leverage the ProxySQL Query Cache to improve query performance.
- Query Logging: Enable and configure query logging for auditing and analysis.
- Query Fire-walling: Protect your database with robust query fire-walling capabilities.
- Performance Monitoring & Tuning: Implement advanced performance monitoring and tuning techniques.
- Deployment & Scaling: Discover best practices for deploying and scaling ProxySQL.
- High Availability: Implement high availability solutions with ProxySQL.
- ProxySQL Cluster & Configuration Management: Configure and manage ProxySQL clusters.
- Virtual IP with Keepalived: Learn to enable virtual IPs using Keepalived for failover.
- Failover in Replication Environments: Implement failover strategies in synchronous and asynchronous replication environments without data loss.
- ProxySQL Use Cases: Explore real-world ProxySQL use cases and examples.
- Security: Secure your ProxySQL deployment with SSL and other security measures.
- Application Development Considerations: Understand how to optimize application development for ProxySQL.
- Troubleshooting: Diagnose and troubleshoot common ProxySQL issues.
- ProxySQL with Aurora: Learn to integrate ProxySQL with AWS Aurora clusters.
- ProxySQL with Innodb Cluster / Group Replication: Explore ProxySQL integration with Innodb Cluster and Group Replication.
- Impact of Node Changes on Aurora: Understand the effects of adding and removing nodes from an Aurora cluster on ProxySQL performance.
Note: Some lectures are currently under review and will be added to the course in the future.
Hire the developers behind TutorialSearch.io
We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.