KubeBlocks
BlogsKubeBlocks Cloud
Overview
Quickstart

Topologies

MySQL Semi-Synchronous Cluster
MySQL Cluster with ProxySQL
MySQL Group Replication Cluster
MySQL Group Replication with ProxySQL
MySQL Cluster with Orchestrator
MySQL with Orchestrator & ProxySQL

Operations

Lifecycle Management
Vertical Scaling
Horizontal Scaling
Volume Expansion
Manage MySQL Services
Minor Version Upgrade
Modify MySQL Parameters
Planned Switchover in MySQL
Decommission MySQL Replica
Recovering MySQL Replica

Backup And Restores

Create BackupRepo
Create Full Backup
Scheduled Backups
Scheduled Continuous Backup
Restore MySQL Cluster
Restore with PITR

Custom Secret

Custom Password
Custom Password Policy

TLS

MySQL Cluster with TLS
MySQL Cluster with User-Provided TLS
MySQL Cluster with mTLS

Monitoring

Observability for MySQL Clusters

Advanced Pod Management

Custom Scheduling Policies
Custom Pod Resources
Pod Management Parallelism
Using OnDelete for Controlled Pod Updates
Gradual Rolling Update
  1. Features
    1. Topologies
    2. Lifecycle Management
    3. Backup and Restore
    4. Supported Versions

Overview of KubeBlocks MySQL Addon

The KubeBlocks MySQL Addon offers a comprehensive solution for deploying and managing MySQL clusters in Kubernetes. This document provides an overview of its features, including deployment topologies, lifecycle management options, backup and restore functionality, and supported MySQL versions.

Features

Topologies

The KubeBlocks Operator supports deploying MySQL in three different topologies, tailored to meet varying requirements for performance, consistency, and high availability:

FeaturesDescription
SemiSyncLeverages MySQL’s semi-synchronous replication mechanism to achieve near-real-time data consistency.
• Requires at least one replica to acknowledge receipt of the transaction before the primary commits.
• Balances performance and consistency by reducing the chance of data loss in case of a primary failure.
MySQL Group Replication (MGR)Creates a distributed, multi-primary MySQL cluster using MySQL’s native Group Replication.
• Ensures fault-tolerant operations and automatic data synchronization across all nodes.
• Provides built-in conflict detection and resolution for continuous database availability.
Orchestrator IntegrationIntegrates an external Orchestrator for high-availability (HA) management.
• Adds automated monitoring and failover capabilities, including replica promotion.
• Allows dynamic handling of node failures or degradations, reducing downtime.

With these options, you can tailor your MySQL deployment to your specific requirements for performance, consistency, and availability.

Lifecycle Management

KubeBlocks provides robust lifecycle management features to simplify MySQL cluster operations:

FeaturesDescription
ProxySQLUse ProxySQL as database load balancer and query router for connection management and read-write splitting
Read ReplicasSecondary replicas can provide read-only services
Horizontal scalingModifying the number of replicas will trigger scale-in and scale-out operations
Vertical scalingAbility to adjust compute resources (CPU and memory) for MySQL replicas
Volume ExpansionSupport dynamic expansion of persistent storage volumes for MySQL replicas
RestartControlled restart of the MySQL cluster while maintaining high availability
Stop/StartAbility to stop and start the MySQL cluster for maintenance
Custom root passwordAbility to set and manage custom root password for the MySQL cluster during creation
Custom configuration templateProviding customized MySQL configuration file templates during creation
Dynamic Parameter ChangesReconfigure MySQL parameters dynamically without requiring a cluster restart
Expose Custom ServicesAbility to expose database services with custom configurations for different access requirements
SwitchoverPlanned primary-secondary switch operation with minimal downtime
Decommission specific replicaSafely take a specific MySQL replica offline for maintenance or decommissioning
Rebuild specific replicaRecover a replica in place or recreate it as a new replica to restore functionality
Minor Version UpgradePerform minor version upgrades of MySQL clusters without impacting availability
Advanced Pod ManagementSupport for custom Pod resources, custom scheduling policies, gradual rolling updates, and more advanced operational controls
TLS EncryptionSupport for enabling or disabling TLS encryption for secure database connections
Prometheus IntegrationIntegration with Prometheus managed by the Prometheus Operator for monitoring and alerting of MySQL metrics
Loki Stack IntegrationIntegrate with Loki Stack to collect MySQL error logs, audit logs, and slow query logs for better observability

Backup and Restore

FeaturesMethodsDescription
Full BackupxtrabackupUses xtrabackup to perform full backups
Continuous Backuparchive-binlogSupport for continuous backups to enable point-in-time recovery

Supported Versions

Major VersionsMinor Versions
5.75.7.44
8.0[8.0.30-8.0.39]
8.48.4.0,8.4.1,8.4.2

The list of supported versions can be found by following command:

kubectl get cmpv mysql

© 2025 ApeCloud PTE. Ltd.