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

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

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

Maximize your strengths, minimize your weaknesses. You can apply this approach to many things in life, I apply it to describing and using MySQL the product, and it’s components. The Query Cache like many features in MySQL, and indeed features in many different RDBMS products (don’t get me started on Oracle *features*) have relative benefits. In one context it can be seen as ineffective, or even detrimental to your performance, however it’s course grain nature makes it both trivial to disable dynamically (SET GLOBAL query_cache_size=0;), and also easy to get basic statistics on current performance (SHOW GLOBAL STATUS LIKE ‘QCache%’;) to determine effectiveness and action appropriately.

Mark Callaghan tests the query cache. "The query cache has had an interesting history with MySQL. I don't have much experience with it. I might want to use it in the future so I enabled it during a run of sysbench readonly on an 8-core server. The results are fascinating."

Informative post about backup and restore procedures, disaster recovery plans and load balancing tips.

Install isolated side-by-side MySQL instances right the first time with this time-saving virtual manager. Jeremy Zawodny tests MySQL Sandbox with a thorough description.