Ron Ekins' – Oracle Technology, DevOps and Kubernetes Blog
A technical resource for Data Professionals
In this short blog post I am going to share how to upload a large file to Oracle Cloud Infrastructure (OCI) Object Storage using the AWS CLI to perform a concurrent multipart upload. For this post I will use a large 4GB file to demonstrate an upload. Let's start by creating a file called bigfile... Continue Reading →
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 →
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 →
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 →
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 →
Introduction The popularity and adoption of Object Storage continues to grow, with more and more applications and databases using or having an option to utilise Object Storage. I have previously shared a number of posts discussing S3 including: Performing Oracle RMAN backups to S3 to Amazon S3 Object StoragePerforming Oracle RMAN backups to SS to on-premises... Continue Reading →
Background Historically most of the conversations I have regarding Oracle Recovery Manager (RMAN) have been around the use of NFS storage, and Oracle Direct NFS (dNFS). However, more recently with the explosion in the use of Amazon S3 object storage, the topic of RMAN and S3 gets frequently raised. In Part 1 of this series... Continue Reading →
Introduction Last year I wrote a number of posts on Big Data and shared how we can access CSV, Parquet and Avro file formats directly from an on-premises Oracle 19c database using Oracle external files on a local file system or and NFS share from an NFS server e.g. FlashBlade Unfortunately, at that time I... Continue Reading →
Introduction Last year I wrote a number of posts on Big Data and shared how we can access CSV, Parquet and Avro file formats directly from an on-premises Oracle 19c database. In these posts I demonstrated how we can access different file types using SQL external tables on a file system, unfortunately I quickly run... Continue Reading →