Diamond Notes

Hey everyone, I just posted a tutorial I wrote for the maatkit toolkit. This tutorial only covers the mk-table-checksum tool and the udf that Baron coded which speeds up the checksum process quite dramatically (small benchmark test included in tutorial). I really don’t have it linked into my website yet, but the direct download is here.

Baron, thanks for the hard work on the toolkit. We really appreciate it.

Enjoy!!

Johnathan made mention that the ZFS Filesystem “might” be moving from the CDDL license to a GPL license. Yeah!!

I finally get to talk a little about a company that I have been having discussions with since either December or November (can’t remember actually). I posted a small taste about Kickfire last week when it was revealed that they are one of the major sponsors of the MySQL Users Conference.

Well, I finally get to write a little more.

Kickfire will be bringing a revolutionary product out this year. It is a MySQL appliance that contains a new storage engine and the equivalent of a graphics accelerator chip for your SQL read queries. And yes, that is really what it is. The hardware component parallelizes query processing and brings massive performance gains to your reporting and data warehouse setup. The software component employs column store and compression to minimize disk I/O. It is a fascinating paradigm shift in thought about how we deal with large dataset issues.

I have seen tests comparing what will be their product to other data warehousing products. It is phenomenal the performance of the product, but what will really blow you away is the price differences between the competing products. While Kickfire hasn’t released their final pricing, testing results or a release date (in fact, their website isn’t even up yet) it won’t be much longer and it will be worth the wait.

They will be presenting their technology at the conference so it will be a good chance for any conference attendees to get a first hand look at Kickfire and their coming products.

Don’t forget on the 15th of this month the Spring issue of MySQL Magazine comes out. I have a full length article about Kickfire in the magazine.

Hey everyone, allow me to put on my editor/publisher/janitor hat briefly for MySQL Magazine (http://www.mysqlzine.net). On April the 15th I will be putting out the fourth issue of the magazine. We have been growing in “subscribers” (downloads) since I began the magazine last spring. It is now time to begin seeking advertising.

MySQL Magazine is a online magazine produced four times a year that is targeted at both MySQL developers and database administrators. Some of the most well known names in the field write articles for the magazine. Given the highly specialized nature of the magazine it provides a phenomenal opportunity for companies interested in reaching an audience with interest in MySQL products and services.

Please contact me at bmurphy AT paragon-cs.com if you are interested. Our advertising rates will be very competitive and I will offer special 25% discounts to the first two advertisers that will last for the first year if you choose to advertise with us for that long. We can do either full or half-page ads.

Thanks for your time. Now we return to regularly scheduled programming

 Start planning now.  The next meeting of the Triangle MUG is March the 5th at 7:00 pm (we begin gathering at 6:30 for pizza).  This month is going to be great .. David Holoboff from Columbia, SC is going to be presenting on:

1) Migration from Oracle/SQL Server/Sybase to MySQL - plans & process, including “gearing up” MySQL for big time (at about 12 - 20 million record inserts daily)

2) Data Warehousing and Business Intelligence (inspired by Ralph Kimball) - and our experience with Pentaho

Don’t miss out.  Meeting is at 2635 Meridian Parkway, Durham NC.