Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 14 Minute(s)
Language
English
Taught by
Hadi Alnabriss
Rating
Course Overview
MySQL and MariaDB Replication and 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 Content
- 14 section(s)
- 28 lecture(s)
- Section 1 Preface
- Section 2 Database Replication Concepts
- Section 3 Certification Based Replication
- Section 4 Isolation
- Section 5 Snapshot Transfer
- Section 6 Galera Cluster Limitations
- Section 7 Building Galera Cluster (Practical Section)
- Section 8 Nodes Failure Tests (Practical Section)
- Section 9 Joining New Nodes (Practical)
- Section 10 Weighted Quorum
- Section 11 Galera Cluster Security
- Section 12 Load Balancing
- Section 13 Monitoring
- Section 14 Epilogue
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
Skills covered in this course
Reviews
-
ppetros Tilahun
Thsnk you
-
WWilliam Gould
Excellent match. This matched exactly a Production system I support in every way. So this has gone some way to help me support it in a better way!
-
KKamaldeen AbdulWahab
Please update it for galera 3 and compare it with PXC
-
SSergei Serko
quite a basic overview with stuff being postulated without any explanation/reasoning; a lot of time spent on meaningless terminal activities (e.g. waiting for mariadb to be downloaded)
