Monthly Archives: March 2011

OurSQL Episode 39: TokuDB 5.0 part 1

Posted on March 25, 2011 by podcast

TokuDB is a transactional, fully ACID-compliant storage engine that uses fractal trees for data and indexes, instead of MySQL’s standard B-tree implementation. Combined with TokuDB’s message-based architecture, TokuDB data and indexes do not fragment,… Continue reading →

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 39: TokuDB 5.0 part 1

OurSQL Episode 38: Xtrabackup (Backup Series #5)

Posted on March 18, 2011 by podcast

Previous podcasts in the backup series:
Backup Series #1: Backup Glossary
Backup Series #2: Backup Tools You Already Have (mysqlhotcopy and mysqldump)
Backup Series #3: Looking Through the Lenz (snapshots including LVM)
Backup Series #4: Advanced Logic… Continue reading →

Posted in backup, Podcasts | Comments Off on OurSQL Episode 38: Xtrabackup (Backup Series #5)

OurSQL Episode 37: It’s Still Not Our (De)fault! Part 2

Posted on March 11, 2011 by podcast

This week, Giuseppe Maxia joins us as a special guest and we complete our 2-part series on what we always put in our configuration files, and why.
Part 1 in the series.
strings man page
MySQL manual page about defaults-group-suffix
Giuseppe’s article a… Continue reading →

Posted in Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 37: It’s Still Not Our (De)fault! Part 2

OurSQL Episode 36: It’s Not Our (De)fault! Part 1

Posted on March 4, 2011 by podcast

Nick Pisarro, aka @highenergybeams, suggested we do a podcast about the MySQL defaults we recommend always having, as MySQL’s pre-configured option files are not particularly helpful. So we have put together a 2-part podcast on the options that we cha… Continue reading →

Posted in Podcasts, Server Tuning | Comments Off on OurSQL Episode 36: It’s Not Our (De)fault! Part 1