In response to Eric Day's post on "Eventually Consistent Relational Database?"... I started posting a comment there, but I realized I have my own blog for this sort of thing. :)

I've been thinking the same thing, it's nice to hear I'm not the only one. This is a neglected area of "cloud" development, mostly because it's a big scary problem. Everyone says "use NoSQL", but if we had strategies/systems to give us EC RDBMS solutions, nobody would use key/value storage (except where it actually made sense). NoSQL is a big golden hammer nowadays. It works, but it sure takes a lot of effort to code stuff the storage layer should be able to handle (joins, etc.).

read more

We have lots of things on the go right now (over and above the normal process of keeping things up to date), and one of the main projects for me is to do a complete rebuild of the installation chapter (Installing and Upgrading MySQL). I’ll be starting with the 5.1 manual, then the 5.4 manual. Any future manuals should be based on these so we should be up to date for future generations.

What I’m doing:

• Re-structuring the chapter to make it easier to follow on a platform basis. The old structure mixed content for different binary and source types, and different platforms, across a number of sections, making it very difficult to follow the instructions for your chosen platform.
• Make some things generic. There are sections which are generic and apply to all (or at least many) different installation types.
• Make …

Today I made a presentation to 100+ audience mostly comprising of DBAs and software consultants about MySQL Architecture and Solutions. You can download the presentation slides. This focuses on architecture overview of MySQL products and solutions.

Dear Community,

As of today the 19-th build of MySQL server with Percona patches is available.

Comparing to the previous release it has following new features:

• The build is based on MySQL-5.0.86
• Fix from Neil Katin to userstatv2.patch
• fix InnoDB slowness with large queries

Fixed bugs in the build:

• Bug #413858 in Percona patches: “Crash from failed assertion in dict0dict.c”

You can download binaries and sources with the patches here

…

Dear Community,

We are glad to present you release 8 of XtraDB.

The release includes following new features:

• The release is base on 1.0.4 version of InnoDB plugin. We thank Schooner Information Technology for sponsoring and testing the port of XtraDB to 1.0.4
• MySQL 5.1.39 as a base release

Fixed bugs:

• Bugs#413858: Crash from failed assertion in dict0dict.c
• Bug#417751:
  XtraDB crashes on startup on windows
• fix-import-extern-pages
• Number of mysql-tests are fixed

The builds for RedHat4,5 and Debian are located on …

I just accidentally deleted all comments made on this blog.

This blog is homegrown and hand-made. It has a very simple spamfilter that catches most spam comments. The few that make it through though, I've been deleting myself using the mysql console.

I tend to write simple queries, ending in: .. AND id = 1234, but today I forgot the id =. I had a backup from October 2008, so some old comments are back now, but I'm still pretty sad.

Lesson from today: make backups! I'm pretty good with things I do for clients, but I tend to not uphold the same standards for my own projects.

Today I made a presentation to 100+ audience mostly comprising of DBAs and software consultants about MySQL Architecture and Solutions. You can download the presentation slides. This focuses on architecture overview of MySQL products and solutions.

Today I made a presentation to 100+ audience mostly comprising of DBAs and software consultants about MySQL Architecture and Solutions. You can download the presentation slides. This focuses on architecture overview of MySQL products and solutions.

Spinn3r will be hosting an Open MySQL meetup at Oracle Open World (which is right down the street).

This would be on Wed 10/14 2009 at 7pm … at 580 Howard Suite 301 (Spinn3r HQ)

Oracle owns MySQL, InnoDB, etc so I suspect a lot of Oracle people and MySQL hackers will be interested in attending more of an Open Source and community centered meetup.

We’ll just be hanging out at our offices … we’ll have beer and food.

Feel free to bring your laptops as we have Wifi :)

This is contingent on at least 10 RSVPs as I want to make sure there is interest from the community.

Please RSVP here

It’s a bit late notice so if you could help spread the world by blogging about this that would be GREAT!

…

It’s worth noting that Red Hat Enterprise Linux (RHEL) 5 has had an update to MySQL in the last month. This naturally means that CentOS 5 also had a similar update. It’s now bumped up to MySQL 5.0.77 (goodbye 5.0.45!; which is what RHEL5 shipped with). This is a moderate security release, so consider updating, if you can afford a mysqld restart.

Read more about the 4 CVE bugs fixed. CentOS followed suit within two weeks.

…