MariaDB Cluster Admin Deep Dive

By David Thomas

Dive into the architecture and installation of MariaDB Galera Cluster, the Galera Load Balancer, and more.

6 hours
  • 30 Lessons
  • 8 Hands-On Labs
  • Chapter 1 4 Lessons Introduction 6:03

    An Important Note About A Cloud Guru and Linux Academy Courses

    1:19

    About the Course

    1:01

    Prerequisites for This Course

    1:00

    What Is High Availability?

    2:43
  • Chapter 2 3 Lessons MariaDB Galera Cluster Architecture 3:41

    The MariaDB Server

    1:07

    The wsrep Patch

    1:18

    The Galera wsrep Provider Library

    1:16
  • Chapter 3 4 Lessons Installing MariaDB Galera Cluster 39:41

    Installing the Packages

    4:10

    Bootstrapping the New Cluster

    2:31

    Adding Nodes to the Cluster

    3:00

    Install MariaDB Galera Cluster on Linux

    30:00 Hands-On Lab
  • Chapter 4 4 Lessons Galera Load Balancer 1:06:48

    Balancing Policies

    1:41

    Runtime Management

    2:42

    The Watchdog

    2:25

    Install Galera Load Balancer on This Running MariaDB Galera Cluster

    1:00:00 Hands-On Lab
  • Chapter 5 8 Lessons MariaDB Galera Cluster Use Cases 4:52:12

    Implementing a Primary-Replica Cluster

    0:56

    Implementing a Write-Scalable Cluster

    1:03

    Implementing a Disaster Recovery Cluster

    3:07

    Implementing a Cluster to Reduce Client Latency

    2:06

    Implement a Primary-Replica Cluster Using MariaDB Galera Cluster and Galera Load Balancer

    4:00:00 Hands-On Lab

    Implement a Write Scalable Cluster Using MariaDB Galera Cluster and Galera Load Balancer

    15:00 Hands-On Lab

    Implement a Disaster Recovery Cluster Using MariaDB Galera Cluster and Galera Load Balancer

    15:00 Hands-On Lab

    Implement a Cluster to Reduce Client Read Latency Using MariaDB Galera Cluster and Galera Load Balancer

    15:00 Hands-On Lab
  • Chapter 6 6 Lessons Troubleshooting 44:10

    Recovering from a Crash

    3:32

    Shutdown/Restart the Cluster

    4:00

    Monitoring

    4:47

    Maximum Concurrent Connections

    1:51

    Recover This Crashed MariaDB Galera Cluster

    15:00 Hands-On Lab

    Restart This Running MariaDB Galera Cluster

    15:00 Hands-On Lab
  • Chapter 7 1 Lesson Conclusion 0:49

    Course Summary

    0:49

What you will need

  • This course assumes some basic Linux skills. Students may find these course useful in coming up to speed or refreshing their Linux skills. - LPI Linux Essentials Certification https://linuxacademy.com/cp/modules/view/id/346 - Red Hat Certified System Administrator (EX200) - RHCSA Exam Prep https://linuxacademy.com/cp/modules/view/id/324 Students who are unfamiliar with MySQL or SQL in general should review a basic course. - Database Administration and SQL Language Basics https://linuxacademy.com/cp/modules/view/id/374

What are Hands-on Labs

What's the difference between theoretical knowledge and real skills? Practical real-world experience. That's where Hands-on Labs come in! Hands-on Labs are guided, interactive experiences that help you learn and practice real-world scenarios in real cloud environments. Hands-on Labs are seamlessly integrated in courses, so you can learn by doing.

Get Started
Who’s going to be learning?
Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!