MySQL

Databases always grow. With partitions, MySQL 5.1 becomes an efficient and easy to use data warehouse. This session explains with practical examples how to create and use MySQL partitions and how they will increase your application performance. This presentation also covers the recent additions from MySQL 5.5

Implementing multi-master setups with MySQL is fairly trivial in basic terms, but for an effective environment much more is involved. There are some tools (such as MMM, Multi-Master MySQL Manager) that can help, but there's still a lot to think of and each deployment is different.
So why would you wish to bother, given all these complications? This session will discuss precisely that, as well as the tools and pitfalls.

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?

Most distributions ship MySQL with a configuration file that sees you running a server optimised for a system with 32MB of RAM. That was great in 1996, but these days your Nike+ shoes have more capacity than that, so it makes sense to optimise the configuration.

Are you using a stock MySQL installation to power your Drupals? Find out why you should switch to using the InnoDB storage engine and how to make it not suck with just a few basic tweaks.

At Open Query, we believe that it's wiser to help before trouble occurs, and to prevent it. Or in the words of legendary aviatrix Amelia Aerhart: to worry is to add another hazard.