Presentations/Videos

Well, nobody from Sun showed up in person, but we got a great rendition of "Where were you when you heard THE NEWS that Sun bought MySQL?" from Mark Rubin, the MySQL Sales Engineer for the New England area, and from Giuseppe Maxia, who revealed something very interesting and riveting. From there, Giuseppe gave a short talk on what it's like to work at MySQL, and then we moved on to the topic of the user group meeting, "What is MySQL Cluster Good For?" The slides for the talk are downloadable in PDF Format 61kB and Flash (SWF) format, 31kB The video can be played at http://technocation.org/node/572/play and downloaded (404 Mb) at http://technocation.org/node/572/download

The last keynote of Tuesday evening at OSCon 2008 was entitled "Temporarily Quaquaversal Virtual Nanomachine Programming in Multiple Topologically Connected Quantum-Relativistic Parallel Timespaces.....Made Easy!" Damian Conway is a speaker that should not be missed. He spends his time hacking perl to do fascinating and obscure feats of technology such as time travel. This video is just over an hour of rolling laughter that will entertain you into realizing what a genius Damian Conway is. Now, most of my exposure is within the MySQL Community, so if folks could pass the links to the video along to other communities, that would be great. (This video is at 1.0 Mb/sec. Watch the video online at http://technocation.org/node/571/play or download it at http://technocation.org/node/571/download. Please do not download the file if you are on the conference network, these links are not time sensitive.)

The Boston MySQL User Group was lucky enough to get Keith Murphy to speak at the June User Group meeting, about backups. Links referred to in the presentation: MyLVMBackup by Lenz Grimmer http://lenz.homelinux.org/mylvmbackup/ InnoDB Hot Backup: Prices are at: http://www.innodb.com/hot-backup/order/ and at the time of this writing are: 1-Year License € 390 USD$ 605 per server Perpetual License € 990 USD$ 1540 per server Zmanda prices are at: http://network.zmanda.com/shop/home.php?cat=1,3 Current prices are between the range of $100-$450, and a license is needed for each server and each client. So if you have 1 server and 3 clients, you need 4 licenses. Online Backup This is interesting reading about online backup, an article about how the online backup works at: http://blogs.mysql.com/peterg/2008/05/19/mysql-60-feature-2-online-backup/ This page (at the bottom, under "Replication") states that the desired behavior is that the binary log does not log the restore or the backup. However, it does state that this is not implemented yet, nor even decided upon. There's also a great page on Online Backup at the MySQL Forge: http://forge.mysql.com/wiki/OnlineBackup And if you're short on time, the manual has a short page at http://www.nongnu.org/rdiff-backup/ duplicity: http://duplicity.nongnu.org/ It was mentioned that some people use a code repository to backup their database: http://krow.livejournal.com/593424.html

At the 2008 MySQL Conference and Expo, Chander Kant of Zmanda delivered a keynote on "Radically Simple Backup & Recovery for Live MySQL". Get the slides on the Forge at http://forge.mysql.com/wiki/MySQLConf2008ThursdayNotes#Radically_Simple_Backup_.26_Recovery_for_Live_MySQL

At the 2008 MySQL Conference and Expo, Jeff Rothschild of Facebook.com delivered a keynote entitled "A Match Made in Heaven? The Social Graph and the Database". See people's blog posts on the Forge at http://forge.mysql.com/wiki/MySQLConf2008ThursdayNotes#A_Match_Made_in_Heaven.3F_The_Social_Graph_and_the_Database

At the 2008 MySQL Conference and Expo, Ronald Bradford delivered "The Top 20 Design Tips for Enterprise Data Architects". See the slides on the Forge at http://forge.mysql.com/wiki/MySQLConf2008ThursdayNotes#Top_20_DB_Design_Tips_Every_Architect_Needs_to_Know

At the 2008 MySQL Conference and Expo, the closing keynote was Jacek Becla speaking on "The Science and Fiction of Petascale Analysis". See the slides on the Forge at http://forge.mysql.com/wiki/MySQLConf2008ThursdayNotes#The_Science_and_Fiction_of_Petascale_Analytics

At the 2008 MySQL Conference and Expo, there was a panel discussion on "Addressing Challenges of Data Warehousing - a Panel Discussion" including: Robin Schumacher (Sun/MySQL) (moderator) Brian Miezejewski (MySQL), Charles Hooper (Pro Relational Systems), Paul Whittington (NitroSecurity, Inc.), Raj Cherabuddi (Kickfire), Victoria Eastwood (InfoBright Inc.)

At the 2008 MySQL User Conference and Expo, Lenz Grimmer spoke about "Performing MySQL Backups Using LVM Snapshots". Download the slides, see people's notes, and more on the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008WednesdayNotes#Performing_MySQL_Backups_Using_LVM_Snapshots

At the 2008 MySQL User Conference and Expo, Farhan Mashraqi spoke about "Optimizing MySQL and InnoDB on Solaris 10 for World's Largest Photo Blogging Community". Download the slides, see people's notes, and more on the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008ThursdayNotes#Optimizing_MySQL_and_InnoDB_on_Solaris_10_for_World.27s_Largest_Photo_Blogging_Community

At the 2008 MySQL User Conference and Expo, Eric Herman and Antony Curtis spoke about "External Language Stored Procedures". Download the slides, see people's notes, and more on the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008ThursdayNotes#External_Language_Stored_Procedures

At the 2008 MySQL User Conference and Expo, Ann Harrison and Kevin Lewis spoke about "Falcon for Innodb Users". Download the slides, see people's notes, and more on the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008WednesdayNotes#Falcon_for_InnoDB_Users

At the 2008 MySQL User Conference and Expo, Baron Schwartz spoke on "The MySQL Query Cache". Download the slides, see people's notes, and more on the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008WednesdayNotes#The_MySQL_Query_Cache

At the 2008 MySQL User Conference and Expo, Monty Widenius spoke on "Architecture of Maria: A New Storage Engine with a Transactional Design ". Download the slides, see people's notes, and more on the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008WednesdayNotes#Architecture_of_Maria:_A_New_Storage_Engine_with_a_Transactional_Design

At the 2008 MySQL User Conference and Expo, Phil Hildebrand spoke on "Applied Partitioning and Scaling Your Database System". Download the slides, see people's notes, and more on the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008WednesdayNotes#Applied_Partitioning_and_Scaling_Your_Database_System.