(Il Corra) In my replication environment I had a hardware failure on master host. A 4.5.GB table containing blob images wa corrupted, so I issued a REPAIR TABLE and the effect was to repair the table but also to reduce the number of rows: master table had just 41 rows less than the copies on the sla

(Eric Bergen) It’s a common practice to use MySQL’s auto increment feature for things like product ids or invoice numbers. While it always works when the system is first setup it can cause major headaches over time. The problems usually fall into one of three categories, dual master, test/staging se

(Xaprb) MySQL Table Sync efficiently finds and resolves data (not structural) differences between two MySQL tables, which may be on different servers. It offers two search algorithms to find the rows that differ, and several methods to bring the destination table into sync with the source.

(Brian "Krow" Aker) In 5.1 I modified the compression methodology in response to seeing some schema’s which were only seeing compression in the 50% range (which is low compared to what I had seen in most common cases). The main problem I identified was that the compression of rows with NULLS and lon

(Xaprb) A while ago I wrote about how to select the first, minimum, maximum or least row per group in SQL. This article shows how to solve this problem without subqueries.

(Jan Kneschke) As an exercise I wrote a proof of concept of a proxy for MySQL. It isn’t using any code from the MySQL Server, only some headers files. I only used the internals document and implemented the server-side protocol of it.

(Dathan) Every database that houses user generated content is a master in at least 1 pair within my environment. To make sure that id’s don’t collide we engineered around the auto-increment functionality or lack there of in mySQL-4.1. For the most part the auto-increment is externally generated.

(Oli Sennhauser) It is possible to use an active – active shared-disk cluster in MySQL in some cases. For doing this you have to fulfill the following requirements: • Works with MyISAM tables only. • POSIX-locking compliant cluster file system on the device (such as OCFS2 or GFS). • External lo

(Robin Schumacher) I live in absolute and abject poverty. No, I don’t mean financially – I’ve been blessed beyond what I deserve and MySQL pays me very well. What I mean is that I am utterly time poor. Isn’t it amazing how you can be so free in terms of lifestyle and yet have so little time to enjoy

(Brian Aker) I am a fan of using GUIDs as primary keys. They are database independent, object independent and I can either create them in my application or in the database (MySQL since 5.0 has had a UUID() function but since it does not replicate I don’t use it normally… this has been fixed in 5