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.

Galera Cluster Training

Provide your customers with the most advanced and performant open-source databases as DBaaS

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)
  • 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

Hidden