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
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, 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
Server
MySQL
query
optimization
performance
tuning
presentations/videos
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, 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 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.
Server
MySQL
performance
tuning
Conferences
presentations/videos
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, 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, 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, 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
Server
MySQL
query
optimization
performance
Conferences
presentations/videos
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, Robert Hodges spoke on "Portable Scale-out Benchmarks for MySQL". Download slides and see links to blog postings at the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008WednesdayNotes#Portable_Scale-out_Benchmarks_for_MySQL
Server
MySQL
performance
tuning
Conferences
presentations/videos
At the 2008 MySQL User Conference and Expo, Rick Falkvinge of the Swedish Pirate Party delivered a keynote on "Copyright Regime vs. Civil Liberties".
At the 2008 MySQL User Conference and Expo, Domas Mituzas gave a workshop on "Practical MySQL for Web Applications".
At the 2008 MySQL User Conference and Expo, Brian Miezejewski gave a workshop on "Securing MySQL for a Security Audit".
At the 2008 MySQL User Conference and Expo, Rick Falkvinge of the Swedish Pirate Party delivered a keynote on "Copyright Regime vs. Civil Liberties".
At the 2008 MySQL Users Conference and Expo, Werner Vogels of Amazon.com delivered a keynote called "A Head in the Cloud -- The Power of Infrastructure as a Service". See all the blog posts others have written about the tutorial from the Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008TuesdayNotes#A_Head_in_the_Cloud_-_The_Power_of_Infrastructure_as_a_Service.
At the 2008 MySQL Users Conference and Expo, Sebastian Bergmann presented "Video: Testing PHP/MySQL Applications with PHPUnit/DbUnit". See all the blog posts others have written about the tutorial from the Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008TuesdayNotes#Testing_PHP.2FMySQL_Applications_with_PHPUnit.2FDbUnit.
At the 2008 MySQL Users Conference and Expo, Mårten Mickos delivered the "State of the Dolphin Keynote". See all the blog posts others have written about the tutorial from the Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008TuesdayNotes#State_of_MySQL.
At the 2008 MySQL Users Conference and Expo, Mårten Mickos handed out the 2008 awards for Application, Partner and Community Members of the year See all the blog posts others have written about the tutorial from the Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008TuesdayNotes#State_of_MySQL.
At the 2008 MySQL Users Conference and Expo, Brian Aker (MySQL) and Allan Kasindorf (SixApart) gave a presentation on Memcached and MySQL. Download the slides and see blog posts others have written about the tutorial from the Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008MondayNotes#Memcached_and_MySQL.
If you'd like to download the WMV video file in parts, here's a link to:
Part 1, 112.09 Mb
At the 2008 MySQL Users Conference and Expo, Lars Thalmann and Mats Kindahl gave a tutorial on replication. Download the slides and see blog posts others have written about the tutorial from the Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008MondayNotes#MySQL_Replication_Tutorial.
If you'd like to download the WMV video file in parts, here's a link to:
Part 1, 175.27 Mb
and
I have already blogged about this keynote at http://www.pythian.com/blogs/948/liveblogging-who-is-the-dick-on-my-site.
If you are interested in actually seeing the video, the 286 Mb .wmv file can be downloaded at http://technocation.org/videos/original/mysqlconf2008/2008_04_17_panelDick.wmv and played through your browser by clicking the "play" link here. This is not to be missed!
Yesterday's keynote panel on "Scaling MySQL -- Up or Out?"
Keith Murphy managed to take painstaking notes with all the facts and figures. As well, Venu Anuganti presents a chart with the results as well as notes on the more detailed answers. Ronald Bradford has a brief summary of the 20 seconds of wisdom from each panelist.
Firstly, I finally realized who Jonathan Schwartz reminds me of:
That's right, comedian and magician Penn Jillette.
Schwartz started by saying, "enough of this free software stuff!" It got lots of laughs. He started to talk about Sun's agenda, and mentioned that MySQL and Sun had similar values, as well as similar dysfunctions as well -- particularly that each engineer has his/her own opinion.
The slides for today's presentation at Shmoocon are here:
http://technocation.org/files/doc/2008_02_SecuringDBs.pdf
Just a note so folks at the conference can download them whenever they want. Folks not at the conference can, too but the slides don't give away the whole talk so I don't know how useful they're going to be.....
Patrick Galbraith, former MySQL employee who helped write replication, came to the November 2007 Boston MySQL User Group and did a fantastic presentation on replication, including showing how to set up replication and walking us through the steps in real-time, setting up an example server.
Smaller, 320x240, 293M WMV file for download
References mentioned in the video:
Brian Aker's DBIx::Password
Giuseppe Maxia's article about federated tables -- I think that's the right one, feel free to comment if it's not.
MySQL Boston September/October 2007 User Group
Before the MySQL Proxy tutorial at the September/October Boston MySQL User Group, we had a few questions. This video has those questions -- odd myisam corruption from having 2 machines with the same server-id and a question on upgrading Mysql from 3 to 5, with a followup on how to figure out when to upgrade. More »
Skoll is a Community-Based Testing project out of the University of Maryland. Their first testing framework comes for MySQL. Watch Sandro Fouché, graduate researcher on this project, take you through what Skoll is, how it's beneficial, and how you can use it with an actual demo.
The Skoll testing client for MySQL can be downloaded here:
http://www.cs.umd.edu/projects/skoll/contribute/