Course Outline

Topic overview

  • Why I need them and what are High-Availability solutions?
  • Cluster concepts
  • ​What is MariaDB Galera Cluster and what it offers to my organization?

Galera Cluster Management

  • How to start with Galera - what should I now before installation?
  • Architecture and functionality
  • First steps - Installation
  • Going deeper - Configuration and Set-up
  • Almost like a pro - Administration
  • Performance
  • Operations and operation modes
  • Upgrade Galera
  • Backups and restoring
  • ​Controlling state transfer between nodes

Load balancing

Monitoring

How to deal with Galera multi- master configuration

Advanced features

  • Security
  • Scalability
  • Replication
  • ​Advanced configuration

Requirements

Basic knowledge and experience as a MariaDB/ Percona/ MySQL Database Administrator
  21 Hours
 

Need help picking the right course?
Call us +971 4871 6715

Testimonials

the fact that we did a lot of exercises and Philip as an experienced trainer walked us through the answers

Angela - Anca Daescu, Ness
SQL Fundamentals Course

The structure of the course was perfect for my training style. For the time that we had here i think that the balance between theoretical work and practical work was perfect.

Matei - Anca Daescu, Ness
SQL Fundamentals Course

tonality, rhythm, good structure

Mihalache Dana - Anca Daescu, Ness
SQL Fundamentals Course

Still didn't finished the content

Mahmoud Abdallah Mohamed Hussein, e-finance
MariaDB Database Administration Course

Trainer was accommodative. And actually quite encouraging for me to take up the course.

Grace Goh - DBS Bank Ltd
Python in Data Science Course

all topics are interesting

- Stolt Tankers BV
MySQL Database Administration Course

The exercises done during the training.

Melvin Joseph Manalo - Stolt Tankers BV
MySQL Database Administration Course

The course built lesson to lesson, and the pacing was a big deal for me.

Bradford Moore - Regis College
SQL in MySQL Course

I mostly enjoyed the knowledge about replication database.

Suparman - Universitas Terbuka
Advanced MariaDB for High Availability and Performance Course

The trainer has extensive knowledge of IT.

Iwan Susanto - Universitas Terbuka
Advanced MariaDB for High Availability and Performance Course

He was very friendly and he created a very good environment.

- European Commision, Joint Research Centre
SQL Advanced in MySQL Course

The training exceeded my expectations on what I was hoping to learn.

Ian Matthews - Cision
MySQL Database Administration Course

Related Courses

MariaDB Database Administration

  14 hours
MariaDB Administration training course is for anyone who wants to administrate the MariaDB database server. It is a comprehensive course covering all administrator duties. The course explains how MariaDB Database works, what tools are available,
Read More...

Top 4 Linux/Unix Servers - DNS,Web,Mail and Database

  28 hours
Created Linux/Unix Administrators and developers who are interested with getting involved in LInux/Unix Servers Even beginners, who have the basic skill and knowledge on Linux, can catch up with this course just if you follow the
Read More...

Advanced MariaDB for High Availability and Performance

  28 hours
In this instructor-led, live training in <loc>, participants will learn how to install, configure and manage MariaDB for high availability and performance. Other topics include backup and recovery, security and
Read More...

MySQL Database Administration

  14 hours
MySQL Administration training course is for anyone who wants to administrate the MySQL database server. It is a comprehensive course covering all administrator duties. The course explains how MySQL Database works, what tools are available, how we
Read More...

SQL Fundamentals

  14 hours
This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn: how to write SQL queries what relational databases are and how we can
Read More...

SQL Advanced in MySQL

  7 hours
This course has been created for people already acquainted with SQL. The course introduces you into secrets common to all SQL databases as well as MySQL specific syntax, functions and
Read More...

SQL in MySQL

  14 hours
How to build a query? What is a relational database? What is the structure and SQL commands?
Read More...

MySQL Administration

  28 hours
Audience: Any IT professionals who aspire to become DBAs or database support professionals on MySql Database on linx/windows platforms. Format: 40% theoretical/lectures, 60%Practical/hands on
Read More...

Percona Server dla MySQL

  14 hours
Percona Server for MySQL is optimized for cloud computing, NoSQL access, containers and modern hardware such as SSD and Flash storage. Cloud ready Dramatically reduces downtime on servers with slow disks and large memory, such as 4XL EC2
Read More...

MySQL / Galera

  21 hours
This bespoke course has been designed specifically against the requirements provided by Now Managed Learning Services
Read More...

ProxySQL

  14 hours
This instructor-led, live training in <loc> (online or onsite) is aimed at engineers who wish to use a proxy approach to ensure high availability for MySQL based databases. By the end of this training, participants will be able
Read More...

Python in Data Science

  35 hours
The training course will help the participants prepare for Web Application Development using Python Programming with Data Analytics. Such data visualization is a great tool for Top Management in decision
Read More...

MySQL Developer

  21 hours
This instructor-led, live training in <loc> (online or onsite) is aimed at advanced-level developers who wish to learn and use MySQL and database technologies for building web applications. By the end of this training, participants will be
Read More...