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.
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)
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)
- Migrating data into Galera Cluster
- 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