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
