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
 

Number of participants


Starts

Ends


Dates are subject to availability and take place between 9:30 am and 4:30 pm.
Open Training Courses require 5+ participants.

Testimonials (2)

Related Courses

Related Categories