ProxySQL培训

课程编码

proxysql

课程时长

14 小时 通常来说是2天,包括中间休息。

要求

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

Audience

  • Database engineers
  • System administrators

课程概览

Proxy SQLMy SQLPercona Server和MariaDB的代理。

这种由讲师指导的现场培训(现场或远程)面向希望使用代理方法确保基于My SQL的数据库具有高可用性的工程师。

在培训结束时,参与者将能够:

  • 安装和配置Proxy SQL
  • 在多个后端服务器上启用数千个并发数据库连接。
  • 部署跨多个数据库实例的多个代理。
  • 优化My SQL集群的性能,而无需更改查询应用程序。

课程格式

  • 互动讲座和讨论。
  • 大量的练习和练习。
  • 在实时实验室环境中亲自实施。

课程自定义选项

  • 要申请本课程的定制培训,请联系我们安排。
  • 要了解有关Proxy SQL更多信息,请访问:https://proxysql.com/

Machine Translated

课程大纲

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

客户评论

★★★★★
★★★★★

课程分类

相关课程

促销课程

订阅促销课程

为尊重您的隐私,我公司不会把您的邮箱地址提供给任何人。您可以享有优先权和随时取消订阅的权利。

我们的客户

is growing fast!

We are looking to expand our presence in China!

As a Business Development Manager you will:

  • expand business in China
  • 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