MySQL Conference & Expo 2008 Tutorials

MySQL Workbench is a highly customizable tool to help you make your everyday job more efficient. This tutorial will show how to write configurable, flexible, cross-platform plugins (C++, Python, LUA). Read more.

MySQL 5.0 and higher versions support stored routines that are based on the SQL:2003 standard. The introduction of stored programs in MySLQ 5 has been a significant milestone of the MySQL language. This tutorial will offer a brief overview of the stored program language and focus on how to improve and tune stored programs. Read more.

A hands-on MySQL Cluster 5.1 tutorial where you'll install and setup MySQL Cluster (on your laptop) and learn about what it is, what it can do, and basic administration skills. Read more.

MySQL Proxy is a tool that can enhance existing MySQL server features and create new ones. This tutorial explains how to create new syntax, filter queries, and how to deal with multiple servers. Read more.

Is high availability on your agenda? Then this tutorial is a must. It's high-availability clustering on Linux with MySQL and DRBD in a nutshell. Read more.

Data Warehousing and Business Intelligence is gaining mission critical status in managing today's enterprise. It is critical that these datamarts are built on good foundation. This tutorial focuses on design principles and techniques to build a solid foundation for datamarts using MySQL. Read more.

In this tutorial, the developers behind MySQL Replication start by explaining the architecture and major replication concepts and then walk you through a configuration to show what you can do with it. Read more.

During this tutorial, attendees will get a detailed introduction into the MySQL UDF interface and will learn to write and deploy their own UDFs for both Windows and Linux platforms. Read more.

Bill Karwin has answered questions from SQL users for over ten years. Some techniques have emerged as widely used, but flawed, making them brittle, buggy solutions and create security or scalability risks in your projects. In this tutorial, Karwin describes SQL techniques that should be called antipatterns, illustrates their weaknesses, and offers better solutions. Read more.

Ask Bjoern Hansen will be covering the overall platform and architecture considerations involved in tuning applications from a holistic perspective. You'll be shown design scaleable architectures for dynamic, high-volume web sites. Topics covered include caching, scalable database design, replication, load-balancing, and architectural decisions derived from many years of experience. Read more.

Large MySQL deployments and Memcached go hand and hand. This tutorial details how to get started, the ins and outs of deploying Memcached as a key caching layer in your applications, and how to keep scaling. Read more.