How to verify if a slave running in MySQL 5.7

Introduction Most people know that you can use SHOW SLAVE STATUS to verify if a slave is running in MySQL. Most people ...

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

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

Using gh-ost for online schema changes

The pt-online-schema-change tool has been a workhorse for years, allowing MySQL DBAs to alter tables with minimal ...

Protect against MySQL vulnerability CVE-2016-6662

Overview On September 12, 2016, a security vulnerability affecting all current versions of MySQL and its various ...

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

Oracle service secrets: group and filter

At the KSCOPE16 conference in Chicago I recorded a two minute tech-tip with Bob Rhubart of OTN about adding services to ...

ORA-01156 when adding standy redo log in dataguard configuration

Database version = 11.2.0.3.0 If you get following error while adding a Standby Redo Log (SRL) to a standby database in ...

Truncates and sequences replication in Oracle GoldenGate

We use the terms DDL and DML in our DBA life with Oracle all the time. The first stands for Data Definition Language ...

What's eating my database? Where to focus performance efforts using Oracle AWR

Defining the Gold Standard: Average Active Sessions (AAS) Traditional methods would include looking at CPU, load and ...

ASM 12c : how to rename a Diskgroup

The first time I was asked to rename a diskgroup, I thought that it would be a trivial operation, but what should be an ...

Custom MySQL statistics with collectd

Even though collectd has a MySQL plugin, you may want to collect other statistics, not included with the plugin or even ...

Add space to tablespace - corrective action in OEM 13c

OEM 13c came out with a good new feature as a corrective action to add space to tablespaces. It could be done in OEM ...

Exposing Innodb internals via system variables: Part 2, I/O (structure and logs)

Introduction This is part two of a five part blog series to explore InnoDB internals by looking at the related tunable ...

Exposing Innodb Internals via System Variables: Part 1, MemoryExposing Innodb Internals via System Variables

Introduction A couple of months ago I decided to give myself a refresher on the mechanics of InnoDB. Having a high ...

DECIMAL columns and a non-expected replication error

Auditing MySQL Users With McAfee Plugin

It is a common auditing requirement to log user connection events, including whether or not authentication was ...

Enabling achivelog mode in 12c RAC database

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

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

How to Install a brand new Exadata X5 (part 2)

Now that all the prerequisites have been performed in Part 1, we can now jump in the Exadata installation procedure ...

Exposing Innodb Internals via system variables: part 4, concurrency

Introduction This is part four of a five part blog series to explore InnoDB internals by looking at the related tunable ...

Exposing Innodb internals via system variables: part 3, I/O (table data)

Introduction This is part three of a five part blog series to explore InnoDB internals by looking at the related ...

Cassandra 3.9 Security feature walk-through

As an enterprise level NoSQL database software, Apache Cassandra provides many out-of-the-box security features that ...

How to install a brand new Exadata X5 (Part 1)

When you buy an Exadata machine, you can ask Oracle to proceed with the installation or let some brilliant DBAs like ...

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