Skip to content
UdemyMySQLPaid courseAll LevelsCertificate

Galera Cluster and MariaDB MySQL Replication (Udemy.com)

MySQL and MariaDB Replication and High Availability

Created by: Hadi Alnabriss

Last updated May 2020

icon
What you will learn

  • After taking this course students will be able to build a high available Database Cluster with multi master database system
  • Students will gain the required knowledge to load balance mysql queries to the database cluster nodes

How it compares

Against the other 43 rated Udemy courses in MySQL on CourseDuck:

  • Rating4.2 out of 5higher than 20% of them
  • Reviews661#22 of 44 by number of reviews
  • Length2.2 hoursshorter than 88% of them
  • Last updatedMay 2020earlier than 62% of them

icon
Course Description

In this course the students will learn many topics about database replication, this course includes learning theoretical concepts and practical tasks. In this course the students will learn about the following topics:

Database Replication

Synchronous and Asynchronous Replication

Statement Based Replication and Row Based Replication

Group Communications, Write Sets and Certification Based Replication

Building 3 nodes Galera Cluster (Practical)

Testing Potential Nodes Failures (Practical)

Joining New Nodes to The Cluster (Practical)

Weighted Quorum Concepts

Load Balancing

Checking The Cluster Status


Eventually, this will be a continuous course I am going to add any additional topics I think they are important, and any topics requested by students.

So, if you think that this course can be improved by adding any topics, then please let me know.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Hadi Alnabriss

Hadi Alnabriss is an RHCE certified and Cisco Academy trainer, with high experience in systems and networks administration.

Since 2007, Hadi Alnabriss started to work as Linux systems administrator, in 2011 he started to use virtualization systems for servers, he used a variety types of virtualization environments like VMware ESX vSphere, Microsoft HyperV and Proxmox VE. 

In the last 10 years Hadi gained good experience in Linux systems (Like Web servers,  DNS Servers, SMPP, Mysql and MariaDB ) and Proxmox VE clusters management.

icon
More MySQL courses

$13.99

$11.99

$54.99

$79.99

$199.99

$11.99

icon
Reviews

4.2

661 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Andrey Andreyev on 7/25/2023

Good course. Thanks to author. Minor drawback is the installation process. Installing packages manually on several nodes is not an optimal way to setup a cluster in real world. Taking into account that mariadb has official image on dockerhub, you may consider using some kind of orchestration like docker-compose, kubernetes, helm.

By Matti Väisänen on 10/18/2022

Some information in this course is outdated when comparing to MariaDB current and latest stable release version. Had to do some googling since there have been some file location changes and config file contents have been changed to different config files.

By Fabiano Martins on 3/18/2022

O conteúdo do curso é muito bom, mas as legendas são sofríveis, há muitos erros!! Por exemplo: quando o instrutor diz "MySQL" a legenda diz "MySchool". Na mesma linha: "daiquiri shop" ao invés de "the query show", "System City, Al Stark, MariaDB" ao invés de "systemctl start mariadb", "shorter bills and save" ao invés de "show tables inside", "Taiwan" ao invés de "t1", e por aí afora...

By ETel Connections on 5/3/2021

As someone who has just started learing about Clustering/Replication, I feel the teacher has given a good breakdown of the concepts, the certification process, isolation types and snapshot modes. The practical section where you build the Galera cluster tied the first 6 sections together nicely and was given at a good pace. I look forward to the remaining sections...

By Christophe Delcenserie on 5/3/2020

it's a good course. But not complete It less how to install and configure haproxy and implemente the component. When you have a problem with cluster, we can't show how to see where is the node is the most up to date (last_commited). And when started, you can loss data if you up the lasted How backup it and restore the node. See in log STT or IST. You can't explain queue and how see lag network. You can't explain gcache etc ... You can't explain how upgrade node You can't explain wsrep_sst_auth with xtrackup or mariadbackup This lesson it not complete. It's for beginer and dangerous for beginer (loss data)

By Bu Bù on 4/5/2020

It'd have been nice to see more on replication. Any patched production system is using mariabackup for replication not rsync. More on the differences between xtrabackup and mariabackup and the specific requirements for setting up a replication user would've been a nice addition.

By Richard Howes on 7/22/2019

A very good match. Clear and detailed and I was able to follow, understand, and set up a cluster. What would be great to add is how to set up new nodes when there are a large number of large databases to establish on a node.

By Tero Hannula on 12/31/2018

This was a good introduction to the Galera and was easily worth the money and time. This is one of those courses that keeps things simple and compact, making it possible to learn the stuff pretty quickly without making it a burden. The course most likely improves further over time, filling the minor gaps here and there, but they are really not an issue considering the limits a 2-hour course has. It's much easier now to go through the official documentation and learn the rest of it.

By Marco Burmeister on 9/3/2018

Grundsätzlich kannte ich das Thema. Details im Bereich Isolation waren für mich interessant. Für mich war es sehr hilfreich meinen Kenntnissstand zu vertiefen und einige Grundlage zu hören. Der Kurs erklärt, so wie ich es gesucht hatte, wie man solch ein Cluster aufsetzt.

By Milad Hamid on 8/29/2018

As MariaDB developer i want to setup staging mariadb galera cluster so this course was helpful. But i think two topics must be included then the course will be best refrence to setup galera cluster. 1- How to start, shutdown, restart the cluster safely? restart the cluster / bootstrap and other steps to consider when restart the cluster 2- HAProxy setup and configuration, i think it can be best to have videos on load balancer.

Showing all 10 reviews on CourseDuck

Read all 661 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 84 / 100