Monitoring your 5.7 InnoDB cluster status

Recently, we worked with a customer seeking assistance in monitoring their MySQL 5.7 InnoDB cluster. Following a ...

MySQL high availability with HAProxy, Consul and Orchestrator

Introduction In this post we will explore one approach to MySQL high availability with HAProxy, Consul and ...

How to a recreate disk group used by CRS

I will go through detailed steps here on how to recreate a disk group used by CRS. Some things to bear in mind: - I ...

An Oracle "oraenv" script solution for Windows with PowerShell

The idea Due to the nature of my consulting work, I mostly work in Linux environments and use bash for scripting. But ...

Configuring software loadbalancer for Oracle E-Business Suite

HAProxy (high availability proxy) is a free, open source software that provides TCP & HTTP-based load balancing ...

Backup strategies in Cassandra

How to delete an RAC Database Using DBCA silent mode

During a recent Proof of Concept (POC) involving the migration of a RAC non-CDB to a CDB, I ran into a few snags that ...

Exposing MyRocks internals via system variables: Part 5, Data Reads

(In the previous post, Part 4, we covered Compression and Bloom Filters) In this blog post, we continue on our series ...

How To Reclaim ASM Disks

The project I have been working on is migrating GoldenGate trails from DBFS and ACFS. Now that the migration has ...

Custom fix required when using latest JDK with Oracle E-Business Suite R12.1.3

Update 11-JUN-2021: Doc ID 2353710.1 has been updated. It is recommended now to apply two patches: 10.1.3 Home Patch ...

How to efficiently back up and restore crontab

When a database environment is being patched, entries from crontab are commented and then removed when patching is ...

How to extend the /u01 filesystem on an Exadata

Marketers are very good at selling everyone on the fact that resources (CPU, disks, memory) are now infinite, which is ...

How to Prevent Linux 7 Housekeeping from Breaking Oracle

Linux 7 introduced multiple changes and enhancements to the kernel. Among them was automated housekeeping for temporary ...

Google Cloud Platform quick tip: Cloud Shell boost mode for Docker development

I explained in an earlier post how I am using GCP's Cloud Shell for all of my command-line needs all the time. Whenever ...

How to mine an RMAN Log

I recently performed a Proof of Concept (POC) to compare and contrast Oracle Recovery Manager (RMAN) backup performance ...

BTRFS performance compared to LVM+EXT4 with regards to database workloads

Introduction In many database builds, backups pose a very large problem. Most backup systems require an exclusive table ...

Choosing best index for your MongoDB query

Introduction Indexing plays a quintessential role in database query performance and MongoDB is no exception. Choosing ...

Azure Cloud Shell - cloud what?

What is Azure's Cloud Shell? Azure Cloud Shell is a browser-based, interactive shell that comes in two flavors: ...

Creating dynamic tasks using Apache Airflow

What's Airflow? Apache Airflow is an open source scheduler built on Python. It uses a topological sorting mechanism, ...

How to immediately kill ALL processes for a Unix user

Context On occasion I have found it necessary to immediately kill all processes for a particular user on a Linux or ...

GCP features wish list for Google Next 2018

As I've just posted about Pythian at Google Next, I thought it would be cool to share the new GCP features I'd love to ...

Deploying a private Geth network using Docker

So you’ve started developing an Ethereum project and TestRPC has worked wonderfully. Now you're ready to set up a CI/CD ...