Course Outline

Introduction

Setting up ProxySQL

Overview of ProxySQL Features and Architecture

How Query Caching Works

Configuring ProxySQL's Rule Engine

Caching MySQL Queries

Routing Queries to Different MySQL Clusters

Case Study: ProxySQL as a “Firewall" for Harmful Queries

Integrating ProxySQL with Third-Party Tools to Enable Failover

Monitoring MySQL Backends

Generating Workload Statistics

Demoting Backend Servers When Errors Are Encountered

Handling Sticky Transactions

Handling Real-time Transactions

Deploying Cascading Proxies

Troubleshooting

Summary and Conclusion

Requirements

  • A general understanding of proxy concepts.
  • Experience with MySQL.
  • Experience with the Linux command line.

Audience

  • Database engineers
  • System administrators
  14 Hours
 

Testimonials

Related Courses

Data Management

  35 hours

MarkLogic Server

  14 hours

SAP ASE for Database Administrators

  28 hours

Pivotal Greenplum for Developers

  21 hours

MySQL Database Administration

  14 hours

MySQL Administration

  28 hours

MySQL / Galera

  21 hours

SQL Fundamentals

  14 hours

SQL Advanced in MySQL

  7 hours

SQL in MySQL

  14 hours

MariaDB Database Administration

  14 hours

MariaDB Galera Cluster Administration

  21 hours

Advanced MariaDB for High Availability and Performance

  28 hours

Percona Server dla MySQL

  14 hours

Python in Data Science

  35 hours