Monitor Cassandra using Zabbix

Zabbix is an open-source based enterprise level monitoring solution that aims for monitoring distributed network ...

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

A Step-by-Step Flashback of RAC database to Restore Point

The following is the step-by-step process of Flashback of RAC database to a Restore Point. 1) Set the environment to ...

How to store performance counters directly on SQL server using TypePerf Command

Introduction Every DBA should know that the baseline is one of the most important pieces to make a proactive ...

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

MySQL on AWS: RDS vs EC2

When moving your MySQL instances to AWS, you would probably have to deal with this decision. This article will ...

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

Using the MariaDB CONNECT engine to merge heterogeneous data sources

Background

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

AWS DMS tips for Oracle migrations

Investigating IO performance on Amazon EC2

I published a blog post called " Investigating IO Performance on Amazon RDS for Oracle" recently, and soon after ...

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

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

Distinguish real SQL execution plans from fake ones!

As an Oracle DBA, one of our daily tasks is to optimize bad SQL statements that are affecting the system and causing ...

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

Investigating IO performance on Amazon RDS for Oracle

I've recently been involved in quite a few database migrations to Oracle RDS. One thing that I had noticed when dealing ...

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