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 →
Manage Infrastructure with REST APIs from within the Oracle Database using UTL_HTTP
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 →
Accessing on-premises S3 Object Storage from Oracle 19c or 21c databases with DBMS_CLOUD
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 →
Working with Oracle 19c database and on-premises S3 Object Storage with DBMS_CLOUD
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 →
How to get started automating Pure Storage FlashArray and FlashBlade tasks with Ansible
Introduction If you have been following my blog for a few years you may have already read some of my blogs on Ansible, or used seen some demos or even pulled some Ansible code from my GitHub repo I was recently asked How can I learn more about Ansible, and the how can I start... Continue Reading →
How to Replicate FlashBlade S3 Objects to Oracle Cloud Infrastructure (OCI) Object Storage
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 →
How to configure Oracle 19c database and DirectNFS with NFSv4.1
How to configure Oracle 19c database and DirectNFS with NFSv4.1 using a Pure Storage FlashBlade
Performing Oracle Database Recovery Manager (RMAN) backups to On-Premises FlashBlade S3 Object Storage
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 →