Tag: Pure Storage

How to deploy a PostgreSQL database on the Oracle Cloud using OKE and Portworx Data Services (PDS)

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 →

1

Protect Kubernetes Portworx volumes with CloudSnap to OCI S3 Object Storage

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 →

0

How to deploy an on-premises 21c database using the Oracle Database Operator for Kubernetes

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 →

0

Use PL/SQL to perform Storage Snapshots from within the Oracle Database using UTL_HTTP

Oracle Database 19c

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 →

0

Manage Infrastructure with REST APIs from within the Oracle Database using UTL_HTTP

Oracle Database 19c

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 →

1

Accessing on-premises S3 Object Storage from Oracle 19c or 21c databases with DBMS_CLOUD

Oracle Database 19c

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 →

0

Working with Oracle 19c database and on-premises S3 Object Storage with DBMS_CLOUD

Oracle Database 19c

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 →

2

How to change an Oracle ASM Diskgroups section size

Oracle Database 19c

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 →

0

Oracle 19c RAC database online migration to ActiveCluster for extended / stretched RAC clusters

Oracle Database 19c

In this post I will share how to perform an online move of an Oracle 19c RAC database to a Pure Storage ActiveCluster Pod to provide Active-Active synchronous replicated storage for an extended / stretched Oracle RAC cluster. Step 1 - ActiveCluster Pod The first step is to create a Pod, in the example below... Continue Reading →

0

Portworx Data Services (PDS) and PostgreSQL

PostgreSQL + Portworx

Introduction In this blog post I will introduce Portworx Data Services (PDS) and demonstrate how it an be used to also deliver PostgreSQL databases. I have previously shared how we can use the EDB Kubernetes Database Operator to deliver a PostgreSQL database, and also the YugabyteDB Kubernetes Database Operator to deliver a PostgreSQL compatible Yugabyte... Continue Reading →

1

Create a website or blog at WordPress.com

Up ↑