This example will show you how to log your MySQL Proxy output to a log file rather than to the terminal.

An in-depth article that explains how to use MySQL replication for high-availability purposes.

An article describing some key aspects to keep in mind when adding more data nodes in order to gain more performance.

An excellent Q&A Session with insightful details about the PBXT Storage Engine

tutorial de mysql workbecnch

Video: Building a MySQL Slave and Keeping it in Sync At the Boston MySQL User Group Sheeri Cabral presented on how to get a consistent snapshot to build a slave, how to use mk-table-checksum to check for differences between masters and slaves on an ongoing basis, and how to use tools such as mk-table-sync and mysqldump to sync the data if there are any discrepancies. This link contains the slides and the videos

Author's announcement that the MySQL Bible, for beginner and intermediate MySQL DBA's, is available. The book is suitable for those completely new to databases, or those that are familiar with another RDBMS (such as Oracle or Microsoft SQL Server) and want to learn how MySQL works.

sar-sql name change, state of the software and road map.

This article shows you how to use MySQL Proxy to capture queries that cause errors.

This article will show you how to set up MySQL Proxy as a service on Windows. This will allow you to use "net start proxy" to start the proxy, and "net stop proxy" to stop the proxy.

This article describes the benefits of InfiniDB, which is a storage engine for MySQL that allows for data warehousing and database analytics.

An introduction on how to use XtraBackup to perform hot backups of MySQL

Mark Callaghan discusses the implications of using FLUSH TABLES WITH READ LOCK and what this command actually does.

Do you need MySQL High-Availability? How to determine which MySQL High-Availability solution is best?

OpenLDAP includes a driver that allows it to store and access data held in MySQL Cluster. It uses the NDB-API to access the database and so the performance is extremely good. One of the great things about the solution is that it lets you simultaneously access the same data through both LDAP and SQL (or the NDB-API or any of the MySQL connectors). This article gives an example of how this can be done.

A quick look at some strong points between InnoDB Hot Backup and Xtrabackup

Shlomi shows a real world scenario where the naive approach to monitoring fails spectacularly.

In my old post there is a bug when run in MySQL 5.1.30 and old, because the status variable Queries was added in MySQL 5.1.31. So i change to choose between Queries and Questions status variables, and I think the Queries represent more accurate result.

Sheeri explains, in practice, how to synchronize schemas using MySQL Workbench

Sheeri explains why turning on the query cache without thinking about the consequences is bad but also why simple benchmarks proving 'the query cache is bad' may be skewed