MySQL Users Conference & Expo 2004 Sessions

You can also view the schedule for each day.

"Mr. Widenius I Presume": A Guided Tour of the MySQL Source Code

• Michael Widenius, CTO, MySQL AB
• Brian Aker, Director of Architecture, MySQL AB
• Sergei Golubchik, Senior Software Developer, MySQL AB

Some tours are for tourists, while others are better suited to adventurers. This session falls into the latter category. Bring your pith helmet, a machete and a good C++ manual.
MySQL Senior SoftwareDeveloper Sergei Golubchik, MySQL Director of Architecture Brian Aker and MySQL Founder Monty Widenius are going to take you into the semi-charted wilds of the MySQL source code.
During the tour, they will show you how the major parts of MySQL are implemented. The important sections of code for each sub-system that is covered will be shown and discussed.
Attendees of this session will gain a clearer understanding of how MySQL behaves and may be able to modify MySQL to suit their own developmentneeds better.
This session is meant for advanced users who have a solid working knowledge of both C++ (or C) and database systems.

Administering Apple XServes

Learn how to administer Apple Xserve G5, Xserve RAID and Mac OS X Server. See how tools such as Server Admin and Workgroup managerwork in setting up file/print services, Apache and MySQL. Also learn how other customers use MySQL on Xserve to create a cost effective solution.

Advanced SQL Techniques for Analysis of MySQL Data

• Hemant Kirpekar

You have been using SQL for a long time. But have you noticed that if you are using complicated queries using SQL, the performancedeteriorates exponentially as the SQL complexity increases? The Query Optimizer can only take you so far. After a point it actually produces worse performing code than one could implement by hand.If you have been doing serious SQL programming for some time you must have stumbled on co-related subqueries and on self-joins. Both these SQL forms are extremely useful and necessary for analysis algorithms but are highly inefficient.Using Group By's and Having clauses with characteristic functions generated with a simple CASE IF..ELSE is much more optimal. This seminar shows how characterizing techniques can be used to produce "ugly" code, yet be: * orders of magnitude faster,
* allow for loop free execution* and eliminate the need to perform expensive 3GL operations.

It also shows why negative clauses such as "NOT EXISTS" are much more usefulthan positive clauses for in-depth analysis

The seminar provides several examples of table pivoting and folding and various types of report generations using characteristic functions among other techniques.

An Introduction to MySQL Administrator

• Alfredo Kojima, GUI Developer, MySQL AB

MySQL Administrator is a new multi-platform server management tool for MySQL. It provides an easy to use graphical interface to perform a multitude of maintenance tasks on MySQL servers, ranging from status monitoring and user privilege management to server configuration.
Furthermore, it's designed with a native look and feel, bringing comfort and a familiar looking environment to both Window and Linux/GNOME users.

This talk will present a tour of MySQL Administrator, showing how to perform key maintenance tasks. It will also present a overview of some of the other tools under development or planned to be part of the MySQL Administration Suite.

An Introduction to MySQL Cluster

• Mikael Ronström, Senior Software Architect, MySQL AB

Core MySQL Cluster developer MySQL Ronström introduces MySQL Cluster, going though the history of the database, the requirements of DBMS designed for the enterprise and telecom markets, and the features and performance metrics of the datatbase.

He will also discuss thearchitecture of MySQL Cluster, focusing on how the database is separated into separate nodes grouped into clusters for reliability, how failure is handled gracefully and the programming interfaces that are available.

» Downloads: gzip compressed Powerpoint 410 KB

Best Practices for MySQL Administration in an Enterprise Environment

• Aaron Werman, Principal, Database Administrator, Open-DB Solutions

This session will discuss best practices to effectively manage MySQL servers in the non-web space.

Best practices are bunches ofnorms that generally make systems safer and cheaper. We will briefly review system configuration guidelines and what best practices means.

The core presentation will review practices for space and performance management, object management and UDFs, security, replication, backup,recovery and disaster recovery.

The talk should be useful for both new and veteran MySQL DBAs, and will focus on MySQL 4.1.

» Downloads: gzip compressed Powerpoint 330 KB, gzip compressed PDF 739 KB

Best Practices: Using MySQL at Sabre

• Michael Benzinger

Sabre was the first commercial OLTP system in the world andis currently one of the largest. As we push the envelope of scalability, we are also replacing core OLTP systems with new software based on MySQL, Linux and other open source tools. Instead of creating front-ends to existing mainframes, we are placing MySQL at the heart of our transaction processing infrastructure.

Our new low-fare and schedule search application runs on a large cluster of Itanium servers and replaces legacy hardware and software. This application is behind a number of travel web sites, most notably Travelocity.
Our system is based on heterogeneous data replication using MySQL and Golden Gate Software's Extractor-Replicator tools. This architecture allows for synchronization of MySQLwith legacy databases and transparent migration of functions, avoidinga "knife-edge" cutover.

We operate a true 7*24 system, with no scheduled downtime and customers worldwide.

This session will describe the overall architecture of the project, as well as lessons learned during the prototyping, development, testing and operations of the system.

During development, we built tools to ease migration proprietary ESQL code to MySQL and we are preparing to release this code to the open source community.

Finally, where do we go from here? What is needed for MySQL to replace more of our mainframe systems? And what do our internal finance people have to say about all of this?

BoF: Ask the Connector/J and J2EE Experts

• Mark Matthews, SW Development Manager - Windows and Java Platforms, MySQL AB

This is your chance to meet and ask the Connector/J and J2EE experts that burning question you have.  Share your experiences using Java and MySQL.  And, tell us what we need to do to make it even better!

BoF: Mac-envy BoF

If you have coveted a G5 or lusted over the shiny new features of Panther, drop into this BoF for a taste of all-Mac goodness.

BoF: MySQL Mac Users

Mac users, this is your chance to learn handy Mac OS X + MySQL tips from your peer and to get a better look at the new G5's.

Building Web Survey Instruments Using QPL

• Kevin Dooley

QPL (Questionnaire Programming Language) is a web survey development platform created by GAO and made available to the public for free at http://www.gao.gov/qpl.

