Training courses

Codership provides two types of training sessions: One for beginners and one for more advanced attendees

ADVANCED DATABASE ADMINISTRATION WITH GALERA CLUSTER

You are already an intermediate MySQL Database Administrator.  The Advanced Database Administrator with Galera Cluster training course 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:  In September 2021 (date to be decided)

USA:  In September 2021 (date to be decided)

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.
  • Understanding of Linux (e.g. package management) as well as MySQL — this really means you are familiar with RPM, YUM, DPKG, APT, a text editor on the command line (be it vim, or nano), the ability to edit configuration files, and so on. As for MySQL, you are expected to have installed it before, configured it to some extent, and know about asynchronous replication, set it up before, and also understand things like GRANTs.
  • 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

  • Experienced Database administrators (DBAs)
  • Intermediate MySQL DBAs or application developers who want to delve into Galera Cluster administration in depth
  • 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 — we expect to spend no more than 30 minutes on this, as you are already an intermediate user of MySQL)
  • 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 including the Galera Load Balancer (this is a mix of HOLs and instructor-led demos)
  • 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 17th of May 2021 1500 €/1750 USD for 2 days.
Volume discount for trainees from the same company: 4 pays for 3, 5 pays for 4 etc.

 

Let us know that you interested in our training by filling in the form

 

INSTALLATION AND INTRODUCTION TO DATABASE ADMINISTRATION WITH GALERA CLUSTER

Introduction to database administration with Galera Cluster – from Installation to configuration and monitoring your cluster for beginners. You will participate in interactive hands-on labs for installation. Our expert instructor will teach you how to design and maintain your Galera Cluster for High Availability and scalability. You will also learn a lot of important MySQL basics, to ensure that you can do the Advanced Database Administration with Galera Cluster course.

The course covers Galera Cluster for MySQL 8.0, and you can start off never having used Galera Cluster (and very minimal MySQL) to finish the training as an intermediate and effective Galera Cluster user and administrator.

 

Course Dates

Course Dates:

EMEA:  In September 2021 (date to be decided) 

USA:  In September 2021 (date to be decided)

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
  • Oracle or Microsoft SQL Server DBAs

Content Breakdown

Note that Hands On Labs are denoted with HOL.

  • Introduction to Galera Cluster
  • Understanding the MySQL architecture, including privileges 
  • Understanding High Availability and the different types of replication available in MySQL
  • Installing and setting up Galera Cluster (HOL)
  • Configuring Galera Cluster (HOL)
  • Understanding the Galera Arbitrator (HOL)
  • Understanding the Galera Load Balancer (instructor-led demo)
  • Basic monitoring for cluster health including the MySQL logs (HOL)
  • Understanding and using backups (HOL)
  • Query tuning and understanding the optimizer 

Cost

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

 

Let us know that you interested in our training by filling in the form