Skip to main content

Managed MySQL (Percona XtraDB Cluster)

Okustera Managed MySQL delivers enterprise-grade, high-availability relational storage powered by Percona XtraDB Cluster (PXC) and synchronous Galera Multi-Master Replication.

It ensures zero data loss (RPO = 0) across failure domains, automatic node provisioning, and non-blocking state snapshot transfers (SST).

Architectural Highlights​

  • True Synchronous Multi-Master Replication: Transactions are certified and committed across quorum members simultaneously.
  • Zero Data Loss: Eliminates replication lag common in asynchronous MySQL master-slave setups.
  • Self-Healing State Transfers: If a node goes offline, it automatically re-synchronizes via Percona XtraBackup state transfers upon restart.
  • Integrated ProxySQL / HAProxy: Intelligent connection pooling, read/write splitting, and automated backend failover.

Provisioning with Terraform / Kubernetes​

apiVersion: pxc.percona.com/v1
kind: PerconaXtraDBCluster
metadata:
  name: production-mysql
  namespace: default
spec:
  crVersion: 1.14.0
  pxc:
    size: 3
    image: percona/percona-xtradb-cluster:8.0.35
    volumeSpec:
      persistentVolumeClaim:
        storageClassName: ceph-nvme
        resources:
          requests:
            storage: 50Gi
  proxysql:
    enabled: true
    size: 2
  backup:
    image: percona/percona-xtradb-cluster-operator:1.14.0-pxc8.0-backup
    storages:
      s3-backup:
        type: s3
        s3:
          bucket: my-mysql-backups
          endpointUrl: https://s3.okustera.com

Connecting via CLI or Application​

# Connect through ProxySQL read-write listener
mysql -h production-mysql-proxysql.default.svc.cluster.local -P 3306 -u app_user -p