I have finished the rendering on the Managing Hierarchical Data With MySQL session:

http://www.openwin.org/mike/video/hierarchy2006/

Requires Flash

On top of everything else I saw at the MySQL UC, I saw enough snazzy digital SLRs to make me green with envy (curse you Stewart, Mike, George, Colin, Jeremy and Julian!)

So, I decided to whip up a way out-there camera wishlist to rule them all! I may not actually have any of this, but when some generous millionaire buys it all for me I shall have the mightiest setup of all at the next uc!

Ok so it is just an excuse to play with the wishlist plugin for wordpress.

This post recorded mid-day on Friday.

The MySQL User conference has ended and I find myself waiting for my flight home — a good time to gather thoughts.

I personally think the conference was a great success. We had over 1500 attendees and the feedback I heard on the conference was very positive. I did hear a few asking for the sessions to be longer than 45 minutes and I do agree that 45 minutes can be a bit cramped, especially for a speaker who is re-using a session previously delivered in a longer block, but overall the response was great.

I had three sessions this year, and those sessions seemed well received by the attendees I spoke to. I am *very* glad that I backed up my slides to a keychain drive and ghosted my drives before leaving as it made the crashing of my laptop an annoyance rather than an unmitigated disaster. I worry that the distraction of a laptop crash may have left me at less than 100% for my sessions …

Update: High Res Versions at http://www.openwin.org/mike/wordpress/wp-gallery2.php?g2_view=core.ShowItem&g2_itemId=1198

This year there was a nice little bonus, Julian Cash was on hand to take photos of the staff with a proper studio setup. I’ve seen some of his work before and liked it, and was looking forward to a session. When the photo sessions were announced, we were asked to bring a prop that represented ourselves or our work or personality. I actually forgot about the prop requirement but went for a session on the way to my Hierarchy talk and walked in carrying a stack of books to give away. Julian took one look and pronounced ‘Great Prop!’ upon seeing my stack of books. It was not planned as a prop, but seeing as I am a technical writer and …

Mixi is a massive social networking site in Japan, nice user interface demo.

Began in late 2003 with 10,000 users and 600K pageviews a day. As it became clear that the site was viral, the question became how to scale out before getting overwhelmed.

In the first year they went from 600 users to 210,000 users.

2,000,000 users in the second year.

Now 3.7 million users, with 15,000 new users per day. Japan has 86.7 million users.

Site has 70% active users (logging in at least every 72 hours). Average user spends 3 hours 20 minutes on mixi a week. 35th on Alexa worldwide, 3rd in Japan.

Mixi now gets more traffic than Amazon Japan.

Mixi uses LAMP (perl), memcache, squid. Fedora for Linux.

Requests go mod_proxy to mod_perl, then either memcache or a set of MySQL servers divided by blogs, messages and other.

Using more than 100 servers, 10 new servers per month. All done …

I’ve finished my last of three sessions, finally getting through my hierarchies session. With the laptop failure, speaking just was not as enjoyable this year as in previous years when there were no such concerns to distract me from giving the audience a good session.

The Hierarchies session seemed well received, with the room packed and audience members up against the back wall. I do wish I had not been opposite the Second Life session, as I was quite interested in how they scale.

Materials

Managing Hierarchies

Sakila Sample Database - …

As I mentioned previously, I’ll be reporting on the conference swag along with the sessions at this year’s MySQL User Conference.

The first candidate? The SCO Giant Pen

Check it out!

I love our IT guys. One call to the Cupertino office and one of the IT guys drove to the conference center with the discs needed to reinstall Windows and Office.

I’m now getting everything patched and ready to deliver my session on Managing Hierarchical Data. Sadly there is no recording of the Sakila session because I had to deliver it on a conference-provided PC.

Lessons learned:

Do not sit near high voltage lines and work on your laptop. The only explanation I have for the issues is that I sat near a thick power cable for the lights during the keynote, perhaps it was not well shielded and corrupted files.

Keep your slides in at least three places. When I left I copied my slides from my desktop to my laptop and also to a keychain drive. When my laptop failed I was annoyed but did not panic because I was able to simply insert my keychain into the dekstop provided in the session room and deliver my …

Just a warning to everyone that I will not be posting many blog entries from the UC today, my laptop is suffering from an unknown issue that I need to diagnose and repair before I can do any work from it.

On the bright side there is a great blogger contingent here this year and there is plenty of content to go around.

Session attendees: I will get content online as soon as I can.

Session by Laura Thomson, OmniTI. Laura is author of a number of popular PHP and MySQL books.

Session will be on security at the developer level and is written from a programmer’s perspective.

Many developers plug along without any knowledge that they have security problems, security awareness is a relatively new thing. This session is not about guru-level knowledge, it is about developer-level practices.

MySQL Security Basics

• Do not run your mysqld as the unix root user. Run it as a purpose-created user.Do not use the purpose-created user for anything else. MySQL root user is not related to the Unix root user.
• Set permissions on DB data files directory so that only mysqld user can access them.
• Disable symlinks to tables with –skip-symbolic-links unless you need them.
• Disable access to port 3306 except to trusted hosts.

…