Reserved words usage in MySQL

It is not uncommon to come across MySQL databases where reserved words are in use as identifiers for any kind of ...

Monitoring apache Cassandra metrics with Graphite and Grafana

1. Overview Despite the fact that Apache Cassandra provides a large number of metrics through the popular Metrics ...

MySQL InnoDB’s full text search overview

NOTE: If you want to read and play with the interactive application, it has been developed using Shiny/R in order to ...

Oracle E-business suite: virtual host names solution for R12.2

You have seen me rant about Oracle's provided virtual hostname solution before. If you have not, check it out here. In ...

Your Xtrabackup cheat sheet

My goal in this post is to present you with examples of useful operations using xtrabackup, using options which in some ...

SharePlex replication between two instances on the same host

Several days ago I was asked a question about SharePlex and should verify behaviour before providing the answer. I had ...

Oracle Database 12c: PSUs vs database proactive bundle patches

Background When it comes to performing quarterly patches to the Oracle database the options used to be pretty straight ...

Things to consider when deciding on a primary key for your INNODB table

When it comes to schema design, one of the more common issues I see for INNODB tables is in the selection of a primary ...

Properly removing users in MySQL

Context Removing users in MySQL is an easy task, but there are some drawbacks to check carefully before dropping a ...

An effective approach to migrate dynamic thrift data to CQL, part 1

1. Introduction Recently Pythian's Cassandra team worked on one customer's request to copy data of several Cassandra ...

Analyze index validate structure - the dark side

Recently, a co-worker encountered a significant performance hurdle after a database upgrade. The plan included ...

Improve parsing and query performance - fix Oracle's fixed object statistics

What do I mean by 'fix' the the fixed object statistics? Simply gather statistics to help the optimizer. What are ...

Encrypting sensitive data in puppet using hiera-eyaml

Puppet manifests can hold a lot of sensitive information. Sensitive information like passwords or certificates are used ...

DECIMAL columns and a non-expected replication error

InnoDB flushing and Linux I/O

Since documentation is not very clear to me on the topic of InnoDB flushing in combination with Linux IO (specifically ...

ASM disk group just will not mount

I recently had an issue involving a damaged ASM disk group. Each time an attempt was made to mount the disk group it ...

ASMCMD> a better DU, version 2

Benefits of ASMDU A while ago, I posted a better "du" for asmcmd . Since then, Oracle 12cR2 beta has been released but ...

How to deal with MetaData Lock

What is MetaData Lock? MySQL uses metadata locking to manage concurrent access to database objects, and to ensure data ...

Creating an external slave for a live AWS Aurora Instance

Overview When working with Amazon AWS Aurora, there are some steps to consider when trying to get data out of an active ...

The getMOSPatch V2 is here!

A while ago I created a Bash script called getMOSPatch.sh. Its purpose was to allow downloading Oracle patches directly ...

GoldenGate 12.2 big data adapters: part 4 - HBASE

This is the next post in my series about Oracle GoldenGate Big Data adapters.

Eight ways to ensure your applications are enterprise-ready

When it comes to building database applications and solutions, developers, DBAs, engineers and architects have a lot of ...

How to recover space from already deleted files

Wait, what? Deleted files are gone, right? Well, not so if they’re currently in use, with an open file handle by an ...