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 →
How to Install MySQL 8 on Oracle Linux 8
In this post I am going to share how to install the MySQL 8 Community Edition on Oracle Linux 8. Before you download the RPM, confirm which version of Linux you are using, by checking /etc/redhat-release or /etc/oracle-release, for example. # cat /etc/redhat-release; cat /etc/oracle-release Red Hat Enterprise Linux release 8.8 (Ootpa) Oracle Linux Server... Continue Reading →
How to check your disk sector size
I was recently asked 'How can I check to see if my storage supports 4K sector sizes, and if my Oracle 19c database is using it' ? In this post I will share how to check disk sector sizes from Linux, from Oracle Automatic Storage Management (ASM) and via the Oracle kfed utility. Traditional disk... Continue Reading →
Oracle 19c RAC database online migration to ActiveCluster for extended / stretched RAC clusters
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 →
Fully automated Vagrant build for Oracle APEX using Oracle18xe, ORDS and Apache Tomcat
Fully automated Oracle #APEX build using #Oracle18xe, #ORDS and Apache Tomcat @ansible @virtualbox @oracleace
On-line migration of Oracle 18c/19c filesystem datafiles to Oracle ASM
Background Prior to Oracle 12c moving non-ASM data files required taking data files ‘offline’ and negotiating an outage with the business, since Oracle 12c this is has no longer been the case. I was recently challenged with moving a good size filesystem 19c Oracle database from an existing storage platform to a new storage array. Prepare ASM... Continue Reading →
Creating new Oracle 18c ASM Disk Groups
Creating New Volumes Create the new ASM volume(s) using your storage platform, for this blog I have created 3 volumes on a Pure FlashArray, simply providing names and sizes. Note the Volume serial numbers, these will be used in the multipath configuration wwid (World Wide Identifier) SCSI storage device serial numbers are universally unique. Each... Continue Reading →
Adding new devices (VMware) to Linux without re-booting server
Background Today, I found myself needing to add 3 new disks to one of my Oracle database server VMware VM's, unfortunately I was unable to re-boot the server so I followed the steps below to add the new devices. Create LUN's using your storage platform and add add them to your Virtual Machine using... Continue Reading →