I recently published a blog on restricting Linux block storage IO sizes using Kernel settings, but what if you don't have root access, or want a more dynamic approach for your Oracle Database. In this blog post I am going to explore the use of multiblock read count (MBRC) on an Oracle 19c Database. Oracle... Continue Reading →
How to reduce Linux Block Storage IO sizes
A colleague recently asked me an interesting question, How can I reduce the size of a physical IO on Linux? So here's a blog that hopefully answers that question. Linux Operating System For this blog I will be using a Linux server with a Kernel that has a default maximum size of 1280KB (if you... Continue Reading →
How to dump MySQL data to S3 Compatible Object Storage using the MySQL Shell
In Part 1 of this blog series I shared how to create a Pure Storage FlashBlade S3 compliant Object Storage account, user and bucket. I also demonstrated how to download the MySQL airportdb database, and upload objects into the Object Store S3 bucket. In Part 2, I showed how we can use the MySQL Shell... Continue Reading →
Learn how you can use the MySQL Shell to load data from S3 compliant Object Storage – Part 2 (Load)
In Part 1 of this blog series I shared how to setup a Pure Storage FlashBlade S3 compliant Object Storage account, user and bucket. I also demonstrated how to download the MySQL airportdb database, and upload objects into the Object Store S3 bucket. In this blog post I will show how we can use the... Continue Reading →
How to utilize S3 Object Storage for common MySQL 8 database DBA activities – Part 1 (Setup)
In this blog post series I and going to share how a MySQL 8 DBA can utilise S3 Object Storage for common database admin activities. If you don't already have an up and running MySQL 8 database and want to follow this blog, you could check out my post How to Install MySQL 8 on... Continue Reading →
Oracle Database 23c Free Developer Release on OKE with Portworx Essentials – Part 3
In this blog series I set out to share how to deploy the Oracle Database 23c Free Developer Release on an Oracle Cloud Infrastructure (OCI) Oracle Container Engine for Kubernetes (OKE) Cluster with Portworx storage. In Part 1 of this series I shared how to create an OKE Kubernetes Cluster. In part 2 I shared how to install and configure Portworx... Continue Reading →
How to Clone and run an Oracle Database in a Docker Container
During a recent conversation, I was asked How can I clone my Production Oracle 19c database, and run the database clone in a Docker container ? Great question, I hear you asking. Well, I have been talking about Docker, Kubernetes and Containerisation for many years but when I checked I had no video demonstrating how... Continue Reading →
Portworx Cloud Drive Support for Oracle Container Engine for Kubernetes (OKE)
Portworx 2.13 brings support for Cloud Drives to Oracle Container Engine for Kubernetes (OKE), Cloud Drives provide the ability to automatically provision storage, this is great news for anyone using Portworx on OKE as it means you no longer need to pre-allocate block storage. I have previously shared how to install Portworx on the Oracle... Continue Reading →
How to backup Oracle Container Engine for Kubernetes (OKE) Applications with Portworx PX-Backup – Part 1
In this blog post I am going to share how to install and configure Portworx PX-Backup to perform a backup of an application using the Oracle Container Engine for Kubernetes (OKE) managed Kubernetes service running on Oracle Cloud Infrastructure (OCI). Kubernetes Cluster For this post I have built a 3 node Kubernetes v1.25.4 cluster in... Continue Reading →
How to connect to a PDS PostgreSQL database running on OKE
In this blog I and going to show how to connect to a PostgreSQL database created by Portworx Data Services (PDS) deployed on Oracle Cloud Infrastructure (OCI) Oracle Container Engine for Kubernetes (OKE). I previously shared How to deploy a PostgreSQL database on the Oracle Cloud using OKE and Portworx Data Services (PDS) so if... Continue Reading →
