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: March 2021, 16th and 17th, starting 10 AM CET

USA: March 2021, 23rd and 24th, starting 9 AM EST

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 the Zoom desktop application (not within the web browser, as we will be sharing files)
  • 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-4 remote servers.
  • Some basic understanding of Linux (e.g. package management) as well as MySQL
  • You can also utilise your own Linux virtual machines, and note that you will need a minimum of 4. Please do not install anything beforehand, let it be a pristine CentOS 7 installation.

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

Note that Hands On Labs are denoted with HOL.

  • 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 (HOL)
  • Configuring your Galera Cluster optimally (HOL)
  • How do you backup and restore your Galera Cluster? We will cover XtraBackup and MariaBackup (HOL)
  • How do you handle load balancing with Galera Cluster and associated proxies? We will cover ProxySQL and HAProxy, and MariaDB MaxScale as well
  • 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 with Galera Manager? (HOL)
  • 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) (HOL)
  • How to do you administer a MariaDB Galera Cluster and Percona XtraDB Cluster (PXC) differently from upstream Galera Cluster that you get from Codership (HOL)

Cost

The cost of training is 1800 €/2100 USD for 2 days.
Early bird price before 28.2.2021 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