|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/proxysql-course-handson-proxysql-tutorial-master-class/
课程评论：没有评论
课程名称：ProxySQL 课程实践教程大师班 课程概述：ProxySQL 是一个高性能、高可用性的 MySQL 代理，兼容包括 Percona Server 和 MariaDB 等多种数据库。该项目的开发旨在填补现有开源代理在高性能方面的空白。ProxySQL 的培训课程面向数据库管理员、应用开发人员以及 IT 通用人员。培训由实际在客户环境中使用 ProxySQL 的数据库专家准备和讲授，课程内容聚焦于真实的实施场景和实践实验，确保参与者掌握部署高效、可扩展和高可用解决方案所需的所有技能。 课程要求：一般的代理概念理解，MySQL 使用经验，以及 Linux 命令行经验。 培训内容包括： - ProxySQL 架构介绍 - ProxySQL 的安装和配置 - 运行时更改 ProxySQL 配置 - 查询路由（即读写分离） - ProxySQL 的查询缓存 - 启用 ProxySQL 的查询日志 - ProxySQL 查询防火墙 - 高级性能监控与调优 - 部署与扩展最佳实践 - 高可用性与高级 ProxySQL 拓扑支持 - ProxySQL 集群与配置管理 - 使用 Keeplived 启用虚拟 IP - 在同步与异步复制环境中的故障转移 - ProxySQL 的实际案例和应用示例 - ProxySQL 的安全性和 SSL 实现 - 使用 ProxySQL 时的应用开发注意事项 - 诊断与故障排除 ProxySQL - ProxySQL 与 InnoDB 集群/组复制 - ProxySQL 与 AWS Aurora 集群 - 从 Aurora 集群中移除和添加节点对 ProxySQL 的影响 注意：部分讲座尚在审核中，未来会添加到课程中。
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 supportProxySQL Cluster and configuration managementHow Enabel virtual Ip with KeeplivedFailover in synchronous & asynchronous replication environments without losing transactionsProxySQL use cases and real-world examplesSecuring ProxySQL and implementing SSLApplication development considerations when using ProxySQLDiagnosing issues and troubleshooting ProxySQLProxySQL with Innodb Cluster / Group ReplicationProxySQL with AWS aroura ClusterEffect of Removing and adding node from Aurora cluster on ProxySQLSome Of the Lecture are still pending and which are under review and will be added to course in future.
