Robert Treat has published the 27th edition of Log Buffer, the weekly review of database blogs, on zillablog. I invite all our readers to edit and publish a Log Buffer. It’s a fun way to present your perspective on the database blogoshpere to a wide audience of colleagues, companies, projects, competitors — the lot. See [...]

Great news are MySQL finally released new Community release - MySQL 5.0.33, which however as promised comes without Binaries.
This version also does not have any community patches yet, coming of the same tree as MySQL Enterprise.

To help those who would like to use MySQL Community version but does not like to build binaries we decided to publish our build for MySQL 5.0.33 Community release.

This build was done using "Generic Linux RPM" spec file on CentOS 4.4 (RHEL compatible) x86_64

I'll be speaking at MIT this Monday for Sheeri Kritzer's MySQL group. You can find out more information on how to get to the meeting here:
http://mysql.meetup.com/137/

I'll be bringing slides on 5.1 and scaling web architectures. I am told that there will be free pizza as well :)

I am looking for a MySQL Database Administrator to join my team. The position will be located at our Greenwich, Connecticut headquarters. The ideal candidate will have a mix of database technologies, predominantly MySQL, as well as a minimum of three years experience as a Database Administrator on the Linux platform.

Responsibilities

• Administer Backup/Recovery processes
• Install and Configure Database Software
• Identify and resolve performance problems.
• Automate day-to-day tasks as needed.
• Rotating on-duty coverage is expected.
• Manage access to database resources

Required Skills

• 3+ years experience as MySQL DBA in a production Linux environment.
• 1+ years experience with MySQL 5.0.
• 2+ years exposure to Oracle in a production or development environment.
• Day-to-day …

Now as new MySQL Storage engine - Falcon is public I can write down my thought about its design, which I previously should have kept private as I partially got them while working for MySQL.

These thought base on my understanding, reading docs, speaking to Jim, Monty, Arjen and other people so I might miss something, something might be planned to be changed or not 100% correct but anyway you might find it interesting.

In many cases what I find good or bad would base of my MySQL use with existing applications - if you design new applications which are done specially for Falcon you might find those aspects positive.

[-] No Spinlocks Falcon does not use Spinlocks. It has its own lock implementation which does operation system wait if resource is unavailable. We’ll see where this leads us but I believe on multiple CPU systems you need some spinning done, at least for some types of locks where conflicts will …

Or should I say, the MySQL MiniConf at linux.conf.au.

There are some great talks - just check out the schedule & abstracts.

But what’s most interesting, in my opinion, is the cool Answer Guys feature. Think of it like stumping the expert, a little. The MySQL Support Team presents Arjen Lentz (MySQL trainer too!), and Morgan Tocker, for your answering pleasure, all MiniConf day.

They’ll be by the lawn (I’m not sure how UNSW is setup), thats definitely very near the room we’re having the MiniConf at (Room 6).

MuleSource Adds New VP of Engineering to Executive Team, MuleSource (Press Release)

Eclipse Joins Java Community Process, eWeek, Steve J. Vaghan-Nichols (Article)

Qlusters CTO on the Datacenter Revolution, LinuxInsider, Jack Germain (Article)

Should Apple Open Up the iPhone?, Red Herring, Falguni Bhuta (Article)

Red Hat’s JBoss revenue edges toward …

I mentioned when grant statements take into effect in Sql Server, MySql, and Oracle here.

I found out recently that there are some implementation differences when you grant only delete permission on a table to a user. MySql and Sql Server do this the same way, whereas Oracle is different.

Suppose you have:

1. Table t1: create table t1 (c1 int);
2. User TestLogin. The only permission of this TestLogin is delete on t1.

In all 3 database platforms, TestLogin can find out what columns t1 has by default, using either

desc t1

or

sp_columns t1

In both Sql Server and MySql, the only thing you can do is:

delete from t1;

which essentially wipes out the whole table. You can do the same thing in Oracle.

However, if you do:

…

We’re looking to implement CJK Support in Open Source Full Text search engine Sphinx .
Initially we’re thinking to base search ob bi-gram indexing to keep it simple, especially as according to research papers it offers decent quality for most cases. This is not that complex to implement however there is no way we can test it as we have zero knowledge of Chinese or Japanese.

If you know Chinese Japanese or Korean and would like us help us testing Sphinx support for these languages let us know. No special development skills are required. If you’re reading this blog you should be technical enough.

After some time here is another post concerning MySQL. It is not as if I had not had anything to do with MySQL in the meantime, but most of it was mailing back and forth with their customer support (which is really quite good) to get some issues resolved we stumbled over in our MySQL 4.1 to 5.0 migration.

Before those were fixed we could not use MySQL 5 with our application, because there were some incompatible changes we could not work around.

One of them was the unsatisfactory precision when querying DECIMALs I wrote about earlier. This is fixed in 5.0.32-enterprise and the just released 5.0.33 community edition (see Bug #23260). In fact I was just about to write about the new release policy which I find somewhat strange (enterprise and community editions with the …