Proxysql Course | Handson Proxysql Tutorial Master Class

What you'll learn
Install and configure ProxySQL.
Enable thousands of concurrent database connections over multiple backend servers.
Deploy multiple proxies spanning numerous database instances.
Optimize the performance of a MySQL cluster, without altering the querying applications
Requirements
You must have Knowledge of MySQL DBA task
Description
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...

Read more

Continue reading...