Galera Cluster and MariaDB MySQL Replication

Galera Cluster and MariaDB MySQL Replication, available at $49.99, has an average rating of 4.26, with 28 lectures, based on 541 reviews, and has 2226 subscribers.

You will learn about 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 This course is ideal for individuals who are Students interested in Mysql or MariaDB replication and Database High Availability It is particularly useful for Students interested in Mysql or MariaDB replication and Database High Availability.

Enroll now: Galera Cluster and MariaDB MySQL Replication

Summary

Title: Galera Cluster and MariaDB MySQL Replication

Price: $49.99

Average Rating: 4.26

Number of Lectures: 28

Number of Published Lectures: 28

Number of Curriculum Items: 28

Number of Published Curriculum Objects: 28

Original Price: $19.99

Quality Status: approved

Status: Live

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

Who Should Attend

Students interested in Mysql or MariaDB replication and Database High Availability

Target Audiences

Students interested in Mysql or MariaDB replication and Database High Availability

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.

Course Curriculum

Chapter 1: Preface

Lecture 1: Welcome To This Course

Chapter 2: Database Replication Concepts

Lecture 1: Database Replication

Lecture 2: ACID Model

Lecture 3: Master Slave and Multi Master Replication

Lecture 4: Synchronous and Asynchronous Replication

Lecture 5: Statement vs Row Based Replication

Chapter 3: Certification Based Replication

Lecture 1: Certification Based Replication

Lecture 2: Certification Process Examples

Chapter 4: Isolation

Lecture 1: Isolation Types

Lecture 2: Lost for Update Problem

Chapter 5: Snapshot Transfer

Lecture 1: Snapshot Transfer Modes

Chapter 6: Galera Cluster Limitations

Lecture 1: Galera Cluster Limitations

Chapter 7: Building Galera Cluster (Practical Section)

Lecture 1: Preparing the Nodes

Lecture 2: Installing MariaDB

Lecture 3: Basic Configurations

Lecture 4: Galera Configurations

Lecture 5: Starting The Cluster

Lecture 6: Checking Replication

Chapter 8: Nodes Failure Tests (Practical Section)

Lecture 1: Graceful Shutdown

Lecture 2: Poweroff Test

Lecture 3: Restarting the Cluster

Chapter 9: Joining New Nodes (Practical)

Lecture 1: Join Additional Node to the Cluster

Chapter 10: Weighted Quorum

Lecture 1: Split Brain Concepts

Lecture 2: Weighted Quorum

Chapter 11: Galera Cluster Security

Lecture 1: Galera Cluster Security

Chapter 12: Load Balancing

Lecture 1: Load Balancing Concepts

Chapter 13: Monitoring

Lecture 1: Reading WSREP Variables for Cluster Status

Chapter 14: Epilogue

Lecture 1: Congratulations for Course Completion

Instructors

Hadi Alnabriss
Engineer at Government Computer Center Palestinian Authority

Rating Distribution

1 stars: 9 votes
2 stars: 15 votes
3 stars: 97 votes
4 stars: 204 votes
5 stars: 216 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu