This week we have feedback about Gazzang - 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 … [Read more...]

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 … [Read more...]

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 … [Read more...]

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 … [Read more...]

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 … [Read 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, so for this first of a 2-part series, we present the theoretical side of things. ACID - atomicity, consistency, isolation, durability BASE- basically … [Read more...]

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: Hadoop Cassandra read more … [Read more...]

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. … [Read more...]

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 … [Read more...]

This week we have feedback from Percona Live in NYC last Thursday. We talk with: Chander Kant of Zmanda, talking about the fact that Zmanda Backup Recovery now officially supports the Percona patched binary of MySQL. Barry Leung of CafeMom.com who talked about all the stuff he'd learned during the day, including "How to use MySQL and DTrace on … [Read more...]

Feedback: Via Henrik Ingo - Drizzle has microsecond granularity for timestamp. MariaDB just developed a patch for that, in the 5.3 tree. http://docs.drizzle.org/date_time_data_types.html http://kb.askmonty.org/search/?q=microsecond http://kb.askmonty.org/v/what-is-mariadb-53 editors note: updated with a specific link from Henrik More … [Read more...]

This week we talk about time formats and time zones in MySQL - including how changing the system time changes TIMESTAMP values but not DATETIME values. We also talk about how to handle and store microseconds in MySQL. From the MySQL manual: date and time types TIMESTAMP properties and how it is stored in UTC transparently in the … [Read more...]

At Open Database Camp in Sardinia last week, there was a hackfest to try to get replication working from MySQL to MongoDB. In only 2 hours and 45 minutes, a small group of hackers did it! This week I interview Flavio Percoco, the MongoDB guru on the team, who talked about getting replication from MySQL to MongoDB working via Tungsten Replicator … [Read more...]

Last week's podcast, containing an overview of replication This week we have Robert Hodges, CEO of Continuent, talking about the Tungsten replicator, which has an open source component with global transaction id's and can be used for many features, including high availability and replication to systems other than MySQL. Tungsten Replicator won … [Read more...]