Galera Cluster and MariaDB MySQL Replication

Focused View

Hadi Alnabriss

2:14:31

69 View

1 - Preface

1 - Galera-Cluster.pdf

1 - Galera-Cluster.pptx

1 - Welcome To This Course.mp4

01:06

2 - Database Replication Concepts

2 - Database Replication.mp4

01:10

3 - ACID Model.mp4

01:07

4 - Master Slave and Multi Master Replication.mp4

02:21

5 - Synchronous and Asynchronous Replication.mp4

05:35

6 - Statement vs Row Based Replication.mp4

01:19

3 - Certification Based Replication

7 - Certification Based Replication.mp4

02:40

8 - Certification Process Examples.mp4

06:24

4 - Isolation

9 - Isolation Types.mp4

08:38

10 - Lost for Update Problem.mp4

03:46

5 - Snapshot Transfer

11 - Snapshot Transfer Modes.mp4

04:19

6 - Galera Cluster Limitations

12 - Galera Cluster Limitations.mp4

03:18

7 - Building Galera Cluster Practical Section

13 - Preparing the Nodes.mp4

07:24

14 - Installing MariaDB.mp4

11:07

15 - Basic Configurations.mp4

01:59

16 - Galera Configurations.mp4

09:01

17 - Starting The Cluster.mp4

04:54

18 - Checking Replication.mp4

05:46

8 - Nodes Failure Tests Practical Section

19 - Graceful Shutdown.mp4

07:33

20 - Poweroff Test.mp4

06:39

21 - Restarting the Cluster.mp4

05:07

9 - Joining New Nodes Practical

22 - Join Additional Node to the Cluster.mp4

11:57

10 - Weighted Quorum

23 - Split Brain Concepts.mp4

02:48

24 - Weighted Quorum.mp4

06:39

11 - Galera Cluster Security

25 - Galera Cluster Security.mp4

03:39

12 - Load Balancing

26 - Load Balancing Concepts.mp4

03:44

13 - Monitoring

27 - Reading WSREP Variables for Cluster Status.mp4

03:49

14 - Epilogue

28 - Congratulations for Course Completion.mp4

00:42

Description

MySQL and MariaDB Replication and High Availability

What You'll 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 is this for?

Students interested in Mysql or MariaDB replication and Database High Availability

More details

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.
Who this course is for:
Students interested in Mysql or MariaDB replication and Database High Availability

User Reviews

Rating

average 0

Total votes0

Focused display

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.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.