Galera Cluster and MariaDB MySQL Replication
- 4
Brief Introduction
MySQL and MariaDB Replication and High AvailabilityDescription
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.
Requirements
- Requirements
- To complete this course you must be familiar with, or at least have basic knowledge about MySQL queries, Linux CentOS and building Virtual machines for practical sections