Here are the instructions for building mod_jk.

1. Download the source and untar it.

2. Ensure you have Sun Studio compiler in your PATH followed by /usr/ccs/bin. Save the following in 'make_solaris.sh' in the 'native' directory :

#!/bin/sh
INSTALLDIR=/opt/coolstack
APACHEDIR=$INSTALLDIR/apache2
make distclean
PATH=$INSTALLDIR/bin:$PATH
export PATH
./configure --with-apxs=/opt/coolstack/apache2/bin/apxs --with-java-home=/usr/java --with-prefix=$INSTALLDIR
make
make install

3. Go to the 'native' directory and run ./make_solaris.sh

4. Edit your httpd.conf file to include :

  LoadModule jk_module        modules/mod_jk.so

5. Restart the apache httpd server.

Let me know if this …

IBM and Red Hat collaborate on Linux-on-Mainframe. JasperSoft launches updated products. Black Duck debuts new product for software M&A. (and more)

IBM and Red Hat Announce Worldwide Enterprise Linux-On-Mainframe Program, IBM / Red Hat (Press Release)

JasperSoft Launches JasperReports Professional Edition, JasperReports Developer Edition, and JasperStudio Professional Edition, JasperSoft (Press Release)

Black Duck Furthers Technology Leadership with transactIP for Software Code Review Ahead of Mergers and Acquisitions, Black Duck Software (Press Release)

…

There are a lot of MySQL udf's floating around, but there are not a lot of resources to just site down and write a UDF.

For this reason I put up a skeleton project for UDFs:
http://hg.tangent.org/skeleton-mysql-udf

You are welcome to pull it and make use of it for your own projects. Its a very simple design and could use a few more people contributing to it.

It does though handle all of the make/build environment for you, which is pretty nifty :)

My recoup cost for this is one cup of Green Tea from the Victrola here in Seattle.

From the Oracle TechBlogs:

The Falcon Has Landed

You can check out the camera they have setup as well:
http://pressroom.oracle.com/falconcam.jsp

When I first saw the headline, I wondered if Oracle was as excited as MySQL is to see new releases of our Falcon Storage Engine!

Oh well, their falcons are still cute!

I had the interesting customer case today which made me to do a bit research on the problem.

You can create merge table over MyISAM tables which contain primary key and global uniqueness would not be enforced in this case, this is as far as most people will think about it. In fact however it is worse than that - if you have same key values in underlying base tables some of the queries may give you wrong results:

PLAIN TEXT SQL:

1. mysql> CREATE TABLE t1(id int UNSIGNED PRIMARY KEY);
2. Query OK, 0 rows affected (0.07 sec)
3.  
4. mysql> CREATE TABLE t2(id int UNSIGNED PRIMARY KEY);
5. Query OK, 0 rows affected (0.02 sec)
6.  
7. mysql> CREATE TABLE tm(id int UNSIGNED NOT NULL PRIMARY KEY) type=merge union(t1,t2);
8. Query OK, 0 rows affected, 1 warning (0.03 sec)
9.  
10. mysql> INSERT INTO t1 …

You might have noticed that MySQL is hiring. We need more people. Last time I looked, we had 29 open positions, nearly all of which worldwide.

Internally, we have an initiative to come up with a canonised list of “The Top Reasons To Work for MySQL“. This is my input to the internal group of people compiling that list:

1. You get to work with some of the smartest people on the planet, as users, customers and colleagues.
2. You don’t have to relocate, but you can, if you (or your spouse) want to.
3. You usually work from home and can be available for family emergencies.
4. You can influence your own daily working rhythm.
5. You get to travel, meet …

Today seems to be Innodb day in our Blog, but well this is the question which pops ups quite frequently in Innodb talks and during consulting engagements.

It is well known to get better performance you should normally set innodb_log_file_size large. We however usually recommend caution as it may significantly increase recovery time if Innodb needs to do crash recovery.

I'm often something like what recovery time would expect for 512MB total log file size. This is however question with no exact answer as there are many things which affect recovery time.

For example Paul mentioned YouTube has something like 4 hours recovery time even if logs are of reasonable size and wikipedia has 40 minutes or so with innodb_log_file_size=256MB. In other cases I know same log file time may have recovery time of 5-10 minutes.

To understand things affecting recovery time you better to understand how Innodb recovery …

It was long overdue, but now it has happened: Planet MySQL now provides a section to aggregate french blogs about MySQL! Thanks a lot to Jay for updating the code and Pascal Borghino for the localization. If you are a MySQL enthusiast located in France (or any other french-speaking country) and you enjoy writing about your passion in your native language, submit your feed now!

Eric Bergen from Proven Scaling (which I had the pleasure to meet in person during the MySQL Conference & Expo in Santa Clara last month) was kind enough to send me a patch for the mylmbackup tool, which justifies a new release:

Attached is a patch file for mylvmbackup that adds the ability to use
lvm version 2 and perform innodb recovery on the snapshot prior to
creating a tar ball. The option is named --innodb-recover.

I've also fixed a bug with default value handling for command line
options. In version 0.4 if a config file was specified default values
in the script were all changed to blank. This means that the config
file had to supply values for every variable instead of just the
values that need to be changed from default.

…

It might look like it is too late to write about stuff happened at Users Conference but I'm just starting find bits of time from processing accumulated backlog. The Theme of this Users Conference was surely Storage Engines both looking at number of third party storage engine presented, main marketing message - Storage Engine partnership with IBM, "Clash of Database Egos" - Storage Engine developers showcase as one of keynotes.

Today let me start with most popular transactional storage engine for MySQL - Innodb.

Innodb Storage Engine was covered in a lot of talks, many of them done by Innodb users. I found these items forth interest

Innodb Zip Page Compression This feature was in development for a while. I believe it is at least 3rd Users Conference it is being talked about, but now it is working enough to do some tests. There seems to be still fair amount of work required to make it work well such as having …