Author: Peter Sylvester

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

On April 4th 2012 Xtrabackup 2.0 was released in to GA by Percona along with a new streaming feature called xbstream. This new tool allowed for compression and parallelism of streaming backups when running xtrabackup or innobackupex without having to…

Read More >

The State of MySQL High Availability Going in to 2018

High availability for MySQL has become increasingly relevant given the ever increasing rate of adoption and implementation. It’s no secret to anyone in the community that the popularity of MySQL has become noteworthy. I still remember my start with MySQL…

Read More >

MySQL Crashes on DDL statement: A Lesson on purge threads

Recently there have been several issues reported to me about DDL activity causing MySQL crash scenarios. In one case it stemmed from dropping multiple databases, one after the other in rapid succession. But in the case that I was recently…

Read More >

Exposing Innodb Internals via System Variables: Part 5, Consistency / Statistics handling

In part 5 of this series, Peter Sylvester, Lead Database Consultant at Pythian, looks at variables that relate to enforcing data consistency, and how index statistics are handled and stored.

Read More >

Exposing Innodb Internals via System Variables: Part 4, Concurrency

In part 4 of this series, Peter Sylvester, Lead Database Consultant at Pythian, looks at the mechanics that impact CPU resourcing and how InnoDB handles concurrent threads.

Read More >

Exposing Innodb Internals via System Variables: Part 3, I/O (Table data)

In part 3 of this series, Peter Sylvester, Lead Database Consultant at Pythian, continues looking at I/O, specifically the mechanics on how data gets written to table files.

Read More >

Exposing Innodb Internals via System Variables: Part 2, I/O (structure and logs)

In part 2 of this series, Peter Sylvester, Lead Database Consultant at Pythian, takes a closer look at I/O structure and log related variables.

Read More >

Exposing Innodb Internals via System Variables: Part 1, Memory

Introduction A couple of months ago I decided to give myself a refresher on the mechanics of InnoDB. Having a high level understanding of what’s going on under the hood can help provide the context needed in order to resolve…

Read More >

Things To Consider When Deciding On A Primary Key For Your INNODB Table

Peter Sylvester, Lead Database Consultant at Pythian, explains why you should consider explicitly defining a primary key, and how it should be formed.

Read More >

Creating a Test Lab Using VirtualBox / NAT networking

My job is almost completely reliant upon my ability to perform work in lab of virtual machines. Almost every action plan I write is tested locally. When I need to troubleshoot an issue for a client one of the most…

Read More >