Includes: the link to the playlist for all 11 videos plus 11 individual links to each video: Spider: Sharding for the Masses - Giuseppe Maxia A Better mysqltuner - Sheeri Cabral (my session!) Getting acquainted with Apache Derby - Kristian Wagaan New kid on the block: The BlackRay Data Engine — Felix Schupp MySQL High Availability Solutions — Lenz Grimmer Bringing Master/Slave into the 21st Century using Tungsten Database Clustering — Linas Virbalas PBXT: Technology trends that affect your database — Vladimir Kolesnikov MySQL Proxy: a MySQL toolbox - Architecture and concepts of misuse — Jan Kneschke Galera Replication, multi-master synchronous replication for MySQL — Seppo Jaakola Panel Discussion: The OSS Toolshed Shootout Speakers and technologies: Sheeri K. Cabral - MySQL; Holger Klemt - Firebird; Felix Schupp - BlackRay;  []

Examples of bad queries from Sarah S., MySQL trainer.

Watch out for hostname changes with replication! a blog post with facts and figures

In the words of Sheeri: "At the January 2009 Boston User Group I presented a session on the new partitioning feature in MySQL 5.1. I go through how to define partitions, how partitioning makes queries faster, the different types of partitioning and when to use each type, and the restrictions and limitations of partitioning. The slides are available at http://www.technocation.org/files/doc/2009_01_Partitioning.pdf Notes: The partitioning part of the MySQL Manual is at: http://dev.mysql.com/doc/refman/5.1/en/partitioning-overview.html. The functions that are not allowed in partitioning expressions are listed at: http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations.html We also had an interesting development — according to the manual, an INSERT to a partitioned table that includes values that do not have a partition should insert all values up to the failure point. The example I used (and  []

MySQL now provides server snapshots (nightly builds). What criteria do they meet? What should they be used for? This article clearly explains.

MySQL 5.1.38 includes the InnoDB plugin. This article shows how to install the plugin, using MySQL Sandbox and the binary snapshots.

Creating a MySQL-plugin that can be used to create a function which can in turn be used in stored procedures.

Generate ascii pie charts using SQL only, based on any generic query.

SQL is not meant to generate graphics, for sure; but Shlomi sees some cases where generating non-tabular output can be desirable. He explains the basics of working SQL graphics: it is actually possible to do whatever you like.

inotify is a handy standard Linux kernel tool to track file access/writes under a live server.

How to simulate loads on MySQL servers using Proxy and MockLoad

We all love graphs. We all love SQL hacks. We all know the SQL hack which displays a character-based graph (example follows for those unfamiliar). But we all love horizontal graphs, not vertical ones. We are used to the X axis being horizontal, Y being vertical. Not vice versa. In this post I’ll present a SQL hack which rotates a vertical graph to horizontal. In fact, the technique shown will rotate any ‘textual image’; but graphs are a nice example.

Very insightful article about how MySQL Cluster achieves fault tolerance and high availability.

Presentation given at OSCON 2009 on Scaling a web application (mostly PHP/MySQL) and gives a framework for creating scaling profiles and capacity/scenario profiling for your web site. An overview of Application and Database scaling steps and considerations.

I’ve been working on various different MySQL related issues and maintenance procedures some of which have not gone according to plan. Here is a recipe that may help you avoid wasting a lot of time, especially if your database is large.

A quick introduction into MapReduce.

There is a cool option for mysqlbinlog for disabling the binary log when doing recovery using binary logs, namely --disable-log-bin. There are various ways for doing this.

Keeping good database backups is crucial because unpredictable disastrous events always occurs. In web-based business – backup is a critical component. There exist different open-source scripts, that could help to organize the database backup process in a customized and easy way, avoiding use of mysqldump (default MySQL backup tool). This article describes various open-source scripts that can help a newbie sysadmin to organize MySQL backup process.

The MySQL server is not really in the phone. It's accessed through a ssh connection. But it is cool to see nonetheless.

The Librarian goes mobile!