There are various setups and solutions to solve the problem of having redundant mysql masters and scaling writes on them. MySQL Cluster can be an alternative. MySQL Cluster can effectively do what DRBD and MySQL Replication do in a HA MySQL setup. But better.

An introduction to Gearman (a client/server infrastructure for distributed workers) and its practical application to replication setup. By combining the ease of use of MySQL Sandbox and the flexibility of Gearman, you can ger remote replication setup with low risk of mistakes.

A collection of MySQL cartoons, featuring Sakila in several environments. Includes images for LAMP, Java, performance, Proxy, Forge, Security, University, Speaker, Writer, traveler, wizard, Summer of Code, and the Librarian.

This post builds upon the earlier article (Creating a simple Cluster on a single LINUX host) which explained how to install and run a Cluster where all of the nodes run on the same physical host. The single host solution is not great for a real deployment - MySQL Cluster is designed to provide a High Availability (HA) solution by synchronously replicating data between data nodes - if all of the data nodes run on a single host that that machine is a single point of failure. This article demonstrates how to split the nodes between hosts; the configuration will still be fairly simple, using just 2 machines but it should be obvious how to extend it to more.

The MySQL Librarian is a collection of community-generated and cross referenced content related to MySQL. It's a place where the community, collaboratively, builds and maintains MySQL content. This article is the MySQL Librarian manual. If the FAQ are not enough, look here!

Everybody needs sharding, and the Spider storage engine offers a nice solution, transparent to the final user, to implement sharding without losing track of usability.

A tip to kill a long lasting query without losing the current connection.

Refactory.org is "A wiki for useful code snippets", and it has a MySQL section.

The Partition Helper is a Perl script that converts some simple options into lots of partitions. Good for creating partitions on historical data.

Using, installing and working with MySQL on OpenSolaris. - Note that the video must be downloaded to be able to view it!

Are you starting a new software project? Don't reinvent the wheel. Before committing to some hand made procedure, you should really consider the combination of Bazaar and Launchpad. Handling the source code is not enough. A software project requires planning, defect handling, coordination between bugs and blueprints, a visual roadmap, and all the above in relation to your code branches. Don't forget about mailing lists, FAQ, documentation, which are integral part of a project. Whether you are participating to an existing project or starting a new one, Launchpad and Bazaar are a powerful combination for your productivity.

Tim Cook from Sun Labs explains issues and opportunities with locking in InnoDB. - 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!

This session describes investigations into performance and scalability of InnoDB when using the binlog for replication, focusing primarily on the replication master. The session will highlight tools and techniques used to reveal scalability bottlenecks within the MySQL and InnoDB code, approaches used to eliminate those bottlenecks, and current results. The discussion will focus on a current prototype patch that achieves substantial throughput increases for read/write workloads, and enables concurrent commits for InnoDB XA transactions. - Note that the video must be downloaded to be able to view it!

Richard Smith from Sun Labs explains how to code for multi-core systems.

Using DTrace with MySQL - current state, future prospects, and lots of examples

Allan Packer from Sun Labs outlines 2009 plans for improving MySQL performance on multi-core systems.

Using DTrace with MySQL - current state, future prospects, and lots of examples

Developing MySQL on Solaris requires you to install a suitable compiler and other tools, but you may be surprised to know that most of the material is there already, or easy to install if it's not. But even more so, there is a huge wealth of information that you can get about your application while it's running, both with and without using more traditional debugging methods. We'll cover setting up a suitable environment, where to find the things you need, and and how to make use of the process monitoring tools and debugging environment to get the best out of development on Solaris generally, and MySQL specifically.

This session will give you an overview about how to perform backups of a MySQL Server using file system snapshots. Lenz will explain the general procedure, Caveats and Gotchas with this backup technique and how to work around some of them. The talk will also introduce two very popular methods for performing the actual snapshots: Linux LVM and using ZFS snapshots. Other utilities suitable for creating snapshot are covered as well.