|
This week we listen to MySQL founders David Axmark and Michael "Monty" Widenius talk about all sorts of topics, from the MySQL ecosystem to "Crazy Monty", an open source restaurant. David and Monty don't always agree, so this panel is enlightening and also funny.
News/Events/Feedback
MariaDB 5.5 features - 5.5 is now GA!
IOUG podcast about MySQL Connect and the new Development Milestone Release (DMR) of MySQL 5.6.
This week we give an overview of Percona Live and what we think are the highlights, including which sessions we recommend for beginners and which we cannot wait to see for ourselves.
On Tuesday June 5th, 2012, a MySQL Innovation Day is being hosted at Oracle’s Conference Center in Redwood Shores, California. The MySQL Innovation day will feature multiple “lightning” talks by Oracle’s MySQL Engineers, If you cannot make it out to California, the lightning talks will be available via a live webcast, too - so either way, save the date! Unfortunately there's no link yet.
We go over the open calls for papers, upcoming conferences, conversations with Oracle, and finish up our 2-part series on MySQL security.
Calls for papers:
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, April 12, 2012 in Santa Clara, CA.
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.
This week we talk with Giuseppe Maxia (pronouncing his name correctly!) about new features in Tungsten replicator, and go over a lot of news.
News:
There was a lot of news this week! There were three really big announcements at Oracle OpenWorld that relate to the MySQL community:
Oracle released a NoSQL database. http://www.oracle.com/technetwork/database/nosqldb/overview/index.html
It’s an ACID-compliant key-value data store, with a Java API for put, delete and get operations and includes replication. The data partitioning and distribution is automatic and based on a hash function.
The main content this week is previewing Oracle OpenWorld's MySQL sessions.
News
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.
During OSCon, I went to dinner with a bunch of MySQL folks - Henrik, Mats, Lars, and Rich (audio engineer for the OurSQL podcast). On the recommendation of some friends in Portland, we went to Le Bistro Montage. There, we raised our shot glasses (full of an oyster shooter) and sang Helan Går (well, I did not sing because I have not familiarized myself with the song -- I am not a big drinker!)
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.
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 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.
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
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 Linux" and the new mk-tcp-model.
Patrick Galbraith of BlueGecko talked about his talk, "The Building Blocks of Scaling: Drizzle/MySQL, Memcached, Sphinx, and Gearman", backups, FLUSH ENGINE ____ LOGS, and covering indexes.
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 (which we talked about on last week's podcast).
This week we talk about what's new in MySQL 5.6 and the return of labs.mysql.com. 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.
We talk about the Collaborate conference, including comparisons to the O'Reilly MySQL conference.
Show notes:
Collaborate - http://collaborate11.ioug.org/
Sunday, April 10th through Thursday, April 14th in Orlando, Florida.
$200 off with code: MYSQ
Pricing can be found at http://collaborate11.ioug.org/Home/Registration/tabid/82/Default.aspx#rates
MySQL Community Dinner East at Maggiano's Little Italy on Sunday, April 10th at 5 pm. RSVP at http://2011mysqlcommunitydinnereast.eventbrite.com/
Show notes:
Previous backup series podcast:
Backup glossary [Backup series #1]
Feedback:
In the backup glossary we asked if anyone knew how to get logical data out of physical InnoDB files. Mike Hamrick of Blue Gecko wrote in to say that Percona's InnoDB recovery tool helps to do just that. He writes:
"The 'page_parser' tool will read ibdata files or individual .ibd files and turn them into a series of 16k page files suitable for processing with a tool called 'constraints_parser' which spits out a number of tab separated lines of table data suitable for a LOAD DATA INFILE.
Show notes for Episode 28:
Some feedback from previous podcasts:
Percona *is* releasing a 5.5 version - http://www.mysqlperformanceblog.com/2010/12/20/mysql-5-5-8-and-percona-s...
Also, the performance schema is persistent (stored on disk) according to Giuseppe Maxia, the Datacharmer.
* Update 1/6/2011 14:17 Eastern time - according to Mark Leith, only the setup_ tables are persistent, so only some of the data makes it to disk and is persistent.