0:58

🧩 / PerconaDB / Query

KindDescriptionPricing
UnitExecute SQL query against a PerconaDB databaseFREE

Introduction

This integration allows you to schedule SQL queries against a PerconaDB database.

Usage

This integration is distributed as an Helm chart. To install it, first add the following repository:

$ helm repo add link-society-incubator https://charts.link-society.com/incubator
$ helm repo update

Values

ValueDefaultDescription
scheduleevery 5 minutesDesired scheduling for the query
labels{}Map of labels to add to the Unit
dbmsperconaType of database to query. SHOULD NOT BE CHANGED
querySELECT 1Query to execute
cliArgs-Additional arguments to pass to the PerconaDB client
secretNamekubirds-sql-unit-dbms-credentialsName of the Kubernetes Secret containing the database credentials
image.percona.nameperconaDocker image name
image.percona.taglatestDocker image tag
image.percona.pullPolicyIfNotPresentKubernetes pull policy for the Docker image
serviceAccount.createtrueIf true, create the unit’s Kubernetes ServiceAccount
serviceAccount.annotations{}Additional annotations to add to the new ServiceAccount
serviceAccount.name-If not provided, will be set to default if serviceAccount.create is false, or to the chart’s full name if it is true

Credentials

The credentials information are given via a Kubernetes Secret with the following keys:

KeyDescription
DATABASE_HOSTDBMS Hostname
DATABASE_NAMEDatabase name
DATABASE_USERUsername
DATABASE_PASSWORDPassword

Setup

Install the unit with the following command:

$ helm install percona-availability link-society-incubator/kubirds-sql-unit \
    --namespace default \
    --set schedule="every 5 minutes" \
    --set dbms="percona" \
    --set secretName="percona-credentials"