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.

The important points

confirmation-grey

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.

confirmation-grey

Prerequisites

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

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

Ready to automate your database?

Sign up now and you’ll be running your database in just minutes.