Having dual masters is useful, not just for redundancy/resilience, but also for regular maintenance purposes. Managing it is a bit more tricky, but the MMM can help.

Everybody knows that dealing with hierarchies in a relational database is awkward, and depending on your needs it gets ugly, or downright impossible to do quickly in SQL (lots of queries needed, etc).

What if...
- you could do such operations with simple single queries?
- you could have not only simple trees but also complex ones (multiple parents) ?
- you could have complex graphs for friend-of-a-friend or other structures?

From this presentation you will know how to create a scalable full text search solution with MySQL, how to tune MySQL full text search for maximum performance, how to integrate MySQL with external search solutions and much more.

Testing database application is hard enough when you have only one server. When you need to test performance and scalability by involving multiple servers, then you need either a lot of patience or a tool that can simplify your task.
Using MySQL Sandbox, you can install single or multiple nodes in one host. Combining that with Gearman, a client/server infrastructure for generic tasks, you can work on distributed servers easily, with little worry about the details.
No matter what language you speak, Gearman can meet your needs in C, PHP, Perl, Ruby, shell scripting, and several more.

There are many GUI applications to deal with databases and with MySQL in particular. But for die hard command line enthusiasts, who grew up with Linux, the shell prompt is still prince.
You would be surprised at the vast amount of operations that you can do from the command line. Running commands on several databases at once, filtering users, getting detailed metadata, transferring data from the operating system to a database and the other way around, creating scripts from database data, creating SQL commands from database data.

This talk will show you how to setup a cluster of MySQL servers that use the MMM software to create the ability to have Master-Master Active-Passive failover. An explanation of the software involved and the structure needed, as well as an in-dept overview of what is needed will be given.