Course Outline

Introduction

Installing and configuring MariaDB

Overview of MariaDB architecture

Backing up and restoring MariaDB

Point-in-Time-Recovery (PiTR)

Securing MariaDB

Configuring MariaDB for high availability

Master-slave replication

Master-master replication

Setting up virtual IPs

Read/write distribution

Active-active clustering with Galera Cluster

Load balancing

Performance tuning in MariaDB

Hardware and performance

Schema tuning

Indexing

SQL query Tuning

Profiling

Closing remarks

Requirements

  • Experience with MySQL or MariaDB basic operations
  • Experience with SQL language
  • Experience with Linux command line

Audience

  • Developers
  • Database administrators
  • System administrators
 28 Hours

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from 6400 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (4)

Upcoming Courses

Related Categories