ProxySQL Training Course

Course Code

proxysql

Duration

14 hours (usually 2 days including breaks)

Requirements

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

Audience

  • Database engineers
  • System administrators

Overview

ProxySQL is a proxy for MySQL, Percona Server, and MariaDB.

This instructor-led, live training (online or onsite) is aimed at engineers who wish to use a proxy approach to ensure high availability for MySQL based databases.

By the end of this training, participants will be able to:

  • 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.

Format of the Course

  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.

Course Customization Options

  • To request a customized training for this course, please contact us to arrange.
  • To learn more about ProxySQL, please visit: https://proxysql.com/

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

Testimonials

★★★★★
★★★★★

Related Categories

Related Courses

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in Hong Kong!

As a Business Development Manager you will:

  • expand business in Hong Kong
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!

This site in other countries/regions