Questionnaire authors write their questionnaire in the QPL language and then use the software to generate allthe PHP, MySQL, HTML, and ActiveScript files needed to run the web site. An email system is integrated into the site that lets you send individualized HTML-formatted email messages to each respondent as well as target messages to non-respondents. And other online administrative toolslet you view summary statistics about the survey, administer respondent accounts, and export the data for more detailed analysis with SAS, SPSS, askSam, or other analysis software.
GAO has used this software over the last two years to complete over 200 web survey projects, with the number of respondents ranging between 50 (for fifty-state surveys) to over 20,000 (for a survey of all the faculty and students at the three U.S. military academies), asking between 5 and 1,400 questions, though most ask 200-300 questions.

Combining MySQL, Apache and Linux with C# and Visual Basic to build web based applications

• Jim Abbott, Senior Product Manager, Novell, NetWare & Novell Linux Services

Mono is an open source technology sponsored by Ximian and Novell that allow open source developers to leverage technologies that have traditionally been associated with Microsoft.net and Visual Studio.
Once these components have been designed and built they can be deployed against the most popular open source componets available including Linux, MySQL and Apache. This session will provide attendees with the opportunity to observe how simple web components can be designed and built using C# and Visual Basic. No windows machines will be injured in creating this demo. There will also be no .ASP extensions allowed.

» Downloads: gzip compressed OpenOffice.org Impress 405 KB

Connecting Data to MySQL: Writing a Simple Storage Engine

• Brian Aker, Director of Architecture, MySQL AB
• Sergei Golubchik, Senior Software Developer, MySQL AB

Have you ever wanted to extend MySQL in strange and wonderful ways? Many people do not realize that a powerful and flexible API fordoing this (via binding new storage engines like InnoDB and MyISAM intoMySQL) already exists. In this session, Brian Aker will walk you though the process of writing a simple storage engine and binding it into MySQL.

Along the way, you will also learn some interesting things aboutthe implementation of the existing storage engines and the overall design of MySQL.

This session will be most useful to you if you have strong C/C++ skills.

Connector/J - Stored Procedures, Server-side Prepared Statements and Character Sets

• Mark Matthews, SW Development Manager - Windows and Java Platforms, MySQL AB

MySQL Connector/J developer Mark Matthews will cover the newest features in Connector/J 3.1.x, including how to use Connector/J with Stored Procedures (new in MySQL-5.0), Server-side prepared statements (new in MySQL-4.1) and Unicode character sets (new in MySQL-4.1).

This session will also include a discussion of the most efficient method of using these features, along with incremental improvements in connection pooling, multiple result set supprt, profiling and other performance and scalability features in the latest release of Connector/J.

» Downloads: gzip compressed Powerpoint 83 KB

Converting MSSQL and Access Databases to MySQL

• Mike Hillyer, Webmaster/Author, vbmysql.com

MySQL is becoming increasingly popular on the Windows platform as more software developers see the benefit of MySQL's dual licensing and open development model. As more developers become aware of the benefits of moving to MySQL there is an increasing need for developers who can migrate existing applications to MySQL from other
RDBMSes.

In this session Mike Hillyer will cover the basics of converting an application based on Microsoft SQL Server or Microsoft Access to MySQL. Topics will include business considerations, migration planning, data conversion tools, and special considerations when migrating including differences in date formats and SQL syntax.

Examples will be given through casestudies of recent migration projects involving both Microsoft SQL Server and Microsoft Access.

» Downloads: ZIP compressed Powerpoint 83 KB

Crack-proofing MySQL

• Aaron C. Newman, Chief Technology Officer, Application Security, Inc.

MySQL databases are a common point of attack because they typically hold the most valuable information for an organization. Because of this, locking down your MySQL databases is critical.

This presentation will cover how a cracker approaches your database, the most common attacks, the most successful attacks, and how to prevent yourself from ending up as a victim.

Securing your MySQL server involves properly configuring the database, educating your developers, and developing your applications to access the database securely.

We will cover attacks such as SQL Injection, password brute-forcing, buffer overflow, and privilege escalation.

Attendees will learn:
1) How attackers attack a MySQL server.
2) How to securely install and configure MySQL.
3) How to securely write applications for MySQL.

» Downloads: ZIP compressed Powerpoint 92k

Creative Commons BoF

• Zak Greant, Community Advocate, MySQL AB

Come join the few, the brave, the rather tired as we discuss why the MySQL Users Conference has tried to have much of the conference content licensed under a Creative Commons license and how this benefits not only our attendees, but many others as well.

MySQL CommunityAdvocate Zak Greant will get the discussion going with the following questions:
* What is the Creative Commons?
* What are the Creative Commons licenses?
* What is the effect of placing a work under a Creative Commons license?

DBI Idioms

• Giuseppe Maxia

DBI is the de facto standard for Perl database management. Exchanging
complex data structures between client and server is not always easy.
Using the DBI, there are dozens of idioms to send and receive data in
arrays, hashes, arrays of arrays, arrays of hashes, and so on.
Knowing DBI idioms can make your applications shorter, faster, and
easier to manage, not to mention semantically clearer.

» Downloads: gzipped tarball containing PDF and text files 438 KB

Data Warehousing with MySQL

• John Paul Ashenfelter, Transitionpoint

MySQL is ready to take a serious role in the data warehouse. With it's speedy execution, extensive set of built-in functions, and solid data import capabilities, it has all the relevant features of competing proprietary tools such as Microsoft SQL Server and Oracle.
In this session, we'll take a look at the specifics of how to use MySQL in your data warehousing and reporting infrastructure, including details about MySQL table and data types, data import techniques, and the impact of MySQL 5.0 on data warehousing.
This session is aimed at developers and technical managers who have some MySQL experience.

Discovery Cove Dinner and Beach Party

Immediately following the Happy Hour on Thursday, board the buses at the Peabody Hotel for a five minute ride to Discovery Cove, one of Orlando's primary featured attractions. Once you get there, kickoff your shoes and relax at the MySQL and Intel beach party.

