MariaDB High Availability & Performance Tuning

Session 01: MariaDB Replication

Session 02: MariaDB Galera Cluster

Session 03: Optimization and Tuning

Detailed Syllabus:

Session 01: MariaDB Replication

Replication Overview
Replication Commands
Setting Up Replication
Setting up a Replication Slave with Mariabackup
Replication as a Backup Solution
Multi-Source Replication
Replication Threads
Global Transaction ID
Parallel Replication
Replication and Binary Log System Variables
Replication and Binary Log Status Variables
Binary Log
Unsafe Statements for Statement-based Replication
Replication and Foreign Keys
Relay Log
Enhancements for START TRANSACTION WITH CONSISTENT SNAPSHOT
Group Commit for the Binary Log
Selectively Skipping Replication of Binlog Events
Binlog Event Checksums
Binlog Event Checksum Interoperability
Annotate_rows_log_event
Row-based Replication With No Primary Key
Replication Filters
Running Triggers on the Slave for Row-based Events
Semisynchronous Replication
Using MariaDB Replication with MariaDB Galera Cluster
Compressing Events to Reduce Size of the Binary Log
Delayed Replication
Replication When the Master and Slave Have Different Table Definitions
Restricting speed of reading binlog from master by a slave
Obsolete Replication Information
Changing a slave to become the master
Replication with Secure Connections

Session 02: MariaDB Galera Cluster

What is MariaDB Galera Cluster?
About Galera Replication
Galera Use Cases
MariaDB Galera Cluster – Known Limitations
Tips on Converting to Galera
Getting Started with MariaDB Galera Cluster
Configuring MariaDB Galera Cluster
State Snapshot Transfers (SSTs) in Galera Cluster
Galera Cluster Status Variables
Galera Cluster System Variables
Building the Galera wsrep Package on Ubuntu and Debian
Building the Galera wsrep Package on Fedora
Installing Galera from Source
Galera Test Repositories
wsrep_provider_options
Galera Cluster Address
Galera Load Balancer
MariaDB Galera Cluster Releases
Upgrading Galera Cluster
Using MariaDB Replication with MariaDB Galera Cluster
Securing Communications in Galera Cluster

Session 03: Optimization and Tuning

Hardware Optimization
Operating System Optimizations
Optimization and Indexes
Query Optimizations
Optimizing Tables
System Variables
Buffers, Caches and Threads
Optimizing Data Structure
MariaDB Internal Optimizations
Benchmarking
Compression

If You Like What We Do Here On DatabaseConcept, You Should Consider:

Stay Connected to: Twitter | Facebook

Subscribe to our email updates: Sign Up Now

 

We are thankful for your support.