This week, Gerry Narvaja guest hosts and we talk about star and snowflake schemas, as a follow-up to last week's podcast on Data Warehousing 101.

News
FOSDEM has a call for papers open until Sunday, November 6th. FOSDEM is one of the largest free and non-commercial open source events, taking place in Brussels, Belgium on February 4th and 5th. There will be a Developer’s room that's near and dear to our hearts called "MySQL, MariaDB and friends".

Josh Berkus of PostgreSQL Experts spoke at OS Bridge this summer on Data Warehousing 101:
Everything you never wanted to know about big databases but were forced to find out anyway (http://it.toolbox.com/blogs/database-soup/data-warehousing-101-slides-video-up-47456 has video and slides)

News
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.

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.

This week, we talk about MySQL security.

News/Feedback
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.

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.

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

Feedback
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

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 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.

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