Codership Training Courses¶
Using video communication conferencing systems such Zoom, Codership is able to offer live virtual classes. From your office, home, or virtually anywhere, you may attend courses conducted by the Codership staff. Each month we will offer courses on Galera Cluster and related software.
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
- EMEA: 31st of May and 1st of June
- USA: 2nd and 3rd of June
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.
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 optimization 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) (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)
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
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.
- Sign Up For Training
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
- EMEA: 14th and 15th of June
- USA: 16th and 17th of June
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.
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
- Understanding High Availability and the different types of replication available in MySQL
- 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
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
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.
- Sign Up For Training
