Monitor Cassandra using Zabbix

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

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

Understanding MySQL isolation levels: repeatable-read

Isolation levels are a rare subject in MySQL literature. The documentation provides a terse description and focuses ...

MySQL crashes on DDL statement: a lesson on purge threads

Restructuring your database environments can be a high-stakes operation. Recently, I’ve encountered several reports of ...

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

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

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

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

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

Using the MariaDB CONNECT engine to merge heterogeneous data sources

Background

Change of database passwords through OEM

Changing passwords for system database accounts is a necessary but often tedious routine. However, with Oracle ...

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

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

Exporting custom metrics to influxdb

In the TICK stack (Telegraf, InfluxDB, Chronograf, Kapacitor) from InfluxData, Telegraf serves as the crucial "T"—the ...

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

Backup and data streaming with xbstream, tar, socat, and netcat

Comparing Xtrabackup Streaming Methods: XBSTREAM vs. TAR On April 4th 2012 Xtrabackup 2.0 was released in to GA by ...

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

Duplicate indexes in MySQL

Why do we sometimes want to keep duplicate indexes? I’ve done dutiful DBA work in the past to identify and remove what ...

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