Galera Cluster and MariaDB MySQL Replication
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
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
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
Instructor
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.