MySQL Users Conference & Expo 2004 Highlights

This is a collection of blog entries by speakers, organisers, and attendees of the 2004 MySQL Users Conference & Expo.

Why MySQL grew so fast (news from the 2004 MySQL Users Conference)

Performance Tuning J2EE Applications deployed on MySQL

Last week I attended Mark Matthew's "Performance Tuning J2EE Applications deployed on MySQL" at the MySQL Conference (see Anthony's Review ). Mark's presentation had a lot of tips and tricks with the MySQL JDBC Driver. I asked him to send me a copy - a

Great Conference

Well, the 2004 MySQL User's Conference & Expo has come and gone, and boy am I tired. I think a conference where you speak is a bit like Christmas: you anticipate it for a long time, have a lot of...

MySQL and PHP: Best Practices

Session by Jim Winstead, webmaster of MySQL AB. Security Do not run the server as root, or as the same user as Apache if you use the two on he same box. Set a root password right away on a...

MySQL and PHP: Best Practices

Jim Winstead speaks about good practice for MySQL and PHP at MySQL 2004. Looking down this it appears that I've just duplicated Jim's slides, not sure how much value that adds if you can just go an get the slides...

Conference Wrapup

Well, three days later and I'm on my way back home. The MySQL conference went very well - I've picked up quite a lot of interesting techniques for performance and scalability enhancements. I've also had the opportunity to network with...

New Features in MySQL 3.1

MySQL Connector/J New Features presented by Mark Matthews, the developer of Connector/J. Current stable release is 3.0. Development release is 3.1 and is currently alpha. The development schedule is tied directly to the releases of MySQL 4.1 and 5.0. C...

Stored Procedures in MySQL

In the lab watching Peter Gulutzan demonstrate stored procedures and functions at MySQL 2004. Won't write everything (like the other sessions), just interesting notes not from the docs. The nice thing about using a standard is the book is already...

Jeremy Zawodny presents "The Evolution of MySQL at Yahoo"

Being that it is the third day of the conference and I am beat, the following post may ramble a bit... Reasons why Yahoo selected MySQL: cost and performance are two of the primary reasons. Other factors are stability, reliability...

The Evolution of MySQL at Yahoo

Decided to hang out with Jeremy at MySQL 2004 to get the low-down (or down-low) on the non-technical view of MySQL at Yahoo! Over the years I've heard a bit about Yahoo from Jeremy's weblog and presentations at OSCON but...

Why it is a great time to be an open source entrepreneur

Tony Perkins, founder of Red Herring and AlwaysOn network, delivers the second keynote of Friday morning at MySQL 2004. Tony also wrote The Internet Bubble: Inside the Overvalued World of High-Tech Stocks. Bill Gates (Microsoft): "IT will provide over ...

M�rten Mickos Keynote

M�rten is the CEO of MySQL AB. M�rten is talking about Open Source principles and the commons. M�rten is speaking about incumbent companies in the market and how they often over-engineer their products to the point of overkill. In the...

How Far Can Open Source Go?

Marten Mickos, MySQL CEO, is delivering the first keynote of the final day at MySQL 2004. Starts by asking: Is Ingvar Kamprad (founder of IKEA) the richest man in the world? Some calculation somewhere says yes. MySQL is just one...

What I Learned from Orlando TV

A quick glance at TV this morning while I shaved has taught me two things: 1) Orlando media revolved around Disney and DisneyWorld. Only here do new rides and evil park employees make the news. 2) Many Orlando residents must...

MySQL Query Browser

Last MySQL 2004 presentation of the day . . . a demo of MySQL Query Browser. Apparently (according to Jeremy) this tool has been in development for a matter of weeks, but is coming along so nicely they decided to...

Database Design Workshop

Sitting (on the floor) at MySQL 2004 in the Database Design Workshop with Lenz Grimmer, Jeremy Zawodny, Jeremy Cole and Sergei Golubchik). The session is a Q/A for database design (but really turned into a "ask anything about MYSQL"). A...

Matt Raible on AppFuse

Matt Raible is presenting on AppFuse and using it as a means to speed application development. Warning: The style of development which AppFuse supports is very common in Java but that doesn't mean that it is the right way to...

MySQL Administrator

MySQL Administrator is the new administration tool being developed which will eventually replace other administration tools provided for MySQL. The application is developed on top of Qt and is already quite nice. It includes user administration and sta...

Introduction to the MySQL Administrator

Notes from the Introduction to the MySQL Administrator talk at the 2004 MySQL User's Conference... (I initially wanted to go to the "High Availability Solutions with Databases" session, but it seems to be a big Sun product pitch. Bad move, Sun. You ses...

MySQL Administrator

Getting the afternoon sessions started with Alfredo Kojima talking about MySQL Administrator, a graphical tool for performing general administration in MySQL. For this demonstration the tool is pointed at MySQL 4.0, apparently is geared to work with re...

MySQL Conference - Day 2

JBoss and MySQL I'm sitting in Mark Fleury's session on MySQL and JBoss Integration . I'll try and record the things I learn in this session. The first thing that Mark mentions is how they own many popular open source projects: Hibernate, Tomcat, et

