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 ...

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 ...

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 ...

Properly removing users in MySQL

Context

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

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

1. Introduction

Analyze index validate structure - the dark side

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

Encrypting sensitive data in puppet using hiera-eyaml

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

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 ...

How to deal with MetaData Lock

What is MetaData Lock?

MySQL uses metadata ...

GoldenGate 12.2 big data adapters: part 4 - HBASE

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