MariaDB Galera Cluster Training Course - Discover or improve your skills in SQL, SQL Server, PostgreSQL, Oracle and BI tools
- Price
- Duration
- Number of Hours
Each session will take place even if only one person is registered (except in cases of force majeure).
Description
This MariaDB Galera Cluster training course will enable you to understand the fundamentals of MariaDB, configure a functional Galera cluster, and master failover, recovery and monitoring scenarios.
In critical environments, databases must remain available at all times. MariaDB, coupled with Galera Cluster, offers real-time synchronous replication between multiple nodes, ensuring business continuity, fault tolerance, and horizontal scalability.
Format
Remote (recorded sessions).
GOOD TO KNOW
This training course includes numerous exercises (60% practical) to enhance learning. Each session will take place even if only one person is registered (except in cases of force majeure). A preliminary interview is held between the participant and/or a company representative in order to fully assess the participant’s profile (level, needs, professional context, challenges, etc.).
Assessment : during the training course, the trainer assesses the participants’ progress through multiple-choice questions, role-playing exercises and practical work. Participants receive a certificate of completion at the end of the training course.
objectives of this MariaDB Galera Cluster Training Course
By the end, each participant will be able to :
- Understand MariaDB architecture and how Galera Cluster works.
- Install, configure, and administer a secure and redundant Galera cluster.
- Ensure data synchronisation and avoid conflicts.
- Manage failure, split-brain, and automatic recovery scenarios.
- Optimise performance and monitor cluster health.
- Integrate the cluster into production environments.
Prerequisites of this MariaDB Galera Cluster Training Course
- Good foundation in Linux administration
- Basic knowledge of databases (MySQL or MariaDB)
- Experience in managing production services (CI/CD, monitoring, etc.)
- Because each participant has a unique background and expectations, a preliminary interview with our expert allows us to precisely identify their objectives, level and professional challenges.
This enables us to tailor the training content to ensure relevant and personalised learning.
Target Audience
Perfect training for system administrators, DevOps engineers, infrastructure managers, or IT architects.
Detailed of this MariaDB Galera Cluster Training
MariaDB architecture and replication principles
MariaDB vs MySQL, storage engines, master-slave vs multi-master architecture, synchronous replication concept.
Introduction to Galera Cluster
Operation, SST vs IST, quorum, write sets, multi-node topology, system requirements.
Cluster installation and configuration
Step-by-step deployment of MariaDB with Galera on multiple machines (Linux), firewall, SSL, communication testing.
Cluster management and maintenance
Adding/removing nodes, conflict management, control tools (galera_new_node, wsrep_status, etc.)
Security and supervision
Securing inter-node exchanges, audits, monitoring with Prometheus, Grafana or ClusterControl.
Failure scenarios and disaster recovery plans
Behaviour in the event of failure, split-brain, recovery, automatic restart, failover testing, PRA/PCA.
The advantages of this training course
This training course :
Combines advanced replication mechanisms + high availability
Includes practical multi-node exercises on simulated environments
Focuses on resilience and service continuity for critical contexts
Prepares you for real-world deployments in cloud or on-premise production environments
FORMA-IT's training courses are also supportive
At Forma-IT, we believe that training can also be a lever for solidarity. This is why part of each registration is donated to associations that work in areas that are close to our hearts :
- The SPA, for animal protection
- The Restos du Cœur, for the fight against precariousness
- Ludopital, to make the daily lives of hospitalized children easier
- APF France Handicap, for the rights of people with disabilities and their families
By choosing Forma-IT, you invest in your skills while contributing to essential causes.
Our related training courses
MySQL Training Course
Take control of MySQL database management, from installation to performance.
Would you like to know about upcoming sessions ?
Would you like to schedule this Training Couse on a specific date ? Contact us by email or by filling out the contact form.