Beginner's Guide to Website Performance with MySQL and memcached Adam Donnison (Sun Microsystems) Download the slides in .ODP format at http://assets.en.oreilly.com/1/event/21/Beginner%27s%20Guide%20to%20Website%20Performance%20with%20MySQL%20and%20memcached%20Presentation.odp The description, taken from the official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7009 Memcached is a distributed memory object caching system that is getting a lot of press at the moment for its ability to provide a high-performance front-end for database applications. Sure, memcached can do wonders, but where is it most effective and what are the pain points? When a site grows the site administrator starts to worry about how to maintain performance as the hit count rises. Should extra hardware be thrown at the problem synchronisation issues start to rear their heads. Writing caching code is  []

OpenSolaris Web Stack (http://opensolaris.org/os/project/webstack) is an OpenSolaris project and community building an integrated stack of popular open source web tier infrastructure technologies such as Apache HTTP server, MySQL, memcached, PHP and Ruby On Rails optimized for Solaris platform. This session introduces OpenSolaris Web Stack, its status and future development including addition of newer technologies such as lighttpd, Varnish etc., as well as the ease of use features for developers and deployers. We will also be discussing an experimental web stack IPS package repository and it could be leveraged to build and make available popular end user applications such as Drupal.

Memcached, and how it fits into the typical MySQL environment. - Note that the video must be downloaded to be able to view it!

Memcached, and how it fits into the typical MySQL environment. - Note that the video must be downloaded to be able to view it!

There are many different ways of scaling up and scaling out using MySQL. You can take advantage of replication, DRBD, memcached, MySQL Proxy and many other solutions. This tutorial will take you through all of these solutions and their combinations to increase your database throughput.

There is a lot of buzz about Memcached and MySQL 5.1 and what it can do for your website. But how exactly do you go about setting it all up and write your code to make use of memcached? In this session, Adam Donnison will take you step by step through implementing memcached using real world examples in PHP from the MySQL.com website infrastructure.

The InnoDB storage engine has been modified to use memcached as a level 2 cache, the InnoDB buffer pool being the level 1. Important reduction of the disk load and performance boost has been observed. This opens a new way of scaling out MySQL.

The memcached Functions for MySQL are User Defined Functions (UDFs) that give you the power to interact with both MySQL and memcached in one place, giving you the ability to have read-through or write-through caching using a number of tricks, all without having to have caching logic in the application. Learn from Patrick Galbraith how to take advantage of these great new UDFs!