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.

…

This weekend I attended Drupal Camp PDX and listened to a session titled “Drupal in the Cloud”. The presenter, Josh Koenig from Chapter Three, gave a great introduction of what moving to “the cloud” really means, especially in the context of a typical web application like Drupal. The problem, which is of course no fault of Josh’s, is that the best high availability database practices are harder to deploy because you’re working within a different set of constraints in the cloud. Sure, you can setup MySQL replication, but without the ability to insert a hardware load balancer or better control over floating IPs, reliable single-master solutions are difficult at best.

I spoke with Josh for a bit after and discussed how …