We use cookies and other similar technology to collect data to improve your experience on our site, as described in our Privacy Policy.

AppsCode
  • KubeDB

    Run Production-Grade Databases on Kubernetes

    arrow_forward
    Stash

    Backup and Recovery Solution for Kubernetes

    arrow_forward
    KubeVault

    Run Production-Grade Vault on Kubernetes

    arrow_forward
    Voyager

    Secure HAProxy Ingress Controller for Kubernetes

    arrow_forward
    ConfigSyncer

    Kubernetes Configuration Syncer

    arrow_forward
    Guard

    Kubernetes Authentication WebHook Server

    arrow_forward
    KubeDB

    KubeDB simplifies Provision, Upgrade, Scaling, Volume Expansion, Monitor, Backup, Restore for various Databases in Kubernetes on any Public & Private Cloud

    • task_altLower administrative burden
    • task_altNative Kubernetes Support
    • task_altPerformance
    • task_altAvailability and durability
    • task_altManageability
    • task_altCost-effectiveness
    • task_altSecurity
    Stash

    A complete Kubernetes native disaster recovery solution for backup and restore your volumes and databases in Kubernetes on any public and private clouds.

    • task_altDeclarative API
    • task_altBackup Kubernetes Volumes
    • task_altBackup Database
    • task_altMultiple Storage Support
    • task_altDeduplication
    • task_altData Encryption
    • task_altVolume Snapshot
    • task_altPolicy Based Backup
    KubeVault

    KubeVault is a Git-Ops ready, production-grade solution for deploying and configuring Hashicorp's Vault on Kubernetes.

    • task_altVault Kubernetes Deployment
    • task_altAuto Initialization & Unsealing
    • task_altVault Backup & Restore
    • task_altConsume KubeVault Secrets with CSI
    • task_altManage DB Users Privileges
    • task_altStorage Backend
    • task_altAuthentication Method
    • task_altDatabase Secret Engine
    Voyager

    Secure HAProxy Ingress Controller for Kubernetes

    • task_altHTTP & TCP
    • task_altSSL
    • task_altPlatform support
    • task_altHAProxy
    • task_altPrometheus
    • task_altLet's Encrypt
    configsyncer

    Kubernetes Configuration Syncer

    • task_altConfiguration Syncer
    Guard

    Kubernetes Authentication WebHook Server

    • task_altIdentity Providers
    • task_altCLI
    • task_altRBAC
  • RESOURCES
  • Webinar New
CONTACT SALES
KubeDB KubeDB
github-icon twitterx-icon
TRY NOW FREE
You are looking at the documentation of a prior release. To read the documentation of the latest release, please visit here.

New to KubeDB? Please start here.

ProxySQLVersion

What is ProxySQLVersion

ProxySQLVersion is a Kubernetes Custom Resource Definitions (CRD). It provides a declarative configuration to specify the docker images to be used for ProxySQL deployed with KubeDB in a Kubernetes native way.

When you install KubeDB, a ProxySQLVersion custom resource will be created automatically for supported ProxySQL versions. You have to specify the name of ProxySQLVersion object in .spec.version field of ProxySQL object. Then, KubeDB will use the docker images specified in the ProxySQLVersion object to create your ProxySQL instance.

Using a separate CRD for this purpose allows us to modify the images, and policies independent of KubeDB operator. This will also allow the users to use a custom image for the ProxySQL.

ProxySQLVersion Specification

As with all other Kubernetes objects, a ProxySQLVersion needs apiVersion, kind, and metadata fields. It also needs a .spec section.

apiVersion: catalog.kubedb.com/v1alpha1
kind: ProxySQLVersion
metadata:
  name: "2.3.2-debian"
  labels:
    app: kubedb
spec:
  version: "2.3.2-debian"
  proxysql:
    image: "${KUBEDB_CATALOG_REGISTRY}/proxysql:2.3.2-debian-v2"
  exporter:
    image: "${KUBEDB_CATALOG_REGISTRY}/proxysql-exporter:1.1.0"
  podSecurityPolicies:
    databasePolicyName: proxysql-db

.metadata.name

.metadata.name is a required field that specifies the name of the ProxySQLVersion object. You have to specify this name in .spec.version field of ProxySQL object.

We follow this convention for naming ProxySQLVersion object:

  • Name format: {Original ProxySQL image version}-{modification tag}

We modify the original ProxySQL docker image to support additional features. An image with a higher modification tag will have more features than the images with a lower modification tag. Hence, it is recommended to use ProxySQLVersion object with the highest modification tag to take advantage of the latest features.

.spec.version

.spec.version is a required field that specifies the original version of ProxySQL that has been used to build the docker image specified in .spec.proxysql.image field.

.spec.deprecated

spec.deprecated is an optional field that specifies whether the docker images specified here is supported by the current KubeDB operator.

The default value of this field is false. If .spec.deprecated is set true, KubeDB operator will not deploy ProxySQL and other respective resources for this version.

.spec.proxysql.image

.spec.proxysql.image is a required field that specifies the docker image which will be used to create Statefulset by KubeDB operator to deploy expected ProxySQL.

.spec.exporter.image

.spec.exporter.image is a required field that specifies the image which will be used to export Prometheus metrics.

.spec.podSecurityPolicies.databasePolicyName

spec.podSecurityPolicies.databasePolicyName is a required field that specifies the name of the pod security policy required to get the ProxySQL pod(s) running.

Next Steps

  • Learn how to use KubeDB ProxySQL to load balance MySQL Group Replication here

What's on this Page

Search
Improve This Page