Monday, December 11, 2017

MySQL 5.7 reads all your binlog files more often than you think

›
After upgrading some of our slaves to latest 5.7, I have found  what looks like a serious regression introduced in MySQL 5.7. A couple week...
2 comments:
Monday, November 6, 2017

when xtrabackup fails with 'read' returned OS error 0 after upgrading to 5.7

›
Here's something that has puzzled me for several weeks. Right after migrating  MySQL from 5.6 to 5.7, we started experiencing random xt...
Monday, July 3, 2017

SET PASSWORD will lock you out of your slave in a mixed 5.6/5.7 MySQL topology

›
Long time no post.... :-) Here's something interesting. Last week I decided to give MySQL 5.7 a try (yes, I am kinda conservative D...
2 comments:
Tuesday, May 9, 2017

Slides from Percona Live 2017: Caching your application data with MySQL and TokuDB

›
Here are the slides from my talk at Percona Live 2017 conference in Santa Clara, CA. This has been my first opportunity to speak to a publ...
Wednesday, April 5, 2017

Caching your application data with MySQL and TokuDB @ Percona Live 2017

›
The great Percona Live 2017 database conference is approaching, and I am very excited to be there this year - not only as an attendee, but a...
Tuesday, March 7, 2017

Using xtrabackup with MariaDB and multi source replication

›
Quick post today, because I wanted to share a snippet (actually, a patch) that allows the great xtrabackup tool to take backups of MariaDB ...
3 comments:
Thursday, February 23, 2017

When order of appearance of indexes matters in MySQL

›
Sometimes MySQL surprises you in ways you would have never imagined. Would you think that the order in which the indexes appear in a table...
6 comments: