Last thursday I got ticked at some Ruby docs, so I tried my hand at C instead.

Just now:

$ wc -l toast.c
598 toast.c

$ git log --pretty=oneline | wc -l
24

$ cat build
#!/bin/bash

rm -f toast
gcc -g -Wall -Wextra -Wno-unused-parameter -O2 -o toast toast.c -levent -llua

("toast" is localhost:5500, mysqld is localhost:3306)


MySQL Client

$ mysql -u root -h 127.0.0.1 -P 5500
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 62
Server version: 5.0.37 MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> \s
--------------
mysql  Ver 14.12 Distrib 5.0.38, for pc-linux-gnu (x86_64) using readline 5.1

Connection id:          62
Current database:       
Current user:           root@localhost
SSL:                    Not in …

I take the easy way out again this week by sharing Guy Kawasaki (of the How To Change the World blog) and his irreverent and truthful keynote at the 2007 MySQL Users Conference.

Kawasaki will challenge your thoughts about being an entrepreneur in the technology industry.

The big news is that soon I’ll be able to announce that the videos from the conference sessions are up….stay tuned!

Show Notes:
Guy Kawasaki’s Blog: How to Change the World
http://blog.guykawasaki.com/

Direct play this episode at:
http://tinyurl.com/2h2d7j

Download all podcasts at:
http://technocation.org/podcasts/oursql/

Subscribe to the podcast at:
…

I'm really excited about MySQL Cluster. It has a lot of potential to be a good competitor to Oracle RAC, and not just in a copy-cat kind of way.

The thing that makes MySQL different and a good balance, when you're fortunate enough to have the choice, is the "Share nothing" concept. In RAC (and I'm no expert), you use shared storage, usually a Netapp Filer. While filers are seriously cool, they are also seriously expensive, and, no matter how much you gussy it up, it's still a single point of failure.

I was glad I sat in on the Intro to cluster talk at the Users conference, it helped me understand what cluster has to offer, and what it still needs. These needs probably …

MySQL AB today began offering its premium MySQL Enterprise subscriptions through the new Red Hat Exchange (RHX). Designed to simplify the lives of corporate database developers and DBAs, MySQL Enterprise is a comprehensive set of production-tested software, proactive monitoring tools, and support services.

I just saw the review on Slashdot about the Visibone cards:
http://books.slashdot.org/article.pl?sid=07/05/09/1331253&from=rss

At the MySQL User's Conference I gave a few of these out. They were of nice quality and were well laid out with information.

The only thing that surprised me about them, was that I had not realized that we had that much SQL syntax :)

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 …