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...]
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 … [Read more...]
OurSQL Episode 55: MySQL Data Encryption
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...]
OurSQL Episode 54: Scaling MySQL
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...]
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 … [Read more...]
OurSQL Episode 52: Database Theory ABC
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...]
OurSQL Episode 51: Data Infrastructure at 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: Hadoop Cassandra read more … [Read more...]
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. … [Read more...]
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 … [Read more...]
OurSQL Episode 48: Percona Live NYC 2011
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...]
OurSQL Episode 47: Replication logs and objects
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...]
OurSQL Episode 46: It’s About Time
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...]
OurSQL Episode 45: Hackathon Success! (MySQL -> MongoDB replication)
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...]
OurSQL Episode 44: Elemental Replication (Tungsten, that is)
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...]
Blue Gecko at the 2011 MySQL Conference
Hello to those of you who are in Santa Clara! Patrick Galbraith and I will be here this week, speaking and glad handing. You can find us both in the Attendee Directory and identify either or both of us as someone you’d like to meet. Patrick’s Sessions are: 5:15pm Wednesday – Perl programming with MySQL and Drizzle 11:55am … [Read more...]