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

About the course

In this course, we will discuss the Galera write-set replication technology as implemented on MariaDB and CentOS 7. We will discuss the architecture and installation of MariaDB Galera Cluster. We will also discuss using the Galera Load Balancer and several cluster use cases.

  • 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 9: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

    0:00 Hands-On Lab
  • Chapter 4 4 Lessons Galera Load Balancer 6:48

    Balancing Policies

    1:41

    Runtime Management

    2:42

    The Watchdog

    2:25

    Install Galera Load Balancer on This Running MariaDB Galera Cluster

    0:00 Hands-On Lab
  • Chapter 5 8 Lessons MariaDB Galera Cluster Use Cases 7: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

    0:00 Hands-On Lab

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

    0:00 Hands-On Lab

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

    0:00 Hands-On Lab

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

    0:00 Hands-On Lab
  • Chapter 6 6 Lessons Troubleshooting 14: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

    0:00 Hands-On Lab

    Restart This Running MariaDB Galera Cluster

    0: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.

Practice alongside courses in Cloud Playground

What is Cloud Playground? Cloud Playground lets you build skills in real-world AWS, Google Cloud, and Azure environments. Spin up risk-free Sandboxes, Servers and Terminals and follow along with courses, test a new idea or prepare for exams.

Get Started
Who’s going to be learning?

How many seats do you need?

  • $499 USD per seat per year
  • Billed Annually
  • Renews in 12 months

Ready to accelerate learning?

For over 25 licenses, a member of our sales team will walk you through a custom tailored solution for your business.


$2,495.00

Checkout
Sign In
Welcome Back!

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