課程資料
報名日期
全年招生
課程級別
學習模式
修業期
2 小時 14 分鐘
教學語言
英語
授課導師
Hadi Alnabriss
評分
11次瀏覽
課程簡介
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.
課程章節
- 14 個章節
- 28 堂課
- 第 1 章 Preface
- 第 2 章 Database Replication Concepts
- 第 3 章 Certification Based Replication
- 第 4 章 Isolation
- 第 5 章 Snapshot Transfer
- 第 6 章 Galera Cluster Limitations
- 第 7 章 Building Galera Cluster (Practical Section)
- 第 8 章 Nodes Failure Tests (Practical Section)
- 第 9 章 Joining New Nodes (Practical)
- 第 10 章 Weighted Quorum
- 第 11 章 Galera Cluster Security
- 第 12 章 Load Balancing
- 第 13 章 Monitoring
- 第 14 章 Epilogue
課程內容
- 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
此課程所涵蓋的技能
評價
-
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)
