MariaDB Galera Cluster Administration Training Course
This course is intended for database administrators.
The course presents options for High-Availability solutions using Galera Cluster.
You will learn the basics of Galera technology, as well as more advanced topics and practical knowledge related to configuring, optimizing and administering a Galera Cluster.
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
Open Training Courses require 5+ participants.
MariaDB Galera Cluster Administration Training Course - Booking
MariaDB Galera Cluster Administration Training Course - Enquiry
MariaDB Galera Cluster Administration - Consultancy Enquiry
Consultancy Enquiry
Testimonials (2)
Was well organized Instructor ability to explain concepts, in a manner that is easy to understand
Oana Bunea - SERVICIUL DE TELECOMUNICATII SPECIALE
Course - MariaDB Galera Cluster Administration
exercise: setting up HAProxy for load balancing Galera cluster lecture: certification based replication
Kateryna Tokar - Clay Solutions
Course - MariaDB Galera Cluster Administration
Upcoming Courses (Minimal 5 peserta)
Related Courses
MySQL Administration
28 HoursAudience: 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 lab
Top 4 Linux/Unix Servers - DNS,Web,Mail and Database
28 Hours- Dibuat Linux/Administrator dan pengembang Unix yang tertarik untuk terlibat dalam Server LInux/Unix
- Bahkan pemula, yang memiliki keterampilan dan pengetahuan dasar tentang Linux, dapat mengejar ketinggalan dalam kursus ini hanya jika Anda mengikuti lab dan penjelasan instruktur secara rinci.
- Kursus ini dimaksudkan untuk melatih Manajemen Linux Server dan menunjukkan bahwa sangat mudah memahami server Linux/Unix.
- Kursus ini akan disampaikan kepada audiens dengan 40% ceramah, 50% praktikum, dan 10% sesi tanya jawab. Kursus lima hari ini sangat menekankan aktivitas berbasis praktikum.
- Anda akan mempelajari cara menerapkan dan mengelola 4 Server Teratas Linux yang menyediakan layanan jaringan yang sangat berguna bagi lingkungan perusahaan yang sangat penting.
- Dapat dikirimkan pada distribusi apa pun (Fedora, CentOS umumnya digunakan)
MariaDB Database Administration
14 HoursMariaDB 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, how we can use them, how we can secure the MariaDB Database Server and configure it. During the training course you will learn how to manage user accounts and how the MariaDB Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.
Advanced MariaDB for High Availability and Performance
28 HoursIn this instructor-led, live training in Indonesia, participants will learn how to install, configure and manage MariaDB for high availability and performance. Other topics include backup and recovery, security and clustering.
MySQL Database Administration
14 HoursMySQL Kursus pelatihan administrasi adalah untuk siapa saja yang ingin mengatur server database MySQL. Ini adalah kursus komprehensif yang mencakup semua tugas administrator.
Kursus ini menjelaskan bagaimana MySQL Database bekerja, alat apa yang tersedia, bagaimana kita dapat menggunakannya, bagaimana kita dapat mengamankan Server MySQL Database dan mengonfigurasinya. Selama kursus pelatihan, Anda akan mempelajari cara mengelola akun pengguna dan cara kerja MySQL Access Sistem Privilege. Anda juga akan belajar bagaimana memelihara database Anda, mencadangkan dan memulihkan database Anda dan melakukan pemulihan kerusakan.
MySQL Developer
21 HoursThis instructor-led, live training in Indonesia (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 able to:
- Write SQL queries to retrieve, filter, sort, and aggregate data.
- Perform data manipulation operations such as inserting, updating, and deleting data.
- Implement advanced SQL concepts such as subqueries, derived tables, and conditional logic.
- Integrate MySQL with popular programming languages and execute queries from application code.
MySQL / Galera
21 HoursThis bespoke course has been designed specifically against the requirements provided by Now Managed Learning Services
Percona Server dla MySQL
14 HoursPelatihan "Percona Server untuk MySQL" berfokus pada optimalisasi penggunaan Percona Server untuk MySQL, dioptimalkan untuk komputasi awan, akses NoSQL, container, dan perangkat keras modern seperti SSD dan penyimpanan Flash. Kursus ini mencakup instalasi, konfigurasi dan optimalisasi Percona Server, dengan fokus pada fitur yang berkaitan dengan keamanan, skalabilitas, pemantauan dan manajemen data. Peserta akan memperoleh keterampilan praktis yang memungkinkan penggunaan kemampuan tingkat lanjut Percona Server untuk MySQL secara efektif.
Python in Data Science
35 HoursThe 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 making.
SQL Fundamentals
14 HoursThis 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 use them
- what are relations and how to create them
- the structure of data
- differences between SQL dialects (Oracle, T-SQL, ANSI)
- practical skills for writing queries
This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases.
SQL in MySQL
14 Hours- How to build a query?
- What is a relational database?
- What is the structure and SQL commands?
SQL Advanced in MySQL
7 HoursThis 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 features.