The beach party comes complete with white sand beaches, tropical jungles, live music, an open bar and all the fabulous food you can eat.

This should be an unforgettable evening of fun and relaxation - compliments of Intel and MySQL.

From SAP DB to MaxDB

• Jörg Hoffmeister, Development Manager, SAP AG

MaxDB by MySQL is a re-branded and enhanced version of SAP DB, SAP's open source database. MaxDB is a heavy-duty, SAP-certified,open-source database that offers high availability, scalability and a comprehensive feature set.
MaxDB complements MySQL AB's flagship MySQL database, extending the company's market reach to large mySAP ERP environments and other applications that require maximum enterprise-level database functionality.
This session will tell about the history of the product, about its positoning and the future scope.

» Downloads: Powerpoint 1.5M

HP: Open Source for Mission Critical Deployments

• Mike Balma, Linux Business Strategist, Hewlett-Packard Company, HP Linux Strategy and Planning

Using open source technologies, companies and governments are cutting costs and discovering new ways of creating value. Come hear how HP is using open source technology including MySQL in products and services. And learn how HP is delivering open source solutions including MySQL to solve IT issues in business and government. HP will share experiences with deployments, integration, support and licensing. And HP will provide insights to the future direction for open source architectures.

Hands-On Database Design Workshop

• Jeremy Cole, Training & Consulting Manager, MySQL AB
• Jeremy Zawodny
• Lenz Grimmer, Senior Production Engineer, MySQL AB
• Sergei Golubchik, Senior Software Developer, MySQL AB

Get hands-on database design training with MySQL developersand expert trainers.

In this session for intermediate database administrators and developers, you will learn how to optimize your schemas,normalize tables and analyze your queries.

With the information learned in this session, you can increase the performance of your application while reducing the storage requirements.

Happy Hour Reception

After the second day of sessions, MySQL and the exhibitorswill host a "Happy Hour x 2" from 5:15pm - 7:15pm on Thursday, April15th. Come, relax, network with friends and business associates as you unwind in our two-hour "Happy Hour" inside the Exhibit Hall.

High Availability Solutions with Databases

• Garima Thockchom, Product Line Manager, Sun Microsystems, Availability Marketing

The session details popular High Availability solutions deployed with databases - data mirroring, clustering for automatic failover, disaster tolerance, etc. The session also highlights emerging advances in database high availability such as global file systems, metro clustering, prioritized service management, and disaster tolerant solutions. The session will close with a demonstration of the Sun Cluster highavailability solution for MySQL database.

High Availability in MySQL Cluster

• Lars Thalmann, Software Engineer, MySQL AB

Core MySQL Cluster developer, Dr. Lars Thalmann, will discuss the mechanisms used to safegaurd data stored in a MySQL Cluster.

The mechanism he will cover, include:

1. Node Recovery
If database process fails (due to hardware or software faults), the process is restarted (if the hardware allows it)
in the background while the database system is still online.

2. System Recovery
If all database process fails, the whole system is restarted
from the system logs.

3. On-line Backup
Backups can be taken while the system is running.

» Downloads: gzip compressed Powerpoint 14 KB

InnoDB: How to Take Advantage of InnoDB's Multiple Tablespaces and Compressed Tables

• Heikki Tuuri, Founder, Innobase Oy

A major new feature in MySQL/InnoDB-4.1 is multiple tablespaces. You can now configure InnoDB to store each table individually intoits own .ibd file in a database directory of MySQL. A problem in the old single tablespace model is that the tablespace never shrinks, that is, you cannot free disk space to the operating system, even if you dropwhole tables. Multiple tablespaces solve most of this problem. They also make it possible to restore tables individually from a backup. In the future, we will add a tablespace reset operation, which will make it possible to move .ibd files between MySQL installations, a feature whichusers of MyISAM like.

MySQL/InnoDB-5.0 introduces a new InnoDB tablestorage format, which saves approximately 20 % of space compared to the old format. All new tables will be created in the new format. We also intend to implement an on-the-fly zip compression of InnoDB tables. The compression can be enabled on a table basis, and it is transparent for the user: the tables can be read and written like ordinary tables. The zip compression will save about 50 % of the disk space usage. We may alsointroduce a zip compression of pages in part of the InnoDB buffer pool, which would allow to save almost 50 % of main memory usage as well. The downside of compressed tables is increased CPU usage when scanning tables.
We will also discuss some smaller new features expected to ship in MySQL/InnoDB-5.0 during 2004.

Inside LiveJournal's Backend

• Brad Fitzpatrick, President and CTO, Danga Interactive

LiveJournal.com is a fully-dynamic community system and blogging platform with 1.7 million accounts and growing, a million of which are active.

Come learn about the evolution of LiveJournal's backend, from the early days when it ran on my personal server, to when I could barely afford two servers, to the 50 or 60 we have today.

Discover all the problems we came across along the way, and where you're going to hit bottlenecks. Learn how we identify hot spots and how we go about fixing them.

I'll discuss the Perl modules and programming techniques we use to manage all our servers and make our lives easier, including our DBI::Role module which lets us modifying the weight of MySQL servers in a pool an distribute connections automatically.

Everything inLiveJournal in generated on the fly, since nearly any item on the sitegenerated by users can have arbitrary security restrictions placed on it, and each page is generated specifically for the remote user viewing it. Learn how and why we do this.

We'll also discuss our Open Source 'memcached' server, a high-performance distributed in-memory object caching system, and how it can be used in complement with MySQL to get even better performance out of your dynamic web apps.
I'll discuss how to get best performance out of MyISAM, and when you should use InnoDB, and how we use both effectively.
I'll discuss our replication setup andhow we do maintenance on servers easily while maintaining high availability.

I'll discuss our experiences with using the filesystem vs. the database, and when we use each.
I'd also like to briefly skim over issues such as effectively dealing with a huge community, including a hugevolunteer base, how to keep everybody happy, internationalization issues, automatic database schema upgrades from development installs to production, etc.

» Downloads: PDF 375k, OpenOffice.org Impress 106k

