Collaborate Call for papers is open until Sunday October 14th - http://events.ioug.org/p/cm/ld/fid=15
Collaborate is an Oracle Technology and Applications conference put on by IOUG, OAUG and Quest. It is the largest independent Oracle conference, and we are planning on having a one-day track there. Collaborate is at the Mandalay Bay Convention Center in Las Vegas, Nevada from Sunday April 22nd - Thursday 26th, 2012.
Call for papers for Percona Live: MySQL Conference & Expo 2012 is open! They opened it on Friday, September 15th and the call will close on Monday, December 5th. The MySQL Conference & Expo is Tuesday April 10 - Thursday, October 12, 2012 in Santa Clara, CA.
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".
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.
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.
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.
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 Application of the Year award at the 2011 O'Reilly MySQL Conference.
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.
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.
We spoke with Martin Farach-Colton, co-founder and Chief Scientist of Tokutek about the TokuDB storage engine, including the new features in TokuDB 5.0, which was announced on Tuesday.