clustercontrol Training

Galera Cluster training

Setting up and maintaining database clusters can be tricky. During this one-day, hands-on online training course you will gain the necessary knowledge and expertise to enable you to deploy, manage, monitor and scale entire Galera database clusters efficiently and reliably.

Schedule your session

The important points

Who should participate?

The course is designed for system administrators & database administrators looking to gain more in depth expertise in the automation and management of Galera Clusters.

Prerequisites

Basic knowledge MySQL and other relational databases — Required
Basic knowledge of high availability and clustering — Recommended
Basic Linux skills — Recommended

Format and costs

Format: Instructor-led online course in a virtual classroom with hands-on lab exercises. Each student will be provided with an individual, virtual lab access and course materials.
Duration: 8 hours (1 day)
Price: €750 per student (excl. VAT)

Schedule your session

Agenda

Introduction to Galera Cluster (1 hr)
- System architecture and overview
- Multi-data center setups
- Management and automation of ClusterControl
Deployment (2 hrs)
- Deployment basics
- Installing Galera Cluster
- Node / cluster recovery
Data migration (2 hrs)
- Migrating data into Galera Cluster
  - mysqldump
  - replication from existing system
- Caveats
- Hands-on exercise: load data and benchmarking (sysbench)
Monitoring (1 hr)
- Galera Cluster stats to monitor
- Troubleshooting basics
- Hands-on exercise: identify bottlenecks (Query Monitor, queues, etc.)
Management (2 hrs)
- Load balancing with HAProxy
- Scaling by adding nodes
- Backup best practices and restore
- Upgrades
- Hands-on exercise: schema management

Reserve a seat

"*" indicates required fields

Ready to automate your database?

Get started