Integrating MySQL, Apache and Tomcat inside the Eclipse framework

• Jim Abbott, Senior Product Manager, Novell, NetWare & Novell Linux Services

Jim Abbott from Novell discusses how the company is workingto integrate MySQL, Apache and Tomcat as deployment engines inside of the Eclipse framework.

This work provides views within the Eclipse IDE that support C++. Perl, PHP and Java code.

All of this is then enhanced by dynamic web updates (sample files, code walkthrough, specific software development kits) delivered over the Internet along with RPMtechnology on the backend to deliver the most up-to-date infrastructurecomponents to the developer's desk.

The demo focuses on using MySQL on the back-end while building quick little Java and PHP scripts to retrieve information from MySQL and deliver the content to the web.

Intel Processor Trends and Roadmap

• Kevin Smith, Director, Intel, Software Products Division

Kevin J Smith, one of the directors of Intel's Software Products Division, gives an overview of Intel's recent work with MySQL along with processor trends and a roadmap for future work.

Some of thespecific topics include:

* Multi-threading "everywhere": hyper-threading developments in IA32 and Itanium.

* What to do about the increasing gap between slow memory and ever faster CPUs?

* Multi core trends and implication for programmers

* Intel and MySQL AB collaboration

* Using a database to improve databases

* An overview of software development tools to write high performance applications.

Is Open Source Better then Commercial Software?

• Jasper Kamperman, Senior S/W Inspection Consultant, Reasoning

Proponents of Open Source software have long claimed that their code is of higher quality than the equivalent commercial software.Opponents of Open Source argue just the opposite: that Open Source software is inherently unreliable. There is little independent, objective data available to support either view. This session takes an inside look into how Open Source and commercial software compare and serves to answer the question - Is Open Source better?

Because the Open Source modelrepresents such a fundamentally different way in which software is developed, sold, and maintained, it encourages activities that are not common in the development of commercial code. During the session, the speaker will examine some of these activities, compare the activities to the commercial software development approach, and elaborate on their impact on the resulting code quality.

The speaker will then address Open Source enthusiasts claim that the Open Source model produces better quality software than commercial software development. He will put this theory to the test through the presentation of objective, third party reports based upon several recent software inspections of Open Source code, including MySQL v4.0.16 Apache v2.1, Tomcat v4.1.24 code and the Linux TCP/IP stack. The speaker will share with the audience specific metrics of each software analysis and details of the defect reports.

The audience will learn the following from this presentation:
- The defect density of the Open Source projects reviewed and why this is an importantmeasure of code quality
- Learn about the benefits of peer reviews - acommon development step with Open Source code
- Metrics for several studies that compare Open Source code to commercial code and explanations behind the variances and findings

» Downloads: Powerpoint 516k

Keynote: Enterprise Adoption of Open Source

• Chris Stone, Vice Chairman, Novell

Chris Stone, vice chairman-office of
the CEO at Novell, will deliver a keynote address titled "Open Source in the Enterprise" that will provide a perspective on the growing
acceptance of open source software as a strategic component of a
corporate computing infrastructure. Stone is a noted technology
visionary, with more than twenty years of experience leading industry
innovation. Working with and around open source and technology since
1997, Stone has been instrumental in Novell's recent acquisitions of
SUSE Linux and Ximian.

Keynote: Open Source's Role in Transforming Society

• Brian Behlendorf, Founder and CTO, Collabnet

The software is falling into place - databases, app servers, even the
desktop are now spaces where Free, Libre, and Open Source Software is
competitive with the commercial alternatives. But how widely is it
really being used, and how quickly might it grow? Changes in the world
economy are making FLOSS solutions much more attractive. Will it change
the nature of software development inside companies? Isthere a broader
set of motives for FLOSS besides saving money and killing monopolies?
There are. I'll talk about them.

Keynote: The State of the Dolphin

• David Axmark, VP Community Relations & Internal IT, CoFounder, MySQL AB
• Michael Widenius, CTO, MySQL AB

Each year, MySQL founders David and Monty outline the current state of the MySQL community and the MySQL core development efforts in their popular "State of the Dolphin" talk.

Some of the main topics of the address will include the cool new things that have been going on with MySQL 5.0, along with the work that has been done on the MySQL Cluster product.

For an overview of what is happening on the businessside of MySQL, attend MySQL CEO Mårten Mickos' "The State of MySQL AB" session.

Large Volume Data Transformation and Warehousing using MySQL

• Lars Samuelsson, Software Project Leader/Developer, Lentus

In this session we describe a set of transformations and their corresponding layers for loading data into a data warehouse. Standard SQL is used in all steps and queries are performed on whole sets of data. The features include historisation of data, placeholders for orphaned records, type checking, consistency control, duplicate count, model transformation and optimizations.

After extracting data from an operational system you are often left with relational, but not necessarily consistent data stored as text files with some kind of structure. However, for the purpose of doing analysis we need high data quality and performance, which is achieved through an efficient and consistent data model. The tables within it are our goal. In between the data is transformed and refined in several stages.

In the process the data passes through different layers of transformation, where each layer is represented with its own namespace using MySQL databases. To begin with there is atemporary layer containing tables that have a one to one correspondencewith the files. These are character based to ensure that no data is lost when reading the files into the database. Internal consistency and duplicate analysis is done here according to an XML definition of the model.

The next layer is the raw layer, which is similar in model to the temporary layer with the exception of being persistent and having types.For data that should be historised only those records in the temporary layer that are new or constitute changes to data in raw are moved. Type, model and range errors are flagged here and another duplicate check isperformed with respect to all data.
Within raw we should have a complete history of all data contained in the files with some extra metadata. The model is the same as the one implied by the data in the files. Having come this far could sometimes be enough, but since this model could be denormalized we take the process one step further and provide a mechanism for converting the data into a new model. This is also useful for substituting compound natural keys with simple surrogate ones and thereby increases performance. In order to do so a key lookup layer is introduced, containing the natural keys from the raw layer together with auto incremented surrogate keys. This layer is further used to produce surrogate keys from foreign keys in orphaned records, which ensures consistency.

