A technical resource for Data Professionals
In this blog post I will share how to configure an Oracle Linux 8.9 server and Podman to work with Docker Compose. Docker Compose is a command-line tool used for defining and the running single, or multi-container applications. Docker Compose simplifies the management of the entire application stack, making it easy to manage services, networks,... Continue Reading →
Background As many of you may already know, I have been a long time supporter of running Oracle on NFS, having deployed many Oracle E-Business suite, single instance and RAC databases on NFS over years. However, for many Oracle DBAs NFS (Network File Systems) is still something of an unknown entity, in this post I... Continue Reading →
I recently published a blog on restricting Linux block storage IO sizes using Kernel settings, but what if you don't have root access, or want a more dynamic approach for your Oracle Database. In this blog post I am going to explore the use of multiblock read count (MBRC) on an Oracle 19c Database. Oracle... Continue Reading →
A colleague recently asked me an interesting question, How can I reduce the size of a physical IO on Linux? So here's a blog that hopefully answers that question. Linux Operating System For this blog I will be using a Linux server with a Kernel that has a default maximum size of 1280KB (if you... Continue Reading →
I have previously shared how to run the Oracle Database 23c FREE database on an X86 Mac using PodMan, you can find that blog post here. But what about the newer M1/M2 Macs I here you ask ? Well, I have just got myself and new 2023 MacBook Pro with the Apple M2 Pro ARM... Continue Reading →
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 →
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 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 →