Custom MySQL statistics with collectd

Gabriel Ciciliani, MySQL Lead Database Consultant at Pythian, explains how to generate custom MySQL statistics using collectd.

Read More >

How to verify if a slave running in MySQL 5.7

Derek Downey, OSDB Practice Advocate at Pythian, explains how to verify that a Slave is running in MySQL 5.7.

Read More >

Creating an external slave for a live AWS Aurora Instance

Kevin Markwardt, MySQL Database Consultant at Pythian, explains how to set up an external slave for a live Amazon AWS Aurora instance.

Read More >

DECIMAL columns and a non-expected replication error

Gabriel Ciciliani, MySQL Lead Database Consultant at Pythian, provides a guideline to analyzing a replication issues involving decimal columns and RBR, and how to deal with the problem without reseeding the slave.

Read More >

Quick random data in MySQL

Valerie Parham Thompson, Lead Database Consultant at Pythian, provides some sql statements to get some quick random data in MySQL.

Read More >

The rlwrap utility for DBA.

Recently I received a request from one of our clients asking the way to mysqldump data only from a view. The request sounds reasonable at the first glance, but after thinking it a little bit further, we will find out…

Read More >

Your Xtrabackup cheat sheet

Ivan Groenewold, MySQL Database Consultant at Pythian, provides examples of useful operations using xtrabackup.

Read More >

Why is the slave IO thread in connecting status?

Gabriel Ciciliani, MySQL Lead Database Consultant at Pythian explains what to do if your 5.6 MySQL slave IO thread is not able to connect to the master after discarding connectivity issues or parameters typos.

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 >

Uncovering the ib_logfiles mtime Mystery

Insight from Ivan Groenewold, MySQL Database Consultant at Pythian, on the ib_logfiles mtime mystery.

Read More >
Page 10 of 26« First Page...89101112...20...Last Page »