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 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. We will provide the environment that you need to SSH into.
• 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.

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 1500 €/1750 USD applies orders before 27th of November.Volume discount for trainees from the same company: 4 pays for 3, 5 pays for 4 etc.