I discussed that over at the ideeli Tech Blog: http://insatiabledemand.ideeli.com/post/18850015294/diagnosing-mysql-auto-inc-and-gap-locks

MySQL is the world’s most popular open-source database, and powers websites and applications of numerous leading and fast-growing organizations.


On March 12, we’re hosting the first Virtual Developer Day: MySQL at 9am PST to give you a one-stop shop to learn all the essential MySQL skills and the latest features in MySQL 5.6 GA. With a combination of presentations and hands-on lab experience, you’ll have the opportunity to practice in your own environment and gain more in-depth knowledge to successfully design, develop, and manage your MySQL databases.


Featuring speakers coming from Oracle’s MySQL …

Tungsten Replicator 2.0.7 enables new MySQL versions, provides better support for multi-master and parallel replication, and improves setup of advanced topologies. In the MySQL area, we have added the ability to replicate from MySQL into Amazon RDS instances, as well as initial certification for MySQL 5.6. 

There are several important new features for multi-master replication, including better

Inspired by long debates about differences in my benchmark results on MySQL 5.6, MySQL 5.5 and MariaDB 5.5 and MariaDB benchmark results, I've decided to start a series of articles helping people to reproduce various test cases and better understand some of fun stuff around.. ;-)

This article is fully dedicated to the MySQL 5.6/5.5 vs MariaDB tests.

So far, generally, when you're trying to understand a source of gap in performance results, you should try to start from the most simple case for both "solutions", "platforms", and so on.. For databases the most "simple" case is Read-Only (RO) workload, specially the OLTP RO workload which is fully cached by RDBMS buffers and no more depending on your storage …

SCaLE 11xand the MySQL community are excited to bring you a full day track covering MySQL content. This event will be held February 22, 2013 at the LAX Hilton.

Tungsten Replicator 2.0.7 was released today. In addition to a large number of bug fixes, this release adds several improvements for multi-master management, and support for Amazon RDS (as a slave).

While the Release Notes show a long list of improvements, I would like to focus on some of them that improve the handling of multi-master deployments.

When we released version 2.0.6, we added the first revision of the cookbook recipes in the build. That was still a green addition, which caused several bug reports. But since then, we have integrated the cookbook in our internal testing, making these recipes more robust and reliable. We are also planning to improve them and eventually …

MySQL 5.6 has arrived to a lot of positive press. The praise is deserved as there many great features and performance improvements. There have also been a few benchmark results from MariaDB and Percona that report performance regressions and now there is a lot of confusion. The confusion occurs because the result differences have not been explained. I think performance benchmarks can be extremely useful as long as the results can be explained. The corollary of this is that benchmark results are less likely to be useful the …

MySQL 5.6 has arrived to a lot of positive press. The praise is deserved as there many great features and performance improvements. There have also been a few benchmark results from MariaDB and Percona that report performance regressions and now there is a lot of confusion. The confusion occurs because the result differences have not been explained. I think performance benchmarks can be extremely useful as long as the results can be explained. The corollary of this is that benchmark results are less likely to be useful the more …

Installing Lighttpd With PHP5 (PHP-FPM) And MySQL Support On Fedora 18

Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on a Fedora 18 server with PHP5 support (through PHP-FPM) and MySQL support. PHP-FPM (FastCGI Process Manager) is an alternative PHP FastCGI implementation with some additional features useful for sites of any size, especially busier sites. I use PHP-FPM in this tutorial instead of Lighttpd's spawn-fcgi.

This article is the third in a series on data fabric design and introduces the fabric connector service design pattern.  The previous article in this series introduced the transactional data service design pattern, which defines individual data stores and is the building block for data fabrics based on SQL databases.  The fabric connector builds on transactional data services and is another basic building block of fabric architecture.

Description and Responsibilities
Fabric connectors make a collection of DBMS servers look like a single server.  The fabric connector presents what appears to be a data service API to applications.  It routes each request to an appropriate physical …