MySQL replication is often positioned as a solution to provide extra throughput for your database (especially when dealing with high numbers of read operations). What tends to be overlooked is how it can be used to provide high availability (HA) – no matter how much redundancy you have at a local level, your system remains at risk from a single catastrophic failure – loss of power, earthquake, terrorist attack etc. By using MySQL asynchronous replication to maintain a geographically remote copy of that data, service can be maintained through any single site failure.

How to copy InnoDB table to different database.

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

Mysqlconf 2009 talk about Kickfire

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.

In one of the servers we have an issue that happens to one of the servers that some items that have the status of "freeing items" and "Sending data" are just stuck there, causing a lot of locks on the server, and the load of the server drops to almost 0. The server then wouldn't restart, and the only solution is to kill the mysqld process, and fix the crashed tables that result from the kill.

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.

Lua script for Workbench to add relationships based on column names

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!

The title says it all, and the explanation is very interesting. The consequences of disabling binlog due to lack of storage are catastrophic. Entertaining and worrying at the same time.

Introduction to guaranteed data availability with Continuent Tungsten for MySQL. How to keep data available with automatic seamless failover, automatic slave promotion, avoid data loss, increase database performance and lower cost of data integration. Presented by Robert Hodges, CTO at Continuent.

Introduction to Continuent Tungsten for MySQL: increasing MySQL performance with advanced high performance parallel replication. Presented by Robert Hodges, CTO at Continuent.

This article describes the physical difference between the INT and BIGINT datatypes, and shows how selecting the correct datatype can provide a more space efficient disk storage for your MySQL Data.