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.
Reconfigure MariaDB Standalone Database
This guide will show you how to use KubeDB
Enterprise operator to reconfigure a MariaDB Standalone.
Before You Begin
At first, you need to have a Kubernetes cluster, and the
kubectl
command-line tool must be configured to communicate with your cluster.Install
KubeDB
Community and Enterprise operator in your cluster following the steps here.You should be familiar with the following
KubeDB
concepts:
To keep everything isolated, we are going to use a separate namespace called demo
throughout this tutorial.
$ kubectl create ns demo
namespace/demo created
Now, we are going to deploy a MariaDB
Standalone using a supported version by KubeDB
operator. Then we are going to apply MariaDBOpsRequest
to reconfigure its configuration.
Prepare MariaDB Standalone
Now, we are going to deploy a MariaDB
Standalone database with version 10.6.4
.
Deploy MariaDB
At first, we will create md-config.cnf
file containing required configuration settings.
$ cat md-config.cnf
[mysqld]
max_connections = 200
read_buffer_size = 1048576
Here, max_connections
is set to 200
, whereas the default value is 151
. Likewise, read_buffer_size
has the deafult value 131072
.
Now, we will create a secret with this configuration file.
$ kubectl create secret generic -n demo md-configuration --from-file=./md-config.cnf
secret/md-configuration created
In this section, we are going to create a MariaDB object specifying spec.configSecret
field to apply this custom configuration. Below is the YAML of the MariaDB
CR that we are going to create,
apiVersion: kubedb.com/v1alpha2
kind: MariaDB
metadata:
name: sample-mariadb
namespace: demo
spec:
version: "10.6.4"
configSecret:
name: md-configuration
storageType: Durable
storage:
storageClassName: "standard"
accessModes:
- ReadWriteOnce
resources:
requests:
storage: 1Gi
terminationPolicy: WipeOut
Let’s create the MariaDB
CR we have shown above,
$ kubectl create -f https://github.com/kubedb/docs/raw/v2022.05.24/docs/guides/mariadb/reconfigure/standalone/examples/sample-mariadb-config.yaml
mariadb.kubedb.com/sample-mariadb created
Now, wait until sample-mariadb
has status Ready
. i.e,
$ kubectl get mariadb -n demo
NAME VERSION STATUS AGE
sample-mariadb 10.6.4 Ready 61s
Now, we will check if the database has started with the custom configuration we have provided.
First we need to get the username and password to connect to a mariadb instance,
$ kubectl get secrets -n demo sample-mariadb-auth -o jsonpath='{.data.\username}' | base64 -d
root
$ kubectl get secrets -n demo sample-mariadb-auth -o jsonpath='{.data.\password}' | base64 -d
PlWA6JNLkNFudl4I
Now, we will check if the database has started with the custom configuration we have provided.
$ kubectl exec -it -n demo sample-mariadb-0 -c mariadb -- bash
root@sample-mariadb-0:/# mysql -u${MYSQL_ROOT_USERNAME} -p${MYSQL_ROOT_PASSWORD}
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 11
Server version: 10.6.4-MariaDB-1:10.6.4+maria~focal mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show variables like 'max_connections';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 200 |
+-----------------+-------+
1 row in set (0.001 sec)
MariaDB [(none)]> show variables like 'read_buffer_size';
+------------------+---------+
| Variable_name | Value |
+------------------+---------+
| read_buffer_size | 1048576 |
+------------------+---------+
1 row in set (0.001 sec)
MariaDB [(none)]> exit
Bye
As we can see from the configuration of ready mariadb, the value of max_connections
has been set to 200
and read_buffer_size
has been set to 1048576
.
Reconfigure using new config secret
Now we will reconfigure this database to set max_connections
to 250
and read_buffer_size
to 122880
.
Now, we will create new file new-md-config.cnf
containing required configuration settings.
$ cat new-md-config.cnf
[mysqld]
max_connections = 250
read_buffer_size = 122880
Then, we will create a new secret with this configuration file.
$ kubectl create secret generic -n demo new-md-configuration --from-file=./new-md-config.cnf
secret/new-md-configuration created
Create MariaDBOpsRequest
Now, we will use this secret to replace the previous secret using a MariaDBOpsRequest
CR. The MariaDBOpsRequest
yaml is given below,
apiVersion: ops.kubedb.com/v1alpha1
kind: MariaDBOpsRequest
metadata:
name: mdops-reconfigure-config
namespace: demo
spec:
type: Reconfigure
databaseRef:
name: sample-mariadb
configuration:
configSecret:
name: new-md-configuration
Here,
spec.databaseRef.name
specifies that we are reconfiguringmdops-reconfigure-config
database.spec.type
specifies that we are performingReconfigure
on our database.spec.configuration.configSecret.name
specifies the name of the new secret.
Let’s create the MariaDBOpsRequest
CR we have shown above,
$ kubectl apply -f https://github.com/kubedb/docs/raw/v2022.05.24/docs/guides/mariadb/reconfigure/standalone/examples/reconfigure-using-secret.yaml
mariadbopsrequest.ops.kubedb.com/mdops-reconfigure-config created
Verify the new configuration is working
If everything goes well, KubeDB
Enterprise operator will update the configSecret
of MariaDB
object.
Let’s wait for MariaDBOpsRequest
to be Successful
. Run the following command to watch MariaDBOpsRequest
CR,
$ kubectl get mariadbopsrequest --all-namespaces
NAMESPACE NAME TYPE STATUS AGE
demo mdops-reconfigure-config Reconfigure Successful 2m8s
We can see from the above output that the MariaDBOpsRequest
has succeeded. If we describe the MariaDBOpsRequest
we will get an overview of the steps that were followed to reconfigure the database.
$ kubectl describe mariadbopsrequest -n demo mdops-reconfigure-config
Name: mdops-reconfigure-config
Namespace: demo
Labels: <none>
Annotations: <none>
API Version: ops.kubedb.com/v1alpha1
Kind: MariaDBOpsRequest
Metadata:
Creation Timestamp: 2022-06-14T10:56:01Z
Generation: 1
Resource Version: 21589
UID: 43997fe8-fa12-4d38-a29f-d101889d4e72
Spec:
Configuration:
Config Secret:
Name: new-md-configuration
Database Ref:
Name: sample-mariadb
Type: Reconfigure
Status:
Conditions:
Last Transition Time: 2022-06-14T10:56:01Z
Message: Controller has started to Progress the MariaDBOpsRequest: demo/mdops-reconfigure-config
Observed Generation: 1
Reason: OpsRequestProgressingStarted
Status: True
Type: Progressing
Last Transition Time: 2022-06-14T10:56:11Z
Message: Successfully restarted MariaDB pods for MariaDBOpsRequest: demo/mdops-reconfigure-config
Observed Generation: 1
Reason: SuccessfullyRestatedStatefulSet
Status: True
Type: RestartStatefulSetPods
Last Transition Time: 2022-06-14T10:56:16Z
Message: Successfully reconfigured MariaDB for MariaDBOpsRequest: demo/mdops-reconfigure-config
Observed Generation: 1
Reason: SuccessfullyDBReconfigured
Status: True
Type: DBReady
Last Transition Time: 2022-06-14T10:56:16Z
Message: Controller has successfully reconfigure the MariaDB demo/mdops-reconfigure-config
Observed Generation: 1
Reason: OpsRequestProcessedSuccessfully
Status: True
Type: Successful
Observed Generation: 3
Phase: Successful
Now let’s connect to a mariadb instance and run a mariadb internal command to check the new configuration we have provided.
$ $ kubectl exec -it -n demo sample-mariadb-0 -c mariadb -- bash
root@sample-mariadb-0:/# mysql -u${MYSQL_ROOT_USERNAME} -p${MYSQL_ROOT_PASSWORD}
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 21
Server version: 10.6.4-MariaDB-1:10.6.4+maria~focal mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show variables like 'max_connections';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 250 |
+-----------------+-------+
1 row in set (0.001 sec)
MariaDB [(none)]> show variables like 'read_buffer_size';
+------------------+--------+
| Variable_name | Value |
+------------------+--------+
| read_buffer_size | 122880 |
+------------------+--------+
1 row in set (0.001 sec)
MariaDB [(none)]> exit
Bye
As we can see from the configuration has changed, the value of max_connections
has been changed from 200
to 250
and and the read_buffer_size
has been changed 1048576
to 122880
. So the reconfiguration of the database is successful.
Reconfigure Existing Config Secret
Now, we will create a new MariaDBOpsRequest
to reconfigure our existing secret new-md-configuration
by modifying our new-md-config.cnf
file using applyConfig
. The MariaDBOpsRequest
yaml is given below,
apiVersion: ops.kubedb.com/v1alpha1
kind: MariaDBOpsRequest
metadata:
name: mdops-reconfigure-apply-config
namespace: demo
spec:
type: Reconfigure
databaseRef:
name: sample-mariadb
configuration:
applyConfig:
new-md-config.cnf: |
[mysqld]
max_connections = 230
read_buffer_size = 1064960
innodb-config.cnf: |
[mysqld]
innodb_log_buffer_size = 17408000
Note: You can modify multiple fields of your current configuration using
applyConfig
. If you don’t have any secrets thenapplyConfig
will create a secret for you. Here, we modified value of our two existing fields which aremax_connections
andread_buffer_size
also, we modified a new fieldinnodb_log_buffer_size
of our configuration.
Here,
spec.databaseRef.name
specifies that we are reconfiguringsample-mariadb
database.spec.type
specifies that we are performingReconfigure
on our database.spec.configuration.applyConfig
contains the configuration of existing or newly created secret.
Before applying this yaml we are going to check the existing value of our new field,
$ kubectl exec -it sample-mariadb-0 -n demo -c mariadb -- bash
root@sample-mariadb-0:/# mysql -u${MYSQL_ROOT_USERNAME} -p${MYSQL_ROOT_PASSWORD}
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 21
Server version: 10.6.4-MariaDB-1:10.6.4+maria~focal mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show variables like 'innodb_log_buffer_size';
+------------------------+----------+
| Variable_name | Value |
+------------------------+----------+
| innodb_log_buffer_size | 16777216 |
+------------------------+----------+
1 row in set (0.001 sec)
MariaDB [(none)]> exit
Bye
Here, we can see the default value for innodb_log_buffer_size
is 16777216
.
Let’s create the MariaDBOpsRequest
CR we have shown above,
$ kubectl apply -f https://github.com/kubedb/docs/raw/v2022.05.24/docs/guides/mariadb/reconfigure/standalone/examples/mdops-reconfigure-apply-config.yaml
mariadbopsrequest.ops.kubedb.com/mdops-reconfigure-apply-config created
Verify the new configuration is working
If everything goes well, KubeDB
Enterprise operator will update the configSecret
of MariaDB
object.
Let’s wait for MariaDBOpsRequest
to be Successful
. Run the following command to watch MariaDBOpsRequest
CR,
$ kubectl get mariadbopsrequest mdops-reconfigure-apply-config -n demo
NAME TYPE STATUS AGE
mdops-reconfigure-apply-config Reconfigure Successful 3m11s
We can see from the above output that the MariaDBOpsRequest
has succeeded. If we describe the MariaDBOpsRequest
we will get an overview of the steps that were followed to reconfigure the database.
$ kubectl describe mariadbopsrequest -n demo mdops-reconfigure-apply-config
Name: mdops-reconfigure-apply-config
Namespace: demo
Labels: <none>
Annotations: <none>
API Version: ops.kubedb.com/v1alpha1
Kind: MariaDBOpsRequest
Metadata:
Creation Timestamp: 2022-06-14T09:13:49Z
Generation: 1
Resource Version: 14120
UID: eb8d5df5-a0ce-4011-890c-c18c0200b5ac
Spec:
Configuration:
Apply Config:
innodb-config.cnf: [mysqld]
innodb_log_buffer_size = 17408000
new-md-config.cnf: [mysqld]
max_connections = 230
read_buffer_size = 1064960
Database Ref:
Name: sample-mariadb
Type: Reconfigure
Status:
Conditions:
Last Transition Time: 2022-06-14T09:13:49Z
Message: Controller has started to Progress the MariaDBOpsRequest: demo/mdops-reconfigure-apply-config
Observed Generation: 1
Reason: OpsRequestProgressingStarted
Status: True
Type: Progressing
Last Transition Time: 2022-06-14T09:13:49Z
Message: Successfully prepared user provided custom config secret
Observed Generation: 1
Reason: PrepareSecureCustomConfig
Status: True
Type: PrepareCustomConfig
Last Transition Time: 2022-06-14T09:17:24Z
Message: Successfully restarted MariaDB pods for MariaDBOpsRequest: demo/mdops-reconfigure-apply-config
Observed Generation: 1
Reason: SuccessfullyRestatedStatefulSet
Status: True
Type: RestartStatefulSetPods
Last Transition Time: 2022-06-14T09:17:29Z
Message: Successfully reconfigured MariaDB for MariaDBOpsRequest: demo/mdops-reconfigure-apply-config
Observed Generation: 1
Reason: SuccessfullyDBReconfigured
Status: True
Type: DBReady
Last Transition Time: 2022-06-14T09:17:29Z
Message: Controller has successfully reconfigure the MariaDB demo/mdops-reconfigure-apply-config
Observed Generation: 1
Reason: OpsRequestProcessedSuccessfully
Status: True
Type: Successful
Observed Generation: 3
Phase: Successful
Now let’s connect to a mariadb instance and run a mariadb internal command to check the new configuration we have provided.
$ kubectl exec -it -n demo sample-mariadb-0 -c mariadb -- bash
root@sample-mariadb-0:/# mysql -u${MYSQL_ROOT_USERNAME} -p${MYSQL_ROOT_PASSWORD}
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 24
Server version: 10.6.4-MariaDB-1:10.6.4+maria~focal mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show variables like 'max_connections';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 230 |
+-----------------+-------+
1 row in set (0.001 sec)
MariaDB [(none)]> show variables like 'read_buffer_size';
+------------------+---------+
| Variable_name | Value |
+------------------+---------+
| read_buffer_size | 1064960 |
+------------------+---------+
1 row in set (0.002 sec)
MariaDB [(none)]> show variables like 'innodb_log_buffer_size';
+------------------------+----------+
| Variable_name | Value |
+------------------------+----------+
| innodb_log_buffer_size | 17408000 |
+------------------------+----------+
1 row in set (0.001 sec)
MariaDB [(none)]> exit
Bye
As we can see from above the configuration has been changed, the value of max_connections
has been changed from 250
to 230
and the read_buffer_size
has been changed 122880
to 1064960
also, innodb_log_buffer_size
has been changed from 16777216
to 17408000
. So the reconfiguration of the sample-mariadb
database is successful.
Remove Custom Configuration
We can also remove exisiting custom config using MariaDBOpsRequest
. Provide true
to field spec.configuration.removeCustomConfig
and make an Ops Request to remove existing custom configuration.
Create MariaDBOpsRequest
Lets create an MariaDBOpsRequest
having spec.configuration.removeCustomConfig
is equal true
,
apiVersion: ops.kubedb.com/v1alpha1
kind: MariaDBOpsRequest
metadata:
name: mdops-reconfigure-remove
namespace: demo
spec:
type: Reconfigure
databaseRef:
name: sample-mariadb
configuration:
removeCustomConfig: true
Here,
spec.databaseRef.name
specifies that we are reconfiguringmdops-reconfigure-remove
database.spec.type
specifies that we are performingReconfigure
on our database.spec.configuration.removeCustomConfig
is a bool field that should betrue
when you want to remove existing custom configuration.
Let’s create the MariaDBOpsRequest
CR we have shown above,
$ kubectl apply -f https://github.com/kubedb/docs/raw/v2022.05.24/docs/guides/mariadb/reconfigure/standalone/examples/reconfigure-remove.yaml
mariadbopsrequest.ops.kubedb.com/mdops-reconfigure-remove created
Verify the new configuration is working
If everything goes well, KubeDB
Enterprise operator will update the configSecret
of MariaDB
object.
Let’s wait for MariaDBOpsRequest
to be Successful
. Run the following command to watch MariaDBOpsRequest
CR,
$ kubectl get mariadbopsrequest --all-namespaces
NAMESPACE NAME TYPE STATUS AGE
demo mdops-reconfigure-remove Reconfigure Successful 2m5s
Now let’s connect to a mariadb instance and run a mariadb internal command to check the new configuration we have provided.
$ kubectl exec -it -n demo sample-mariadb-0 -- bash
root@sample-mariadb-0:/ mysql -u${MYSQL_ROOT_USERNAME} -p${MYSQL_ROOT_PASSWORD}
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.6.4-MariaDB-1:10.6.4+maria~focal mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
# value of `max_conncetions` is default
MariaDB [(none)]> show variables like 'max_connections';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 151 |
+-----------------+-------+
1 row in set (0.001 sec)
# value of `read_buffer_size` is default
MariaDB [(none)]> show variables like 'read_buffer_size';
+------------------+---------+
| Variable_name | Value |
+------------------+---------+
| read_buffer_size | 131072 |
+------------------+---------+
1 row in set (0.001 sec)
# value of `innodb_log_buffer_size` is default
MariaDB [(none)]> show variables like 'innodb_log_buffer_size';
+------------------------+----------+
| Variable_name | Value |
+------------------------+----------+
| innodb_log_buffer_size | 16777216 |
+------------------------+----------+
1 row in set (0.001 sec)
MariaDB [(none)]> exit
Bye
As we can see from the configuration has changed to its default value. So removal of existing custom configuration using MariaDBOpsRequest
is successful.
Cleaning Up
To clean up the Kubernetes resources created by this tutorial, run:
$ kubectl delete mariadb -n demo sample-mariadb
$ kubectl delete mariadbopsrequest -n demo mdops-reconfigure-config mdops-reconfigure-apply-config mdops-reconfigure-remove
$ kubectl delete ns demo