Looks like a great set of tools for MySql.

Quoted: Essential command-line utilities for MySQL (formerly MySQL Toolkit)

Quoted: However, it is also an extremely simple piece of software: all of the logic is client-side, there is no security model, failover, backup mechanisms, or persistence (albeit the last one is in the roadmap). But that hasn't stopped the developers from deploying it in all kinds of environments, and here are a few best practices suggested by Brian:

Some of the referenced blog posts are quite interesting, too.

Quoted: There are interesting posts these day about future of MySQL Replication by Brian Frank and Arjen. I think it very interesting to take a look at a bit bigger picture using framework from Innovators Dilemma and Innovators Solution.
...
All these requirements made traditional databases irrelevant for many web properties - too complex and too expensive to start with.

Drupal 6.0 was released today.

Quoted: These changes are evident in Drupal 6's major usability improvements, security and maintainability advancements, friendlier installer, and expanded development framework. Further, from bug fix to feature request, these issues follow-through on the Drupal project's continued commitment to deliver flexibility and power to themers and d

This is one installer for Apache, PHP, and MySQL. It also includes some applications such as Drupal.

Quoted: The Web.Developer Server Suite is a Windows-based Platform for the development, testing and deployment of PHP and MySQL websites and applications. Simplify development cycles with a consistent, standardized set of tools. Windows | Apache | PHP | MySQL

You can use this w/mysql to enable automatic recovery when a master fails.

Quoted: Heartbeat works like this: you tell Heartbeat which computer owns a particular resource (which computer is the primary server), and the other computer will automatically be the backup server. You then configure the Heartbeat daemon running on the backup server to listen to the “heartbeats” coming from the primary server. If the backup server does not hear the primary server’s heartbeat, it initiates a failover and takes ownership of the resource.

Relevant to us.

Quoted: This sample chapter explains how the Heartbeat package enables you to build an inexpensive system that will fail over a resource from one server to another.

You have to assume that there will be replication lag. Having said that, chopping up long queries into smaller ones (if using replication) is a good rule of thumb.

Quoted: And the final advice - do not assume very short lag time when planning your application. Having application which can adapt to lag time rather than break is very good idea. Especially it will be handy when you will be reaching replication capacity and will need to buy time to fix things, during which replication lag can be higher than normally.

Quoted: Today I would like to share practical example when you may use long primary key with value distribution far from sequential.
...
This table is getting much more reads than writes so transactional overhead of for writes is small price to pay for number of benefits - caching data and index in memory -so cached lookups are very fast, clustering by primary key