General

OurSQL Episode 169: Having Fun


17:30 minutes (8.17 MB)

This week we present bloopers from the year 2013. We hope you enjoy this non-tech funny show, featuring mistakes and outtakes from us and the folks we have interviewed. Don't miss Tim Callaghan singing our theme song!

OurSQL Episode 168: Autofailover, part 1


24:32 minutes (11.39 MB)

This week we discuss setting up Percona Replication Manager. Ear Candy is playing with Unicode to make seasonal pictures and At the Movies is about systems performance with lots of MySQL examples.

Events
DB Hangops - every other Wednesay at noon Pacific time

FOSDEM 2014 - Sat February 1 - Sun February 2 in Brussels, Belgium.
Upcoming MySQL events

The call for papers for OSCon 2014 is open until Thursday, January 30th

OurSQL Episode 151: Tooling Around, Part 1


23:54 minutes (11.1 MB)

This week we start talking about the Python MySQL Utilities. Ear Candy is a pitfall when importing a mysqldump export and At the Movies is "Deploying MySQL in AWS and OpenStack" by Mark Riddoch of SkySQL.

Part 2 of MySQL Utilities
Part 3 of MySQL Utilities
Part 4 of MySQL Utilities
Part 5 of MySQL Utilities

MySQL Utilities
MySQL Utilities documentation

OurSQL Episode 149: Trolling


34:54 minutes (16.13 MB)

This week we continue our interview with Noam Kritzer of Bakos & Kritzer, talking about patent case law and patent trolls. Ear Candy is temporary table ghost files, and At the Movies is Manipulating JSON with MariaDB and MySQL.

defensive vs. offensive patents

Patent trolls

Trademarks and domain names

Copyright.gov, a resource written for lay people.

OurSQL Episode 148: Intellectual Property


28:33 minutes (13.23 MB)

This week we interview Noam Kritzer from the law firm of Bakos & Kritzer about copyright, patents and trademarks. Ear Candy is about SUBSTRING_INDEX and At the Movies is Colin Charles presenting a panel on MariaDB.

Events
DB Hangops - every other Wednesay at noon Pacific time

Oracle is having a MySQL OTN Virtual Developer Day August 31st.

FrOSCon - Aug 24-25th, 2013 in St. Augustin, Germany.

OurSQL Episode 137: Playing in the Sandbox


22:58 minutes (11.15 MB)

This week we talk to Giuseppe Maxia about MySQL Sandbox. Ear Candy is about table_open_cache, Open_tables and Opened_tables, and At the Movies features MariaDB.

MySQL Sandbox
MySQL Sandbox

Examples:
MariaDB slave of a master:

make sandbox mysql-tarball --master
make sandbox mariadb-tarball --slaveof master-port=foo

Exporting:

./my sqldump instancename

Remote mysql sandbox deploy:

deploy remote sandboxes -m MySQLVer -l list,of,servers

Get MySQL Sandbox on Launchpad

OurSQL Episode 123: Storing Bags of Bytes


44:28 minutes (20.51 MB)

This week we discuss different filesystems and how they work. Ear Candy talks about the "-bibyte" suffix, and At the Movies presents an indexing webinar.

Events
FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd.

OSCON 2013 will take place in Portland, OR from Monday July 22nd through Friday July 26th. The call for Speakers closes at midnight Pacific Time on Monday, February 4th.

LinuxFest Northwest will take place on Sat Apr 27th and Sun Apr 28th. The call for papers is open and you can submit proposals through Thursday Feb 28th.

OurSQL Episode 122: Nobody's Perfect - 2012 Blooper Retrospective


34:27 minutes (47.47 MB)

This podcast would not achieve its goal if there were no listeners to learn about MySQL. This week we play a bunch of bloopers as our year-end gift to you. We hope these make you laugh!

2011 Blooper Retrospective

OurSQL Episode 116: Do You Make the Grade (part 5)?


32:33 minutes (15.06 MB)

This week, we finish our series on the Operations Report Card as it applies to database administrators. In Ear Candy, we discuss one problem with setting table_open_cache higher than needed., and At the Movies is Tools and Techniques of Index Design by Bill Karwin.

News
MariaDB 10.0.0 alpha is out, including the SHOW EXPLAIN FOR thread_id feature for running an EXPLAIN on a running query, and multi-source replication.

OurSQL Episode 115: Do You Make the Grade (part 4)?


30:42 minutes (14.21 MB)

This week, we continue our series going through the Operations Report Card as it applies to database administrators. This week in Ear Candy, we talk about a hidden client value for max_allowed_packet (separate from the session variable). In At the Movies, we present Karen Tegan Padir of Enterprise DB presenting The More Things Change, the More They Stay the Same.

Events
Oracle's "Scale with MySQL" seminars:
Madrid, Tuesday 27 November

OurSQL Episode 114: Do You Make the Grade (part 3)?


39:32 minutes (18.25 MB)

This week we continue part 3 of the Operations Report Card and how it relates to database administration. This week we talk about the section on "Operational Practices", and it covers how operations are run. In Ear Candy we present different tools for finding a machine's external IP address, and in At the Movies we present a video about MySQL Security from when Sheeri was touring Latin America in July.

Feedback
Webyog's blog noted that the OurSQL blog/podcast was among the Top MySQL Blogs You Should Be Reading. Thanks for your support!

OurSQL Episode 112: Do You Make the Grade (part 2)?


30:13 minutes (13.98 MB)

This week, we go through the "Modern Team Practices" part of the Operations Report Card, and how it applies to DBAs.

Events
Oracle's "Scale with MySQL" seminars:
Scale with MySQL Seminar, London, Tuesday 30 October
Bucharest Romania, Tuesday 13 November
Madrid, Tuesday 27 November

OurSQL Episode 111: Do You Make the Grade (part 1)?


36:34 minutes (16.89 MB)

This is part one of a series where we will explore the Operations Report Card and explain how it applies to DBAs. Listen and grade your own organization, this is a great opportunity to get some new ideas on how to organize your department and make your job more efficient and streamlined.

News
Alaska Airlines system crash

Events
Oracle's "Scale with MySQL" seminars:
Scale with MySQL Seminar, London, Tuesday 30 October

OurSQL Episode 100: The Ball Pit


31:51 minutes (14.74 MB)

This week we present part 2 of our interview with XKCD's Randall Munroe, where we finish talking about data privacy and security, and talk about Randall's real-life ball pit in his apartment, and his thoughts on fanny packs.

Defending your Life - romantic comedy movie

lamebook

Grownups comic:

The ball pit - the blog post with pictures and notes.

OurSQL Episode 99: Data Privacy and Security


34:47 minutes (16.08 MB)

This week we present the 100th episode (yes, we started at episode 0), which is part 1 of a 2 part interview with XKCD's Randall Munroe.

OurSQL Podcast history
Episode 0 was on November 26, 2006.
Episode 26 on December 16, 2010 added Sarah Novotny as the first co-host and we hired our audio engineer and producer, Rich Goyette, due to the support of Justin Kestelyn and the Oracle Technology Network.