Extreme Website Scalability with JBoss and MySQL

Next up, Marc Fleury. The title of his presentation is Extreme Website Scalability with JBoss and MySQL. Marc begins by presenting JBoss's "Professional Open Source" mantra. There are currently 20 core JBoss Inc developers, however more than 500 people...

MySQL Attendees: Thanks for the iTunes

Thanks to everyone who's at MySQL 2004, on a mac with a collection of iTunes. I kept telling myself that I would go to bed early last night, but found that I couldn't resist going through the playlists available from...

InnoDB Multiple Tablespaces and Compressed Tables

Heikki Turri, creator of InnoDB, is delivering a presentation on the latest and greatest with InnoDB, multiple tablespaces and compressed tables. Heikki got a PhD in Mathematics in Helsinki, Finland. Innobase Oy founded in 1995, goal was originally to ...

InnoDB Multiple Tablespaces and Compressed Tables

Notes from Heikki Tuuri's InnoDB Multiple Tablespaces and Compressed Tables talk at the 2004 MySQL User's Conference... Heikki spent quite some time as an academic doing math and later computer science. He wrote the first line of code in 1994 and was t...

Day One Recap

Yesterday was mostly a blur to me, mainly because I kept waiting impatiently to get to the end of the...

MySQL Licensing Revisited

After I previously mentioned MySQL Licensing issues, Zak from MySQL A.B. invited me to attend the Licensing BOF this evening,...

MySQL and the ANSI SQL Standards

First MySQL 2004 session of the morning is Peter Gulutzan, going over MySQL and the compliance with ANSI SQL Standards. Last year Peter preannounced some of the things that were going to be done, this year announcing some of them...

MySQL Replication and Clustering

Notes from Brian's MySQL Replication and Clustering talk at the 2004 MySQL User's Conference... 3.23.xx had single threaded replication, 4.0 had dual-threads to implement read-ahead replication (trivia note: that was my idea). Understanding the control...

MySQL Replication and Clustering

