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 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 →
How to use Ansible to map a Linux device to a vVOL FlashArray Volume
Background In my previous post I walked through how you can determine a vVOL FlashArray volume from a Linux device. In this post I will show how we can automate that process with Ansible using the same /dev/sdd Linux device and some code examples. Ansible Linux Facts Let's start by using the ansible_facts.devices to identify... Continue Reading →
How to map a Linux device to a vVOL FlashArray Volume
Background I have recently seen an increase in the adoption of VMware Virtual Volumes (vVOLS), and a question which is frequently asked is: How I can identify the FlashArray volume from my Linux server ? Identify Linux Device In this example my Oracle database is using a Pure Storage FlashArray and has been migrated to... Continue Reading →
NFS storage IO performance testing with ORION (ORacle IO Numbers)
Background In my previous ORION Blog post I described how to prepare a Pure Storage FlashArray block volumes for use with Oracle ORION (ORacle IO Numbers), in this is Blog I am going to show how this can also be done with NFS. Getting Started - Storage Preparation For the purposes of this Blog I have... Continue Reading →
Oracle VM 3.4.6: Importing Templates
If you have followed my previous Oracle VM Blog posts you should have by now a working OVM deployment using either Block, NFS or both. I am now going to provide a walkthrough on how to import an Oracle VM Template. First start by visiting Oracle Technology Network and navigating to the Oracle VM Overview... Continue Reading →
Getting started with ZFS on OEL7
In this short Blog I will show how you can create a new ZFS pool, file system and also show some other ZFS command on OEL7. ZFS installation on OEL7 # yum install -y yum-utils# yum-config-manager --enable ol7_developer_EPEL# yum install -y dkms# rpm -Uvh http://download.zfsonlinux.org/epel/zfs-release.el7_6.noarch.rpm# sudo yum install -y zfs# /sbin/modprobe zfs# systemctl -a |... Continue Reading →
Oracle VM 3.4.6 : Part 3 – OVM Networks
Configuring OVM Networks Before we can present our iSCSI and NFS storage to our Oracle VM Server we need to configure a network. Oracle VM Manager provides a simple to use interface which can maintain the /etc/sysconfig/networking-scripts without the need of manual editing. In my lab I have a number of VLAN's configure on an... 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 →