Online Training: MariaDB Replication

MariaDB Replication is a 2 days team training, designed for DBAs who need to setup a High Availability environment based on MariaDB native replication.

This training covers the mechanisms that make replication work. You will learn how to setup a replication chain, how to administrate it, what to monitor and how to fix problems.

Objectives

  • Administering replication

    Learn to setup a replication environment, add replicas, provision replicas, move them to a different primary, or remove them.

  • Replication performance tuning

    Tune replication for the best performance. Prevent or troubleshoot replication lags.

  • Replication monitoring

    Monitor replication to be sure that its performance is adequate and data is consistent across the servers.

  • Failover and troubleshooting

    Learn to deal with disasters. Implement failover for applications and restore broken replication.

Topics

  • Understanding the Binary Log
    • ROW and STATEMENT formats
  • Configuring a primary server
  • How to start and provision new replicas
  • Dual-primary setup
  • Parallel replication
  • Replication filters
  • Multisource replication
  • Delayed replication
  • Replica promotion with GTID
  • Resolving conflicts with pt-table-checksum and pt-table-sync
  • Solving conflicts in a single table
  • Skipping conflicts to be fixed later
  • Monitoring replication: Seconds_behind_master, pt-heartbeat
  • Failover with ProxySQL
  • Replication best practices

Requirements

The course is designed for DBAs or DevOps with MariaDB working knowledge. A basic SQL knowledge is desirable.

All attendees should have a stable and reasonably fast internet connection. Having a backup connection to use in case of troubles is also desirable.

Attendees should have the following programs installed on their laptops:

  • The latest MariaDB stable version, or another
    version agreed with the customer before the beginning of the course. It
    is recommended that we use the MariaDB version they will use in their
    daily work.
  • mysql or mycli command-line interfaces. mysqli is bundled with MariaDB, whereas mycli is an open source project.
  • A terminal that allows to run system commands.

The operating system of choice is not relevant, as long as it is not too old or too new to run the MariaDB version of choice.

Cost and timing

The MariaDB Replication training has a cost of 2,500 GBP and its duration is 2 days.

A maximum of 15 attendees is allowed, and we encourage
customers to keep the number of attendees as low as 10. This allows a
good level of interactivity, and ensures that every attendee can obtain
the necessary support.

Get In Touch

Contact us to book this course for your team.

Contact Us