A technical resource for Data Professionals
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 →
With the recent growth in popularity of PostgreSQL, you may have noticed that many of the major Cloud vendors have developed and now offer managed PostgreSQL Database-as-Service (DBaaS) solutions, for example: Azure Database for PostgreSQL Amazon RDS for PostgreSQL Amazon Aurora Google Cloud SQL PostgreSQL Google AlloyDB for PostgreSQL IBM Cloud Database for PostgreSQL Additional,... Continue Reading →
Kubernetes labels provide an important role in the management of large complex Kubernetes clusters. Kubernetes implements labels as key value pairs which are attached to objects, such as nodes and pods to store identifying and meaningful attributes, which can then be used to manage the running Kubernetes platform. For the purpose of the post I... Continue Reading →
In this post I will share how we can use Portworx CloudSnap to backup a Kubernetes Portworx volume to an Oracle Cloud Infrastructure (OCI) Object Storage S3 Bucket. OCI Object Storage Let's start by logging into an Oracle Cloud Infrastructure (OCI) account, and from the Dashboard selecting Object Storage or via the hamburger menu navigate to Storage -> Object Storage -> Buckets.... Continue Reading →
Background The Oracle Database Operator for Kubernetes (OraOpeator) provides a simple, supported method of provisioning, cloning, and patching Oracle Databases including databases deployed on Kubernetes. I have previously posted a blog on how to use the OraOperator (v0.1.0) to deliver an Oracle database on the Oracle Cloud Infrastructure (OCI) Oracle Container Engine for Kubernetes (OKE)... Continue Reading →
In this blog post I will share how the Oracle UTL_HTTP package can been used to enable full stack automation by calling external application and infrastructure REST APIs from within an Oracle 19c or 21c database. I have previously shared how to perform File System snapshots on a Pure Storage FlashBlade using the UTL_HTTP package, in this... Continue Reading →
In this blog post I will share how the Oracle UTL_HTTP package can been used to enable full stack automation by calling external application and infrastructure REST APIs from within an Oracle 19c or 21c database. For the purpose of this post I will be using an Oracle 21c database and a Pure Storage FlashBlade... Continue Reading →
In this post I will share to how to create an external table using the DBMS_CLOUD package and then run a query against a csv file uploaded into a Pure Storage FlashBlade S3 Object Storage bucket. I have previously shared how to install and configure the Oracle DBMS_CLOUD package, if you want to follow this... Continue Reading →
The DBMS_CLOUD package has been available for on-premises 19c database for over a year now, and since the initial 19.9 release several fixes have been shipped, so I suggest you consider using the latest patch if possible, to avoid any known issues. I have previously shared how to configure an Oracle 19c database to use DBMS_CLOUD... Continue Reading →
Traditional disk based storage systems use a sector size of 512 bytes, some all-flash-arrays use 4K sectors sizes, but it's not something we generally consider, do you know what you are using ? If you're not sure you may want to check-out now of my recent posts on how to check disk sector sizes from... Continue Reading →