The model in the key layer is the same as in our warehouse layer, which is loaded using a combination of data in the raw layer with the surrogate keys. The warehouse is in our case normalized according to 3NF,yielding efficient storage since data is not duplicated in the tables. However, when doing analysis we could utilize far better models when itcomes to performance. An optional final mart layer takes the data from 3NF to a star, snowflake or flat model.

» Downloads: gzip compressed Powerpoint 353 KB, Link to presentation at Lentus site

Lowering TCOs for SAP Environments with MaxDB

• Patrik Backman, Partner Manager, MySQL AB

The benefits of Open Source Software can now be further realized in the infrastructures for SAP environments. MaxDB is a scalable,secure and heavy-duty database, which is developed and optimized for the different SAP usage scenarios, and is now offered by MySQL worldwide. With MaxDB as the database for solutions like SAP, customers can receive significant benefits through decreased Total Cost of Ownership. Thissession presents the MaxDB product offering of MySQL AB, and examines the TCO benefits of the product through a real-life business case.

MaxDB - Easy Administration (Demo)

• Jörg Hoffmeister, Development Manager, SAP AG

During this session we will show how to manage a MaxDB database instance and along this will give an inside view on the concepts behind this enterprise open source database.

MaxDB by MySQL is a re-branded and enhanced version of SAP DB, SAP's open source database. MaxDB is a heavy-duty, SAP-certified, open-source database that offers high availability, scalability and a comprehensive feature set.

MaxDB complements MySQL AB's flagship MySQL database, extending the company's market reach to large mySAP ERP environments and other applications that require maximum enterprise-level database functionality.

» Downloads: Powerpoint 3.6M

Migrating SAP Systems - An Open Discussion of Risks and Rewards

• Helmut Spöcker, Consulting Manager, Realtech, Professional Service Organization

Helmut Spoecker will share his real-world SAP migration project experience and moderate a discussion that will address the following questions:

* What is the absolute risk (the worst-case scenario) that the migration could fail?
* What is our (REALTECH's/MySQL's) experience concerning project scope and budgets?
* Which hard- and software interfaces create the most difficulties?
* Will all software components work with the new platform/database (especially backup software, printing, proprietary interfaces like EDI)?
* How about business intelligenceproducts from SAP: I (the customer) have heard about difficulties and performance issues migrating these to MaxDB. What's your (MySQL's/REALTECH's) position/statement?
* Does MaxDB support SAP with UNICODE? Which encoding is used? Depending on this, what will be the potential increasein storage needed for UNICODE systems with MaxDB?

Migrating a SAP R/3 Installation to MaxDB

• Helmut Spöcker, Consulting Manager, Realtech, Professional Service Organization

This presentation goes through the lessons learnt from migration projects of SAP enterprise solutions to the MaxDB platform. A customer case describes how a typical project is carried out and what considerations are needed, in order to make the migration a success.

MySQL 4.1 C API: Using Prepared Statements and Cursors

• Konstantin Osipov, Software Developer, MySQL AB
• Peter Gulutzan, Software Architect, MySQL AB

This class takes you though the new MySQL C API, highlighting and discussing the binary protocol, the advantages of the new API and showing how to use cursors and prepared statements.

MySQL Certification BoF

• Luke Welling, Senior Web Developer, MySQL AB
• Laura Thompson, Lecturer, RMIT University
• Mike Hillyer, Webmaster/Author, vbmysql.com
• Kaj Arnö, VP Professional Services, Acting VP Software Engineering, MySQL AB
• Nils Valentin
• Carsten Pedersen, Coordinator of Software Development; Certification Manager, MySQL AB

Learn more about the MySQL certification program by talkingwith professionals who have taken the program.

MySQL Certification: Show Me the Money

• Carsten Pedersen, Coordinator of Software Development; Certification Manager, MySQL AB

MySQL certification gives developers a way to show employers and clients that they have top notch MySQL chops. This session provides an overview of what the certification is, what it means, how it is structured and how you can become certified.

MySQL Cluster Internals

• Lars Thalmann, Software Engineer, MySQL AB

TBD

» Downloads: gzip compressed Powerpoint 396 KB

MySQL Cluster Secrets

• Lars Thalmann, Software Engineer, MySQL AB

TBD

» Downloads: gzip compressed Powerpoint 46 KB

MySQL Clustering without changing your database or your application

• Kari Honkanen, CTO and Founder, Emic Networks
• David Stokes, Emic Networks

Emic Networks offers load balancing, high availability cluster software that does not require changes to the application or the database. This presentation will provide an overview of management of a MySQL cluster, synchronous replication of data across cluster nodes, andperformance benefits possible by using Emic Networks software.

MySQL Licensing BoF

• Zak Greant, Community Advocate, MySQL AB

MySQL community advocate Zak Greant will lead a discussion on the MySQL licensing policies and history.

To get the discussion started, he will ask and answer a few questions:

* what is the history of MySQL's licensing?

* briefly stated, what do the various licenses mean?

* what is the intent of the MySQL licensing policies?

* why did MySQL change from the LGPL to the GPL for its client libraries?

MySQL New Feature Workshop: Stored Procedures

• Peter Gulutzan, Software Architect, MySQL AB
• Konstantin Osipov, Software Developer, MySQL AB

A hands-on session in the computer lab the demonstrates theuse of stored procedures and then walks the students through some sample problems.

MySQL Replication and Clustering

• Brian Aker, Director of Architecture, MySQL AB

This talk will walk you through the steps you need to perform in order to set up clustering and replication with the MySQL databasefor web environments. Design patterns for clustering databases for Apache written web applications will be shown, and a general discussion on how you can optimize your resources for a web environment.

Like most things with MySQL, clustering and replication are quite easy to manage and with just a little help you can have your own solutions up and running in little time.

MySQL User Panel: Why MySQL?

