A while back, I built some PPC64 (powerpc 64-bit) packages for MySQL. They were built on a POWER5 box, running Fedora Core 6, with glibc 2.5, using a Bitkeeper snapshot (public bkbits, 5.0.45 tag). All tests pass on ppc64, for what its worth. I’ll do periodic builds for Linux/PPC64 as and when its required (i.e. someone pings me or I need them for some reason).

Grab them from: ftp://ftp.linux.org.uk/pub/people/byte/mysql/

Hat tip to dwmw2 (for power5, bombadil) and Bryce (for ftp.linux.org.uk).

Technorati Tags: power, power5, mysql, linuxppc, …

After I wrote the post: How do I dump all tables in a database into separate files? I got emails from couple people asking how to import the individual table files back in to MySQL. First way to import each sql file created by the post is to import each file individually by [...] …

Bug ID: 6493264 Solaris libc should provide posix_memalign

At least it’s acknowledged as a problem :)

Although I now have to go and implement it in the NDB portlib.

I wish we could drop support for everything other than linux 2.6… would make this stuff a lot nicer.

It’s been a while since I said anything about the progress on the book. That doesn’t mean we are not still working on it, though. As Peter wrote a while ago, he is basically wearing the hat of a very advanced technical reviewer at this point. We’ve finished writing all the chapters from his detailed outlines. He has worked through about half the chapters, and I’m continuing to spend my evenings and weekends and holidays (yes, nearly all my free time – just ask my wife!

A little over a year since the project to write this book began, the MySQL 5.1 Cluster Certification Study Guide is now at long last available. It covers everything you’ll need to know to pass the Certified MySQL Cluster 5.1 Database Administrator exam, including MySQL Cluster Concepts, Architecture, Configuration, Deployment, NDB Internals basics, High Availability techniques, Security Issues, and more.

(It does not cover MySQL Cluster 5.1 Carrier Grade Edition, for the simple reason that MCCGE features are not part of the official mainline MySQL 5.1 release. However, those features will be part of MySQL 6.0 [yes, MySQL 6.0 is already starting to happen, and there are already some cool new Cluster, Replication, …

CouchDB got its own TCP port assignment from the IANA. Yeah! The latest release (0.7.2) already configures your default installation to use this port and the accompanying documentation and the wiki should be up to date as well. A big thanks to Noah Slater for taking care of the procedure.

Oh, and it is 5984.

I've been working with various databases for a number of years. In that time I've found there is plenty of documentation on various features but not much on how database modeling impacts performance. Some people say one should use a fully normalized data model with a few denormalizations that are required for performance reasons, but those denormalizations are never discussed. And Ralph Kimball has many articles and a book concentrating on the physical data modeling, but they are more of the "here is how you solve the problem" and they don't detail why his method works better.

I've always found this odd as the physical data model has a major impact on database performance. I want this to be more of the whys behind various physical data modeling options with some examples showing the magnitude of the performance differences.

The first goal of this blog (over a few articles) will be to show cases where a denormalized dimensional data …

Woo-hoo!

The words were written, reviewed, re-written, put aside while figuring out how to get them published, then taken up once again and finally delivered to the publisher.

Today, we finally got word of the happy news:

Starting immediately, you can pick up your own copy of the MySQL 5.1 Cluster DBA Certification Study Guide and get started polishing your skills for the Cluster DBA certification exam.

From the cover blurb:

Covering the Certified MySQL 5.1 Cluster Database Administrator exam, this study guide is the one authority to look to when you?re preparing for the test. The book teaches you all the concepts, principles, and techniques that you?ll need to know for the exam, with many practice questions and real-world examples to help you prepare for test day. The book is also an excellent reference guide for your …

I have complained about this IP protection blabla put forth by CLA protected projects previously. But I keep hearing the same (imho false) arguments that CLA's are a non issue. I was kind of shocked that neither the Zend nor the eZ Systems representative at the PHP Conference in Frankfurt was unable to display that he actually knows what is in their respective CLAs. One issue is the one-way OSS, where due to the explicit copyright grant required, it becomes hard to cherry pick OSS code. While thats annoying, the bigger issue imho is the problem of the patent grant clause found in all CLA's I have seen (which all seem to be derived from the apache CLA). I keep bringing up this point until people who push CLA's will finally stop repeating lies about them. Saying that single developers do not need to worry about getting sued over patent infringements is simply wrong.

Anyways, we …

Trying to make a good first few implementation iterations is hard and is sometimes made harder by specifications which are not minutely detailed. When the specification is vague, organic development sometimes seems to excel, partly because there is little or no worries about refactoring or redesigning as necessary. Trying to make something absolutely perfect on the first iteration is difficult,