At the January 2009 Boston User Group I presented a session on the new partitioning feature in MySQL 5.1. I go through how to define partitions, how partitioning makes queries faster, the different types of partitioning and when to use each type, and the restrictions and limitations of partitioning.

The sildes are available at http://www.technocation.org/files/doc/2009_01_Partitioning.pdf. The 380.6 Mb .mov movie (1 hr 16 min) can be played directly in your browser at http://technocation.org/node/671/play or downloaded at http://technocation.org/node/671/download.

read more

What's new, in a nutshell: http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html.

Release notes: http://dev.mysql.com/doc/refman/5.1/en/news-5-1-x.html (In the video, it's the page entitled "Changes in release 5.1.x").

And yes, very early on (at about 2 minutes in) I talk about my take on Monty's controversial post at http://monty-says.blogspot.com/2008/11/oops-we-did-it-again-mysql-51-released.html

read more

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 …

In summary: Who: you, me, MySQL/Sun What: MySQL User Group with free swag, food, and a short workshop to boot. When: 7-9 pm, Monday March 10th Where: MIT Building E-51, room 372 Why: why the heck not! Because Sun just bought MySQL, and because there’s a user group each month. How: RSVP optional but requested [...]

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.

read more

I have finally managed to watch and slightly edit the September 2007 Boston MySQL User Group presentation I did on the MySQL Proxy.

It's geared towards beginners, and has lots of examples, including explaining some of the examples that come bundled with the MySQL Proxy.

Direct Play

Download video (.wmv file, 612 Mb)
Download video (.wmv file, 76.10 Mb)

Enjoy!

Some resources:
Presentation Slides PowerPoint (ppt) or PDF or …

Using MySQL As Active DBMS for Monitoring Applications — Jacob Nikom.

Jacob presented this as a special preview at the April 2007 Boston MySQL User Group, and then presented it at the 2007 MySQL Users Conference and Expo.

The last in the “better late than never” series….

Download from http://www.technocation.org/videos/2007_04BostonUserGroup.wmv
or view right here:

Georg, Sandro and I followed one handwritten sign that pointed to another til we soon found ourselves in a cozy little bar hidden away at the back of an industrial space. In the corners and near the bar, a few groups of people chatted easily.

A projector waited on one of the tables, perched atop a couple empty plastic beer crates. The PowerBook connected without fuss - though I have yet to be able to coax 1024 x 768 out of the damn thing when connected to a projector.

After a quick restart of X, all was ready to go. We waited for the room to fill in a bit. The screensaver rotated pictures from our vacation at the Hallig and we joked about the various photos. It was quite pleasant - especially since friend, colleague and MySQL buildmeister Lenz Grimmer took some time from his move to come and visit.

By the time that Ulf arrived, there were about 25 people in the room and Georg and I started the …