Getting Started with MySQL Shell , The Oracle MySQL Kubernetes Operator and Portworx

Overview

In this blog I will show you how to use the MySQL Shell to manage and create a clustered database on an InnoDB MySQL cluster which has been provisioned using the Oracle MySQL Kubernetes Operator, and Portworx to provide the data management layer and persistent volumes

The benefit of using Portworx is we can create custom storage classes defining storage attributes such as replication factors, snapshot policies, dynamic PVC creation for stateful applications and intelligent pod placement.

This blog will not go into the details on how to setup Kubernetes, Portworx or the Operator, my Colleague Ron Ekins has written an excellent blog on the installation process.

https://ronekins.com/2021/08/31/getting-started-with-the-oracle-mysql-kubernetes-operator-and-portworx/

Environment

* Kubernetes 1.21
* Portworx 2.8
* MySQL operator installed https://github.com/mysql/mysql-operator
* MySQL Shell

Let's check to make sure our operator is up and running

Screen Shot 2021-10-13 at 12 39 57 pm

Let's check to make sure our InnoDB Cluster is up and running

Screen Shot 2021-10-13 at 12 40 42 pm

Let's check to make sure our InnoDB Cluster PODS are up and running

Screen Shot 2021-10-13 at 11 50 59 am

Install MySQL Shell

Installation of the MySQL Shell is very straight forward

  • yum install mysql-shell

Screen Shot 2021-10-13 at 12 41 28 pm

Note: because I don't have a load balancer on my kubernetes environment, I will be using kubernetes port forwarding to connect to the MySQL PODS from the K8 Master node connecting to port 6446

Screen Shot 2021-10-13 at 12 45 17 pm

Lets get the IP addresses of the cluster PODS we want to connect to.

root@px-centk8s01 ~]# kubectl get pods -o wide
10.244.1.44 | 10.244.1.45 | 10.244.1.46

Screen Shot 2021-10-13 at 12 53 05 pm

Connecting to the localhost using mysqlsh "mysqlsh chrisb@localhost:6446 --sql" I have already created a user called "chris" as an admin user on the cluster nodes In this example I am connecting to the mysql cluster pod running on port 6446 as the user chris, notice the SQL prompt - mysqlsh allows you to connect in SQL mode or JS ( java script ) mode

Screen Shot 2021-10-13 at 12 47 30 pm

Lets change to JS mode ( SQL> \js ) and check the cluster status, we can see the three cluster nodes with mycluster-0 as the primary node

Screen Shot 2021-10-13 at 2 00 42 pm

Now let's change back to SQL mode in mysqlsh.

Screen Shot 2021-10-13 at 4 13 18 pm

From the SQL prompt we can run any SQL command which you can run from a standard mysql database connection, let's have a look at what databases are configured.

Screen Shot 2021-10-13 at 3 54 18 pm

Let's check which which cluster node we are on, then we will create a new database called blog and confirm all the cluster nodes can see and read the database. We are on the mycluster-0

Screen Shot 2021-10-13 at 4 19 14 pm

The new blog database is now visible.

Screen Shot 2021-10-13 at 4 20 21 pm

Lets now connect to cluster node mycluster-1 "10.244.1.45" and confirm we can see the new blog database, I will switch back to JS mode and connect to each cluster node

Screen Shot 2021-10-13 at 4 22 04 pm

We will do the same thing with cluster node mycluster-2

Screen Shot 2021-10-13 at 4 23 12 pm

Now because cluster nodes 1 and 2 are read-only nodes we cannot create a database or add data to a table as we can see from attempting to create a new database called blog2 on mycluster-2

Screen Shot 2021-10-13 at 4 24 04 pm


Summary


In this blog we have seen how we can install MySQl Shell to manage a MySQL cluster installed using the Oracle MySQL Kubernetes Operator, while the storage is being managed by Portworx.


To learn how to install the MySQL kubernetes Operator visit:


https://ronekins.com/2021/08/31/getting-started-with-the-oracle-mysql-kubernetes-operator-and-portworx/


Comments

Post a Comment

Popular posts from this blog

SQL Server container with Pure Storage Docker volumes

Image
SQL Server on Docker with Pure Storage Persistent Volumes Docker and containers have become an integral part of virtualisation. Having the ability to spin up containers has almost instantly transformed the way we build, develop and manage applications. Many of us have been using some sort of virtualisation for decades as this is not a new concept. Due to their speed, simplicity and automation, container usage has garnered substantial popularity and are becoming ubiquitous in the field of virtualisations. So why use containers ? Decouple application runtime from infrastructure. Runs instantly. Process and user isolation for application multi-tenancy. Key building blocks for microservices. But what happens when you delete the container ? The main issue in deleting a container is that you delete the writeable layer and any data that was there, hence no data persistence. Docker volumes provide us a way to decouple your application from its state, to the point where you c...
Read more

Oracle Containers on Kubernetes and Pure Service Orchestrator

Image
Pure Service Orchestrator allows for smart provisioning of storage to one or many arrays, this provides administrators and developers the ability to  provision storage on demand with cloud like functionality, ease and flexibility. In this blog I will use Pure Service Orchestrator ( PSO ) to automate the provisioning of volumes to Kubernetes which will then be used to create Oracle containers using persistent storage.   My next blog will demonstrate the  power of using  Pure Storage snapshots and cloning to rapidly create instant copies of the source Oracle database. Environment NOTE:  In this blog I will not be going through the Kubernetes cluster install Role FQDN IP OS RAM CPU K8 Ver Master master.localdomain.com 192.168.111.231 Ubuntu 18.04 5G 3 1.18 Worker1 worker1.localdomain.com 192.168.111.232 Ubuntu 18.04 8G 4 1.18 # kubectl get nodes -o wide NAME STATUS ROLES AGE VERSION INTERNAL-IP EXTERNAL-IP OS-IMAGE KERNEL-VER...
Read more

Oracle 19c Database clones using the Pure Storage Docker plugin

Image
  Docker and containers have become a integral part of virtualization, being able to spin up containers almost instantly have transformed the way be build, develop and manage applications. In this blog I will show you how we can rapidly create Oracle 19c container clones using the Pure Storage Docker plugin with persistent volumes and the new Oracle 19c container image on the Oracle Container Registry https://container-registry.oracle.com/pls/apex/f?p=113:4:2886566670416#     Installing the Pure Plugin ( Latest version is 3.10 ) 12:24:30 root@docker ~ # docker plugin install purestorage/docker-plugin:v3.10 --alias pure --grant-all-permissions Enter the Array Configuration in the /etc/pure-docker-plugin/pure.json file  {      "FlashArrays":[          {              "MgmtEndPoint":“192.168.111.130",              "APIToken":" 476d58bc-3c91-0d10-1b9e-0f31058c462...
Read more