Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost everytime LOAD DATA INFILE come into rescue. In this article we will try to understand some of the very common scenarios for loading data into MySQL Database.

InnoDB at 10,000 IOPS

The release of MySQL 5.5 has brought several enhancements. While most of the coverage went, understandably, to the semi-synchronous replication, the enhancements of partitioning were neglected, and sometimes there was some degree of misunderstanding on their true meaning. With this article, we want to explain these cool enhancements, especially the parts that were not fully understood.

Interesting article about some gotchas and things worthwhile knowing about MySQL's built-in replication system.

A useful introduction to using SIGNAL with triggers/stored routines.

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.