Brian Aker, Director of Architecture at MySQL. This session is on MySQL replication and clustering. Brian is the author of mod_layout and Slash (Slashdot's CMS). Replication in MySQL is atomic and non-blocking. Current replication system is based on a ...

RSS Feed for the Blog Collection

Thanks to Scott Johnson of Feedster, we now have an RSS feed of all UC2004 related blogs at http://uc2004.vbmysql.com/index.xml so subscribe away!...

Open Source's Role in Transforming Society

This morning's MySQL 2004 keynote is by Brian Behlendorf, founder of collab.net. Has been travelling and speaking quite a bit recently, visiting a wide range of organizations and individuals about the use of open source software etc. According to the...

DBI Idioms

Giuseppe Maxia is speaking about DBI Idioms at MySQL 2004. The presentation is broken into three parts; connection, insert and fetch. It seems hard to believe that 30 minutes will be enough to cover any subject in detail, but here...

High Availability in MySQL Cluster

Pretty neat stuff. You can replicate clusters between two physical sites. Within each cluster you also have redundancy. So if a single node of a cluster fails you have an instant failover, if the whole cluster goes down you still...

MySQL Cluster High Availability Features

Notes from the MySQL Cluster High Availability Features talk at the 2004 MySQL User's Conference... Redundancy between nodes via heartbeat. Redundancy between clusters via replication. In other words, NDB provides local and global redundancy. System re...

Writing a Simple MySQL Storage Engine

Notes from Brian and Sergei's Storage MySQL Engine talk at the 2004 MySQL User's Conference... Brian recently added a stubbed out storage engine (table handler) to the MySQL 4.1 source tree. He's going to demonstrate a CSV storage engine that he's writ...

Protecting Private Information with MySQL

Listening to Peter Wayner presenting on Protecting Private Information with MySQL. This is a lab session, which means that there are computers in the room. Unfortunately there are only 5 computers and maybe 40 people in the room. The slides...

Crack-Proofing MySQL

Speaker: Aaron C. Newman Chief Technology Officer, Application Security, Inc. Aaron Newman is the Founder and Chief Technology Officer of Application Security, Inc (AppSecInc). Widely regarded as one of the world's foremost database security experts, A...

J2EE Performance Tuning Workshop

Next up, Mark Matthew's J2EE performance tuning workshop. So far Mark has given a basic rundown of tools used to analyze Java applications for performance issues. He is giving a rundown of different application server specific analysis tools. MySQL con...

Introduction to MySQL Cluster

Notes from the Introduction to MySQL Cluster talk at the 2004 MySQL User's Conference... First we're seeing an overview of the NDB architecture. If you've never seen it before, think "Oracle RAC without shared storage" and you're 95% of the way there. ...

Introduction to MySQL Cluster

Listening to Mikael Ronstrom's presentation on MySQL Cluster at MySQL 2004. Clustering softare originated in the telecom business. MySQL can use a new storage engine, which is the cluster with scalability and redundancy on three levels; number of appli...

MySQL User Panel: Why MySQL?

At MySQL 2004, observing a panel of MySQL users who are going to answer the question of why they chose MySQL. The panelist's are Michael Benzinger (Sabre Holdings), John Sudderth (Science Applications International Corp), Steve Stover (Quest Software) ...

Novell Keynote

Chris Stone of Novell. This is the first keynote of the afternoon, lets look at him bio from the MySQL AB site: Chris Stone Vice Chairman, Novell Chris Stone was appointed Vice Chairman, Office of the CEO, of Novell in...

MySQL/Innodb Performance

Next up is Peter Zaitzev talking about ways to optimize MySQL for best performance along with information about Innodb. The first part of Peter's presentation is about benchmarking MySQL. One of the keys to figuring out where query bottlenecks are...

Optimizing MySQL/InnoDB Performance

Peter Zaitsev is going over optimizing MySQL/InnoDB Performance at MySQL 2004. Not sure if I didn't get the organization of the talk, but having a hard time organizing it to be readable. Peter uses DBT2 benchmark, with either a large...

MySQL/InnoDB Performance Talk

Some notes from Peter's MySQL/InnoDB Performance talk at the 2004 MySQL User's Conference... DBT2 Benchmark, http://sf.net/projects/osdldbt. He uses 2.4.21 kernel, no swap, and the ext3 filesystem. Runs benchmark, checks status output (SHOW STATUS or u...

Registration and Opening Keynote

Of course the first day of the conference corresponds with a late cold front so it's a bit chilly outside. Chilly for Florida means in the 60's so anyone outside of Florida should be thrilled. Registrarion went smoothly. I am...

MySQL at Sabre

Michael Benzinger (Sabre Research Group) is speaking (at MySQL 2004) about the process of bringing MySQL into Sabre. Sabre sas originally a portion of American airlines, was the reservations part. American still owns, also includes travelocity. Sabre h...

MySQL State of the Dolphin

David and Monty are delivering the MySQL 2004 State of the Dolphin, also titled "From the Basement to the Enterprise" A little bit of history of the project, it's interesting that it wasn't until 1995 that Monty and David decided...

MySQL at Sabre

Notes from Michael Benzinger's "MySQL at Sabre" talk at the 2004 MySQL Users Conference. Sabre had been the reservation system for American Airlines. They're also the backend for Travelocity as well. Cost was the primary motivation for moving to MySQL....

Lower Rendezvous Quotient

At previous conferences I've attended (namely LISA and OSCON), there were a metric assload of Apple users on iChat/Rendezvous. OSCON...

Morning Keynote - David and Monty

The first session of the day is the keynote session with David Axmark and Monty Widenius, the founders of MySQL AB. The session is titled "From the cellar(garage) to the Enterprise" The history of the MySQL database started in the...

T-minus 6 Hours

4am this morning the front desk calls to inform me that my bag has arrived (I did tell them to call me when the bag came, regardless of the time). Thanks to an overactive mind I'm not getting back to...

Day 0 At the MySQL UserCon

Off in the distance I can hear the distant fireworks of Disney World's nightly show (accoridng to a well-timed commercial the show is called "Wishes"). I'm working on finishing up my slideshow while I wait for my suitcase to catch...

MySQL Users Conference, Day -1

Tomorrow is the first day of the Users' Conference. Jeremy abandoned me today so he could go flying a glider,...

fun at the user conference

Well here I am with an exciting temporary sub-blog. :) Tips for conference attendees: Wireless is good everywhere in the hotel, especially by the pool. The diner is 24 hours and the express window is the cheapest breakfast around. Watch...

Welcome to the 2004 MySQL Users Conference

Well, as you can see, the registration desk is open for the 2004 MySQL User Conference. The conference begins tomorrow and runs thru Friday. I'll attempt to use the hotel's reasonably good wifi coverage to post occasional pictures and summaries of wha...

High Performance MySQL is Hot off the Press!

If you happen to wander by The O'Reilly and Associates web site soon, you'll notice a new book featured in the "Hot off the Press" section of the home page: High Performance MySQL is an insider's guide to the poorly documented issues of MySQL reliabil...

Shuttle Discount

Looks like MySQL AB has secured a deal on an airport shuttle for those staying near the airport: http://www.mysql.com/news-and-events/users-conference/shuttle-coupon.jpg Looks like $4 off a $25 round-trip shuttle. Looks like it could still be cheaper t...

The Book Is Real

It looks like the debut of High Performance MySQL, the book Jeremy and I co-wrote, will be at the MySQL...

Sessions I Want To See

I'm really looking forward to this year's conference. I not only have people I am looking forward to meeting (again), and tons of swag to collect fro the trade show, but if last year is any indicator, there will be...

Who, me?

The latest MySQL AB press release is just frightening if you ask me... The preliminary schedule of sessions at the upcoming MySQL Users Conference and Expo 2004, April 14-16 in Orlando, Florida, is now online. It includes sessions from MySQL...

Speaking at the Conference

Well, it looks like I have been accpeted as a speaker for the 2004 MySQL User's Conference & Expo in Orlando, Floride. Last year's conference in San Jose was excellent, especially considering it was the first conference MySQL AB had...