Advanced MariaDB for High Availability and Performance培训

课程编码

mariadbadv

课程时长

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

要求

  • Experience with MySQL or MariaDB basic operations
  • Experience with SQL language
  • Experience with Linux command line

Audience

  • Developers
  • Database administrators
  • System administrators

课程概览

MariaDBMy SQL一个分支,也是最受欢迎的数据库服务器之一。

在这个由讲师指导的实时培训中,参与者将学习如何安装,配置和管理MariaDB以实现高可用性和高性能。其他主题包括备份和恢复,安全性和群集。

    课程形式

    • 部分讲座,部分讨论,练习和繁重的实践练习

    Machine Translated

    课程大纲

    Introduction

    Installing and configuring MariaDB

    Overview of MariaDB architecture

    Backing up and restoring MariaDB

    Point-in-Time-Recovery (PiTR)

    Securing MariaDB

    Configuring MariaDB for high availability

    Master-slave replication

    Master-master replication

    Setting up virtual IPs

    Read/write distribution

    Active-active clustering with Galera Cluster

    Load balancing

    Performance tuning in MariaDB

    Hardware and performance

    Schema tuning

    Indexing

    SQL query Tuning

    Profiling

    Closing remarks

    客户评论

    ★★★★★
    ★★★★★

    课程分类

    相关课程

    促销课程

    订阅促销课程

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

    我们的客户

    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