Training courses

Database Administration with Galera Cluster

The Database Administrator with Galera Cluster training teaches you how to install and configure in real-time a Galera Cluster for your application use cases. You will participate in interactive hands-on labs. Our expert instructors will teach you how to design and maintain your Galera Cluster for High Availability and scalability.
This course not only covers Galera Cluster from Codership (upstream Galera Cluster) but also Percona XtraDB Cluster (PXC) and MariaDB Galera Cluster administration. The course contents will cover the newly released Galera 4 library, but also the commonly used Galera 3 library. You can start off never having used Galera Cluster to finish the training as an advanced and effective Galera Cluster user and administrator.

Course Dates

Course Dates:

EMEA: January 2021, 13th and 14th, starting 10 AM CET

USA: January 2021, 20th and 21st, starting 9 AM PST

Course Duration

  • 2 days.
  • The breakdown is 3 hours, with a half hour lunch break, and another 3 hours per day. There will be bio-breaks. The total contact time with the trainer is 12 hours over a span of 2 days.

Requirements

  • You need to be able to use Zoom the platform we will be using
  • You will need to have access to an SSH client. Being in a Microsoft Windows environment is OK, but you need to have SSH to access up to 3 remote servers.
  • Some basic understanding of Linux (e.g. package management) as well as MySQL

Audience

  • Database administrators (DBAs)
  • MySQL DBAs or application developers who want to delve into Galera Cluster administration
  • Systems administrators with database management responsibilities
  • DevOps professionals who need to manage the database as well

Content Breakdown

  • An overview of MySQL High Availability solutions including coverage of Disaster Recovery options
  • What is Galera Cluster and why it is the right solution for you
  • Design simple and advanced Galera Cluster topologies
  • Installation of Galera Cluster
  • Configuring your Galera Cluster optimally
  • How do you backup and restore your Galera Cluster?
  • How do you handle load balancing with Galera Cluster and associated proxies?
  • Make Galera Cluster perform optimally — performance optimisation is key
  • Security of your Galera Cluster nodes and data, including the transport layer with SSL
  • Scalability with Galera Cluster
  • How do you monitor your entire Galera Cluster topology?
  • How to have a mix of Galera Cluster with standard MySQL replication
  • Migrating to Galera Cluster
  • Upgrading your Galera Cluster
  • Performing schema upgrades in your Galera Cluster
  • Troubleshoot common Galera Cluster problems (understanding diagnostics from the error log, debugging State Snapshot Transfer (SST) errors, are nodes finding it hard to rejoin due to network issues, figuring out how to fix the schema based on frequent transaction rollbacks, and so on)
  • How to do you administer a MariaDB Galera Cluster and Percona XtraDB Cluster (PXC) differently from upstream Galera Cluster that you get from Codership

Cost

The cost of training is 1800 €/2100 USD for 2 days.
Early bird price before 31.12.2020 1500 €/1750 USD for 2 days.
Volume discount for trainees from the same company: 4 pays for 3, 5 pays for 4 etc.

Sign Up For Training