A panel of MySQL users representing a variety of MySQL implementations, including a large Web application, a mission-critical enterprise application and a MySQL-embedded application, will discuss why they chose to use MySQL over other options. Factors such as the businessrationale, technology advantages and any internal** and competitive challenges to integrating MySQL will be explored.

MySQL Windows Users BoF

• Reggie Burnett, President, ByteFX, Inc.
• Mike Hillyer, Webmaster/Author, vbmysql.com

A BoF for Windows users, whether they are developing Windows applications against MySQL or running MySQL servers on the Windows platform.

Some of the topics that are likely to be discussed include:
* Using MySQL from within Visual Studio.NET and with the .NET framework.
* Using MySQL/Connector ODBC

MySQL and Character Sets

• Peter Gulutzan, Software Architect, MySQL AB

MySQL's resident SQL expert Peter Gulutzan details the state of his favorite obession - character set support - in his other favorite obsession, MySQL.

MySQL and JBoss Integration

• Marc Fleury, President and Founder, JBoss, Inc.

The first section of this presentation will be technology-focused, with topics to include EJBs, OR mapping technology with Hibernate and transparent persistence in Java. He will then focus on distributed data structures through cache on top of a MySQL OR-mapped back end. Next, he will discuss optimization strategies that enable developers to scale Java applications on top of the MySQL database.

The second section is an overview of the Professional Open Source model and how companies can achieve better total cost of ownership by leveraging the open source infrastructure stack and professional support offerings of MySQL andJBoss.

The last section is a case study of the integrated use of MySQL and JBoss in the Sterling Commerce Gentran Integration Suite.

MySQL and PHP: Best Practices

• Jim Winstead, Lead Web Developer, MySQL AB

This session, presented by MySQL webmaster and PHP core team member Jim Winstead, will look at best practices to adopt when developing Web applications using PHP and MySQL, including ways to avoid common performance pitfalls.

» Downloads: PDF 2.5 MB

MySQL and the ANSI SQL Standards

• Peter Gulutzan, Software Architect, MySQL AB

Over the last few years, MySQL AB has been been focused onachieving greater compliance with the official SQL Standard.

Our resident SQL expert, Peter Gulutzan, will discuss the ANSI SQL standard and what compliance means, before moving on to the progress that we havemade since last year and the remaining issues that need to be solved.

This session is targeted to users and developers who are interested instandard SQL.

MySQL performance comparison on RedHat linux, Debian GNU/Linuxand FreeBSD

• Massimiliano Stucchi, Partner, WillyStudios.com
• Guido Sintoni, WillyStudios.com

When talking about databases, we normally do not think about the underlying environment on which the application is running, but this can represent a great advantage or drawback if we consider that each programmer, the application developer and the operating system developer, have to focus on his own work and depends on the work of the other.The two components have to be fine tuned to smoothly work together. When WillyStudios.com had to decide which one was the best platform to deploy its work on, we tested each environment thoroughly. In this talk we are going to present the results showed by our survey and discuss which ones are the best methods to have higher performances from the same database environment on different platforms.

MySQL's Spatial Data Support

• Alexey Botchkov, Software Developer, MySQL AB

A class that teaches attendees how to use MySQL's spatial data support for their applications.

MySQL/InnoDB Performance Class

• Peter Zaitsev, Benchmarks Coordinator/Support Specialist, MySQL AB
• Lenz Grimmer, Senior Production Engineer, MySQL AB

This practical session supports the 'MySQL/InnoDB Performance Practice - Server and Schema' session.

Attendees will work with the MySQL benchmarks team leader to learn how to interprete performance behaviors, refine query plans and generally optimize MySQL performance.

MySQL/InnoDB Performance Practice - OS and Hardware

• Peter Zaitsev, Benchmarks Coordinator/Support Specialist, MySQL AB

MySQL's lead benchmarker will discuss and demonstrate how to optimize MySQL and InnoDB performance through tuning your hardware andoperating system configuration (such as different file systems, different kernels, different RAID options (blocks, RAID10 vs RAID5 etc))

» Downloads: PPT 224 KB

MySQL/Innodb Performance Practice - Server and Schema

• Peter Zaitsev, Benchmarks Coordinator/Support Specialist, MySQL AB

In this presentation, MySQL Benchmarks team leader Peter Zaitsev, will show how various MySQL server options and schema optimizations for InnoDB can effect performance.

The main purpose of this presentation is not to present generic recommendations, but instead to empirically show how changes to various settings can affect performance.

For example how much extra performance can you can get from a large buffer pool? What are the effects of the various innodb_thread_concurrency settings? What does innodb_flush_logs_at_trx_commit do to performance?

» Downloads: PPT 208 KB

OLAP4ALL

• Christoph Späth, Sales and Marketing Manager, EBM

The presentation will give an overview on EBM Software's approach to business intelligence and introduce the concept OLAP4All. A short product demo will give an impression on application looks and usage - the story is based on a simple IT cost allocation and controlling business case. The rest of the session will be a briefing on OLAP4All technology, with focus on the MySQL context concluding with an outlook on upcoming OLAP4All features enabled by MySQL technology.

» Downloads: gzip compressed PDF 721 KB

Open Source and Tools for Determining Effective Return-on-Investment

• Stacey Quandt, Principal Analyst, OSDL

The increased performance and functionality of MySQL enables
organizations to consider migration from existing database deployments. A motivating factor for MySQL is economics, however, with the variability of operating systems, and infrastructure there is no single answer to the question of what is the TCO and ROI of open source? This presentation will provide a framework for MySQL ROI and suggest tools to measure the costs of deployment and delve into the direct costs and benefits. End-user examples and success stories will be shared and as well as ways to calculate indirect value of open source software.

Open Source for the Masses: Lessons for MySQL from Mac OS X

• Dr. Ernest Prabhakar, Product Line Manager, , Unix and Development Platforms

With over 10 million users, Apple is talking the lead in making open source software like MySQL, Apache, and SAMBA available to the mass market. Dr. Ernest Prabhakar from Apple's Darwin team will discuss how Apple leverages Open Source technologies like MySQL to create compelling enterprise solutions, highlight customer success stories, and describe how innovative partners leverage Apple's Xserve G5.

