How to Backup Kubernetes MySQL Operator Clusters

Graphic showing the MySQL logo

Oracle’s MySQL Operator for Kubernetes is a convenient way to automate MySQL database provisioning within your cluster. One of the operator’s headline features is integrated hands-off backup support that increases your resiliency. Backups copy your database to external storage on a recurring schedule.

This article will walk you through setting up backups to an Amazon S3-compatible object storage service. You’ll also see how to store backups in Oracle Cloud Infrastructure (OCI) storage or local persistent volumes inside your cluster.

Preparing a Database Cluster

Install the MySQL operator in your Kubernetes cluster and create a simple database instance for testing purposes. Copy the YAML below and save it to mysql.yaml:

apiVersion: v1
kind: Secret
metadata:
  name: mysql-root-user
stringData:
  rootHost: "%"
  rootUser: "root"
  rootPassword: "P@$$w0rd"
 
---

apiVersion: mysql.oracle.com/v2
kind: InnoDBCluster
metadata:
  name: mysql-cluster
spec:
  secretName: mysql-root-user
  instances: 3
  tlsUseSelfSigned: true
  router:
    instances: 1

Use Kubectl to apply the manifest:

$ kubectl apply -f mysql.yaml

Wait a few minutes while the MySQL operator provisions your Pods. Use Kubectl’s get pods command to check on the progress. You should see four running Pods: one MySQL router instance and three MySQL server replicas.

$ kubectl get pods
NAME                                    READY   STATUS    RESTARTS   AGE
mysql-cluster-0                         2/2     Running   0          2m
mysql-cluster-1                         2/2     Running   0          2m
mysql-cluster-2                         2/2     Running   0          2m
mysql-cluster-router-6b68f9b5cb-wbqm5   1/1     Running   0          2m

Defining a Backup Schedule

The MySQL operator requires two components to successfully create a

Read more
Oracle Cloud Native Environment 1.5.7 highlights Kubernetes

Oracle Cloud Indigenous Atmosphere, for creating cloud-indigenous programs, has been increased to leverage the Kubernetes 1.24 container-orchestration system.

Kubernetes 1.24 lodging are highlighted in Cloud Indigenous Ecosystem 1.5.7, which was unveiled previously this thirty day period. Enhancements cover an improved container runtime set up, a deployment model for diverse factors of the surroundings, and lifecycle administration for infrastructure. Kubernetes 1.24 was produced May possibly 3. Also with this variation, deployment of Cloud Indigenous Natural environment itself has been built simpler, Oracle reported. The platform’s command-line interface has been enhanced with commands for faster, extra intuitive deployment.

Cloud Indigenous Surroundings provides a picked established of open up resource computer software, delivering an setting for working containerized programs. A framework is showcased for installations, updates, updates, and configuring microservices options. Other functions of Cloud Indigenous Environment 1.5.7 involve:

  • The Istio service mesh module was enhanced to make it possible for many modules to be installed employing customized profiles whilst retaining a solitary Istio manage plane. This provides customization of the command aircraft and of the sidecars for the Istio data aircraft.
  • Assist is supplied for Oracle Linux 8 with the Unbreakable Organization Kernel release 7.

Fascinated developers can check out out Cloud Indigenous Atmosphere working with absolutely free labs and tutorials. Cloud Indigenous Environment and Oracle Verrazzano Container System, for container application administration, can be employed collectively, presenting a suite of open resource software package with a membership-centered help design.

Copyright © 2022 IDG Communications, Inc.… Read more