MariaDB Galera Cluster Administration Training in Marina Bay, Singapore

This hands-on course provides in-depth training on setting up, configuring, and managing MariaDB Galera Cluster for high availability and data consistency. It covers cluster architecture, deployment, configuration, troubleshooting, and performance tuning best practices.

GALERA CLUSTER BASICS AND SETUP

1. Introduction to Galera Cluster

• What is Galera Cluster
• Core concepts: synchronous replication, quorum, consistency
• Comparison with standard MariaDB replication

2. Galera Architecture and Components

• Node roles and data flow
• Write-set replication
• Certification-based replication model

3. Installing and Preparing MariaDB for Galera

• System prerequisites and package installation
• Network and firewall setup
• Choosing Galera version and MariaDB compatibility

4. Configuring a Galera Cluster

• galera.cnf and key configuration parameters
• Defining cluster name and node addresses
• Bootstrapping the first node
• Adding additional nodes to the cluster

5. Cluster Synchronization Mechanisms

• State Snapshot Transfer (SST)
• Incremental State Transfer (IST)
• Choosing and configuring SST methods (rsync, xtrabackup, etc.)

6. Hands-On Setup Exercise

CLUSTER MANAGEMENT, TUNING, AND TROUBLESHOOTING

1. Cluster Management and Monitoring

• Starting/stopping nodes
• Handling node failures and auto-recovery
• Monitoring cluster status with SHOW STATUS and custom scripts

2. Load Balancing and High Availability Tools

• Using HAProxy or MaxScale with Galera
• Read/write splitting and connection routing
• Configuring health checks and failover

3. Performance Tuning for Galera

• Flow control settings and latency tuning
• Optimizing InnoDB for Galera
• Avoiding large transactions and hotspot rows

4. Backup and Maintenance Strategies

• Performing backups in a Galera cluster
• Using mariabackup or Percona XtraBackup for hot backups
• Maintenance tasks without breaking quorum

5. Troubleshooting Common Issues

• Diagnosing node desynchronization
• Handling cluster splits and quorum loss
• Reviewing logs and error patterns

6. Final Review and Q&A

• Best practices summary
• Real-world design scenarios
• Resources for ongoing learning and certification