OurSQL Episode 58: Opening up Oracle's World

The main content this week is previewing Oracle OpenWorld's MySQL sessions.

Call for papers for Percona Live: MySQL Conference & Expo 2012 is open! The call will close on Monday, December 5th. To submit a paper, first register as a speaker at http://www.percona.com/live/mysql-conference-2012/user/register and then go to My Account -> Submit Proposal.

CouchConf NYC is happening on Monday, October 24th in New York City. CouchConf is a one-day conference focused on Couch NoSQL database technology for web and mobile applications. There will be numerous technology sessions presented by leaders of the Apache CouchDB project and other Couch experts.

OurSQL Episode 57: Eventual Discovery part 2

This week we continue our series on events. We talk about events and logging, event timing, privileges and runtime behavior.

Gazzang is using encryptfs for their encryption. According to their launchpad project page at https://launchpad.net/ecryptfs, "eCryptfs is a POSIX-compliant enterprise-class stacked cryptographic filesystem for Linux".

The main topic is the 2nd part of events:

What events log and where the event logs are
How errors show up in the error log
How events and their actions get logged to the binary logs (aka events and replication), including how the "ignore" and "do" replication limitations work with events. Manual page: http://dev.mysql.com/doc/refman/5.5/en/stored-programs-logging.html

OurSQL Episode 56: Eventual Discovery part 1

This week is all about events - events in MySQL, and calls for papers for 2012 conferences.

Percona Live MySQL Conference & Expo call for papers opens soon. http://www.percona.com/live/mysql-conference-2012/

A session matrix for all of the MySQL sessions at Oracle OpenWorld is at http://bit.ly/oow11mysql.

MySQL Community Reception (free, no need to be registered to Oracle OpenWorld) - Tuesday, October 4, 2011 7-9 pm at the San Francisco Marriott Marquis Foothill G. RSVP for the *free* MySQL Community Reception.

OurSQL Episode 55: MySQL Data Encryption

This week, we talk with Mike Frank of http://www.gazzang.com/, answer a question about ScaleBase and stored routines/triggers, and link to over 100 videos from OSCon, OSCon Data and OSCon Java.

OSCon Data and OSCon videos
The Technocation youtube playlist, as of the time of this publishing has 18 videos, mostly from OSCon Data, is at http://www.youtube.com/playlist?list=PLE0AEC3980A198DA0

The O'Reilly YouTube playlist, as of the time of this publishing has 84 videos, from OSCon, OSCon Data and OScon Java, is at http://www.youtube.com/playlist?list=93FC98105B19725C

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 53: MySQL 5.6 at OSCon Data

This week we speak with Calvin Sun, the Development Manager of the InnoDB Team, and has been working on InnoDB at MySQL and Oracle for 5 years. He mentions that not only is the InnoDB team hiring, but nobody has left the InnoDB team in several years, so the team is very stable.

We grabbed Calvin at OSCon Data, where Oracle announced the new features of MySQL 5.6 released on labs.mysql.com. Remember that the labs releases are for testing only and not supported in production use.

OurSQL Episode 52: Database Theory ABC

This week, we present ACID, BASE, CAP theorem and more.

At this year's Open Source Bridge in Portland last month, Eric Redmond presented 'A Dozen Databases in 45 minutes'. It’s really about 20 minutes of theory and 25 minutes of the dozen databases, and we present the first part, the theoretical side of things.

ACID - atomicity, consistency, isolation, durability
BASE- basically available, soft state, eventual consistency (there's also a good article by Lewis Cunningham that explains ACID vs. BASE in the context of cloud computing.

OurSQL Episode 51: Data Infrastructure at OSCon Data

This week, we talk about OSCon Data.

Strata (Big Data Conference) - Sept 19-23 in NYC http://strataconf.com/stratany2011 - the call for proposals is still open until July 15th.

OSCon, the Open Source Convention, is Jul 25 - Thu Jul 29th
Co-located this year:
OSCon Data
OSCon Java

OSCon Data content mentioned:

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 49: Stalking MySQL

Reminder: Due to busy summer conference schedules, we are going to be publishing the podcast every other week.

This week we talk about a monitoring plugin from PalominoDB that uses caching (like the cacti templates) and allow for arbitrary calculations of thresholds based on status and system variables, and items from the PROCESSLIST.

pnp4nagios - from the site, "PNP is an addon for the Nagios Network Monitoring System. PNP provides easy to use, easy to configure RRDTools based performance charts feeded by the performance data output of the Nagios Plugins."