Duration

Advanced MariaDB for High Availability and Performance

4 days

DESCRIPTION

MariaDB is a fork of MySQL and one of the most mainstream database servers.

In this educator drove, live preparing, members will figure out how to introduce, design and oversee MariaDB for high accessibility and execution. Different themes incorporate reinforcement and recuperation, security and grouping.

PRE-REQUISITES

Experience with MySQL or MariaDB essential activities
Experience with SQL language
Experience with Linux order line

TARGET AUDIENCES

Developers
Database executives
System executives

KEY LEARNING OUTCOME

Introducing and designing MariaDB
Diagram of MariaDB engineering
Support up and reestablishing MariaDB
Point-in-Time-Recovery (PiTR)
Verifying MariaDB

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

Programme scope, delivery arrangements and suitability are confirmed during enquiry.