OurSQL Episode 83: The NewSQL World

This week, we talk with Ori Herrnstadt, CTO of Akiban.

MariaDB announced their 5.3 GA and 5.5 alpha releases.

Oracle will be at DrupalCon in Denver, CO from Monday, March 19th through Friday, March 23rd.

Percona's XtraDB cluster announcement

OurSQL Episode 71: Table Manners, part 2

This week, we continue our discussion about MySQL and its forks. We discuss the Percona server and MariaDB.

Percona Live comes to Washington, DC on Wednesday, January 11th, 2012 at the Walter E. Washington Convention Center. There is a 50% discount for students, faculty and staff of educational organizations, and a 35% discount for government employees.

Percona Server
Percona software

OurSQL Episode 68: Scaling, or Sailing?

This week Sheeri visits the Schooner offices and inteviews Dr John Busch, the CTO, Founder, and Chairman of the Board for Schooner. Schooner is able to fully use multi-core processors and do fully synchronous replication without losing performance. The new 5.1 release offers parallel synchronous replication with automated failover between remote data centers.

Both Sheeri and Gerry have new jobs - Sheeri wrote about her change at

OurSQL Episode 67: HA and Replication

This week, we talk about mysql ha and replication.

Last week we talked about how we learn and keep up to date with changes to MySQL. Mark Grennan of posted his own list of MySQL resources.

Call for papers for Percona Live: MySQL Conference & Expo 2012 is open until Monday, December 5th. To submit a paper, first register as a speaker at and then go to My Account -> Submit Proposal.

OurSQL Episode 54: Scaling MySQL

This week, we discuss the Percona MySQL conference and scaling with ScaleBase.

Percona Live MySQL Conference and Expo event page, and Baron's announcement of the conference.

Dates to keep in mind:
September 1st - call for speakers opens
November 1st - call for speakers closes
Tuesday April 10th - Thursday April 12th

This week we interview Doron Levari, CEO and co-founder of ScaleBase. ScaleBase transparently scales your database, so you can have many shards without having to code sharding in your application. The sharding is completely transparent to the application. This can be combined with regular replication to have automatic use of a standby if a shard's primary database fails.

OurSQL Episode 50: MySQL at Facebook, Current and Future

This week we post the audio from the closing keynote of Percona Live by Harrison Fisk of Facebook, "MySQL at Facebook, Current and Future". There is no ear candy this week.

OurSQL Episode 43: Repli-cans and repli-can'ts

Note: We said this was episode 44, but it's really episode 43!

In this episode we give the basics of how replication works, giving knowledge about the fundamentals about replication to better understand why it has certain limitations and benefits.

Slave IO thread states in SHOW PROCESSLIST
MIXED binary log format defaults to STATEMENT, unless certain conditions apply, which are listed at that link.

OurSQL Episode 42: The Buzz about MySQL 5.6

This week we talk about what's new in MySQL 5.6 and the return of We also feature people's reactions to the 5.6 announcement and a special song by Solomon Chang (lyrics below).

Show notes:
If you want to see it for youreslf, there is a video from the O'Reilly Conference of Tomas Ulin's Keynote, "State of the Dolphin".

Olav Sandstå's blog post on index condition pushdown optimization.

OurSQL Episode 40: TokuDB 5.0 part 2

This week we conclude the interview with Tokutek's co-founder and Chief Scientist, Martin Farach-Colton. Part 1 of the interview. 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, have completely online column and index addition and removal and unlike InnoDB and XtraDB, do not fall apart when indexes no longer fit into memory.