Opening Night Reception

Hosted by MySQL and the conference sponsors, the exhibit hall is the perfect setting for the Opening Night Reception beginning at 6:00pm, Wednesday, April 14th. An array of fabulous food, open bar, and the informal opportunity to network with the many MySQL exhibitors is one of the highlights of the conference.

Protecting Private Information with MySQL

• Peter Wayner, Author/Consultant

Website managers must balance the need to provide customization with the responsibility to protect the private and sensitive information of customers. This talk will explore how some of the built-in encryption features in MySQL can create safe, strong and secure systems to guard against hackers and malicious insiders. It will begin with some simple examples and culminate with an extended example describing a website that offers all of the features of a highly-customized website like Amazon.com without keeping any personal information around. It will be theequivalent of having your cake and eating it too.

RDBMS Landscape – Key Industry Trends

• Guy Harrison, CTO, Quest Software, Inc, Application Performance Management

The relational database market - particularly in distributed environments - has undergone many significant shifts over the past five years and is expected to show increasing change looking forward. Thisincludes the increasing acceptance of open source database such as MySQL as well as the end of Oracle's dominance on UNIX and Windows platforms.In this presentation we will examine how the RDBMS landscape has changed in the last few years and speculate on how it will evolve into 2005 and 2006. We will look at the major technological innovations announced in future releases of MySQL and compare them with the technical directionof DB2, Oracle and SQL Server. Specific technologies discussed will include clustering, grids, stored procedures, autonomic "self managing" databases, management and development tools.

SAP Partnership and MySQL Development

• Kaj Arnö, VP Professional Services, Acting VP Software Engineering, MySQL AB

The MySQL partnership with SAP focuses on jointly developing the next generation enterprise database, capable of running heavy applications like SAP R/3. This session presents an overview of the partnership and the work being carried out on MySQL from an SAP perspective. The presentation also gives you insight into the status of the project andinto the work that lies ahead.

Setting up EAC on Mac OS X

Learn how to cluster your MySQL database instances using EMIC Networks EAC clustering software. This is a hands on lab where you will be able to investigate the management and performance of MySQL clusters on sleek Apple
Xserver G5 systems with live data on an EAC cluster. EAC clusters require
no changes to your databases or applications. This workshop is recommenced for all DBAs or system administrates looking for better performance or reliability.

Setting up EAC on Mac OS X

Learn how to cluster your MySQL database instances using EMIC Networks EAC clustering software. This is a hands on lab where you will be able to investigate the management and performance of MySQL clusters on sleek Apple
Xserver G5 systems with live data on an EAC cluster. EAC clusters require
no changes to your databases or applications. This workshop is recommenced for all DBAs or system administrates looking for better performance or reliability.

Simplify your Java Development with MySQL and AppFuse

• Matt Raible, President and Chief Architect, Raible Designs, Inc.

In this session, you'll learn how to get a MySQL/Java application up and
running in minutes. AppFuse is a starter web application that includes
support for MySQL, Struts, XDoclet, Hibernate, DBUnit, Canoo WebTest,
JUnit and Cactus. It also uses the Spring Framework for declarative
transactions and AOP.

» Downloads: PDF 596k

Speed, Flexibility, Security: The MySQL solution to a large-store XML dilemma

• Mariella Di Giacomo, Library Software Engineer, LANL, Research Library, Library Without Walls Team
• Beth Goldsmith, Library Software Engineer, LANL, Research Library, Library Without Walls Team

While MySQL databases have been used for years by the LANL Digital Library Development Team, it has been in the creation of our most ambitious project that we have truly recognized some of the unique strengths and features of MySQL.

The project -- development of a comprehensive database of scientific journal articles and citation information-- involves converting bibliographic metadata from 8 distinct data suppliers into a common XML format, enhancing the data with links between each of the 50 million articles and their 507 million individual references, and providing search and browse access to the data. In addition to the quantity of data to be managed, other challenges include maintaining flexibility, response time, reliability, fault tolerance, cost, and security. In general, XML data is nested and not normalized, while relational data is tabular, flat and normalized. However, the realization that our XML data is tabular and normalized allowed us to use a relational database for our solution.

MySQL was chosen for the following reasons:
1. Cost: MySQL is Open Source.
2. Speed: MySQL has proven to be fast, vital when handling links among 1,435,000,000 rows of interlinked data in 10 virtual tables.
3. Operating system flexibility: Sun Solaris offers the possibility of addressing up to 32 Gigabytes of memory while running the MySQL server at 64 bits, important for caching.
4. Data storage capabilities: We currently manage ~350GB of data; to limit individual table size, we take advantage of merged tables.
5. Fault tolerance: We use MySQL in production and as disk-based backup for ourdata.
6. Security: MySQL replication is used to protect and update ourdata; the master MySQL server runs behind a firewall, while slave servers access the data from outside the firewall, in read-only mode.
This presentation will give a brief description of the system architecture and will focus on the rationale for choosing MySQL and the optimizationsapplied to system components.

» Downloads: gzip compressed Powerpoint 2.5 MB

The Badger Project: Improving MySQL Performance on Modern Computer Architectures

• Christoffer Hall, PhD Student, University of Copenhagen

This talk will present the research results obtained in thecontext of the Badger project, a collaboration between MySQL and University of Copenhagen started in 2003. The goal of the project is to evaluate, and when possible, improve the performance of MySQL so that it leverages the potential of the underlying OS and hardware. The results obtained so far concern (i) the utilization of Linux asynchronous IO, (ii)load balancing on clusters of cloned MySQL servers, (iii) instrumentation of MySQL to monitor performance, and (iv) MySQL performance on Itanium-2.

The Evolution of MySQL at Yahoo!

• Jeremy Zawodny

In this talk, Jeremy will trace the growth of MySQL usage at Yahoo.
Beginning with the nearly invisible installs a few years ago all the way thru today's large mission-critical deployments, he'll talkabout the motivations for using MySQL, barriers to adoption (both technical and political), and--most importantly--the excellent results. Along the way we'll look at a few success stories to provide the sort of detail which may help to advocate MySQL usage in your own organization.

The State of MySQL AB

• Marten Mickos, CEO, MySQL AB

MySQL CEO Marten Mickos outlines the current state of MySQLAB.

Tony Perkins' Keynote

• Tony Perkins

Perkins will discuss the next economic boom that, this time, will be based on real-world value and will be centered around always-on driven business and consumer technology worlds. He will deliver an understanding of how technology and the Internet are changing the worldsof communication, business and entertainment. Perkins also examines the economic future of technology companies, highlighting trends and offering insight into the changes the current investment climate demands.

Tony Perkins is a pioneering media entrepreneur and a highly recognized opinion leader in the technology business and investment editorial world. He earned this distinction as the creator and editor-in-chief of Red Herring and the AlwaysOn network. He is also the co-author of the international best-seller The Internet Bubble: Inside the Overvalued World of High-Tech Stocks.

Using MySQL in a Japanese environment

• Nils Valentin

Japanese localization expert Nils Valentin will discuss theissues that surround storing strings from the various Japanese character sets (which are represented in double byte characters and/or UTF-8) inMySQL.

Topics of discussion will include:
- General introduction toAsian localization
- DMBS market shares in Japan
- introduction to the available character sets
- Import and export data
- troubleshooting character set problems
- dealing with character set issues on the server side, driver side and client side.

» Downloads: gzip compressed PDF 337 KB

Using MySQL with .NET

• Reggie Burnett, President, ByteFX, Inc.

This session covers using MySQL 4.0 and 4.1 from .NET by utilizing the ByteFX managed provider as well as the standard ODBC provider included in the .NET framework. The session will include detailed discussions of the following: 1. Use of the ADO.Net interfaces including prepared statements (4.1), internationalization (including Unicode) support, the new binary client/server protocol, connection pooling, and BLOB access. 2. Creating a Data Access Layer (DAL) to work with MySQL. This DAL enables the user the flexibility of switching providers or databases without rewriting the entire project. 3. Developing applications that leverage MySQL using the Mono framework (.NET framework available for Linux and other operating systems). An ASP.Net website running on Apache and using Mono and the open source ByteFX MySQL provider will be shown and discussed. 4. Review of the ByteFX MySQL Pro product. Thisproduct integrates into the Visual Studio.NET environment and allows viewing and editing of table data and structure. It also provides functions for importing and exporting table data in XML format. 5. The differences between using the ODBCClient provider and the ByteFX provider will be highlighted.

» Downloads: gzip compressed Powerpoint 412 KB

Using Qt with MySQL

• Trenton Schulz, Trolltech

This session is intended for those people who are interested in using Qt, the cross-platform C++ application framework by Trolltech, for their MySQL applications. Trenton Schulz from Trolltech Development and Product Management will be on hand present the latest developments and to demonstrate using MySQL and Qt together.

» Downloads: gzipped tarball containing PDF and text files 232 KB

Using Subqueries in MySQL 4.1

• Jeremy Cole, Training & Consulting Manager, MySQL AB
• Vikram Vaswani, CEO, Melonfire
• Oleksandr Byelkin, Software Developer, MySQL AB

MySQL developer Oleksandr "Sanja" Byelkin, MySQL trainerJeremy Cole and Prentice-Hall author Vikram Vaswani will teach you the basics of using subqueries in MySQL, including
- what is a subquery and how does it work
- subqueries in a WHERE/HAVING clause
- subqueries with the IN test
- subqueries with the EXISTS test
- subqueries in a FROM clause (derived tables)
- subqueries with INSERT and UPDATE queries
- subqueries inside joins
- performance impact of subqueries/rewriting subqueries as joins and vice-versa

Web Development with Bells and Whistles using MySQL

• Luke Welling, Senior Web Developer, MySQL AB
• Laura Thompson, Lecturer, RMIT University

Many web programmers already use MySQL. However, lots of these hard working programmers work to tight deadlines, are self-taught, and may never have experimented with some of MySQL's newer features.In particular, lots of programmers have not experimented with the special capabilities of MySQL's different table types. In this session we will look at how you can apply these features in the web development environment. We will discuss when and how to use the following features in the web environment:
- different storage engines
- transactions
- full text searching
- subqueries
The session will run in tutorial mode and will be aimed at programmers who are already using MySQL in a simple way and would like to learn more.

Workshop: Building MySQL Cluster-Aware Applications with Java and Connector/J

• Mark Matthews, SW Development Manager - Windows and Java Platforms, MySQL AB

Learn how to architect, develop and deploy J2EE applications that deliver high-availability, dynamic scalability, and high-performance using MySQL Cluster.  This session will cover Connector/J features and architectural patterns that can be used in concert with MySQL Cluster.

» Downloads: gzip compressed Powerpoint 94 KB

Workshop: MaxDB Hands-on

• Jörg Hoffmeister, Development Manager, SAP AG

This workshop will guide you through the installation and hands-on and interactive exercises. CDs with the Windows version of MaxDB will provided at the session so bring your laptops and experience the benefits of MaxDB for yourself.

Workshop: Performance Tuning J2EE Applications deployed on MySQL

• Mark Matthews, SW Development Manager - Windows and Java Platforms, MySQL AB

This workshop will cover a performance tuning methodology for J2EE applications deployed with MySQL. Topics covered will include performance measurement techniques to identify application server and database bottlenecks.  We will then address those bottlenecks by tuning application server and MySQL parameters, as well as query re-writing and applying appropriate indexes. The workshop will conclude with an overview of strategies for applying the measurement techniques in a continuous fashion to enable long term performance and scalability of the application.

» Downloads: gzip compressed Powerpoint 122 KB

Write Your MySQL User Defined Functions in Java

• Eric Herman, Developer

The "judf" module allows users to write java functions and execute them as part of SELECT, INSERT, and UPDATE statements.

The presentation will cover a brief overview of the C++ / JNI implementation. This will be followed by some examples using the interface. Finally, some thoughts about what's next, and questions.