The latest from the MySQL community

Please join us at the North Texas MySQL Meetup if you are in the Dallas area this coming Monday July 7th, at 7PM. This is our first time at the Sun Office (Mansions 1 and 2 rooms of the Sun Office, 16000 Dallas Parkway, Ste 700, Dallas, TX Dallas, TX 75248). We have been a good little group but now we need more room to hold more bodies. And the location should be better for those in Dallas.

There will be a short presentation on Getting Started with MySQL and Studying for the Certified MySQL Associate Certification and will be followed with a general 'round table' discussion.

Anyone interested in MySQL is welcome but please RSVP at http://mysql.meetup.com/250/

And the next night is the DallasPHP.org meeting -- a great resource for all levels of PHP coders. A blub from their website The Dallas area has many highly experienced PHP developers, and is adding new developers all the time. This July, the …

Why are the best technical books also the thinnest? To make the case, I highly recommend the MySQL 5.1 Cluster Certification Study Guide In rack units, it’s a 1U; it fits nicely into my laptop bag; and if you’re considering implementing MySQL Cluster, it can save you a world of time.

Of course, if you get the book, you should consider the certification itself. There’s a legitimate debate about the usefulness of certification exams, but the MySQL 5.1 Cluster certification is a little more important than others for a couple of reasons:

1. In case you haven’t heard it by now, Cluster isn’t always the best fit. In many cases, an active/passive failover setup is a much more flexible and cost-effective approach. It’s not always a clear-cut decision. If you’re willing to make application changes …

I have been helping customer today to resolve his lockups in production by downgrading from MySQL 5.1.25 to 5.0 We have other customers (and our own projects as well) which run on MySQL 5.1 successfully but I can't it is on par with MySQL 5.0 stability yet.

This given customer was running MyISAM on FreeBSD with quite basic queries, so may be there are some issues with FreeBSD and MySQL 5.1 still ?

Entry posted by peter | 11 comments

Add to: | | …

I was sitting in a train in the middle of rainy Ireland when I received a mail that Nokia has bought Symbian and is releasing it as Open Source. I didn't believe a word of it. But the web was full of news about it, so it was true. This is an amazing turn of events that I didn't anticipate at all. (You may or may not know that in my previous job I was heavily involved with Symbian programming. Ironically, one reason I left just 6 months ago is that I wanted to work in an Open Source environment :-)

read more

Blogs are good for many things. One of them is not easy aggregation. So I decided to make this digest blog of the 71 blog entries I’ve written so far in 2008.

The first category is Sun-MySQL acquisition and integration. To be specific, the first blog entry in this category didn’t even touch upon Sun; on 7 January 2008, I noted that nearly all of us 400 MySQLers met in Orlando, Florida. Then and there, on 16 January, we announced that Sun acquires MySQL. The same day, I spoke to the MySQL founders Monty and David on their Sun feelings, and bragged that we “ …

So how do I start explaining about decision tables? Well, its an interesting subject..

Introduction

What does wikipedia say ?
"Decision tables are a precise yet compact way to model complicated logic. Decision tables, like if-then-else and switch-case statements, associate conditions with actions to perform. But, unlike the control structures found in traditional programming languages, decision tables can associate many independent conditions with several actions in an elegant way."

Decision tables, for me, seem to make sense in that they model logic into an understandable table-diagram that can be checked easily.


…

Over the past few years, Oracle has bought nearly every enterprise software company in existence, but comparatively few database-related vendors (Sleepycat, InnoDB, etc.). This hasn't mattered, however, as it's gargantuan applications business is helping to drive its database business, now climbing to 44 percent of the enterprise market....

In October 2003, Mick Carney (the first MySQLer in Sales in France) convinced us to choose Véronique Loquet and her company Al’x Communication as MySQL’s French PR agency.

And what an excellent choice it was! Véronique and her Paris team have been with us now for nearly five years. Her contacts are excellent, as are her organising skills. She practically embodies PR for les logiciels libres (Free and Open Source Software) in France.

Véronique has visited the MySQL Users Conference in Santa Clara several times, and of course introduced us to numerous French journalists, fixing plenty of meetings for Mårten, Zack, myself and others.

Being acquired by Sun Microsystems does have many more ups than it has downs, but one …

I?ve spent the past three weeks profiling open source policies and adoption projects at the 16 nations competing in EURO 2008. Congratulations are due to Spain, which deservedly won the football championship on Sunday with a 1-0 win over Germany.

Just for fun I thought I?d also declare a 2008 Tour of Europe Open Source Champion. In deciding the winner I decided to follow the same organizational structure as the football, so read on to find out which eight nations made it out of the group stages and how I whittled it down to an eventual champion.

If you disagree with any of my decisions feel free to add a comment explaining why, but remember: the referee?s decision is final. Although the football has finished, I?ll also be …

When using MySQL in batch mode, you may often find it useful to use the UNIX shell commands along with the SQL queries. This is a demo script showing how you can achieve that:

# Mixing shell commands and SQL queries in batch mode- demo script

use test;

#INSTALL PLUGIN example SONAME 'ha_example.so'; #Ignore statement

system cp /tmp/mysqld.trace logs/init.trace # Shell commands prefixed with a 'system'

create table new4(num integer) engine=EXAMPLE;

system cp /tmp/mysqld.trace logs/after_create.trace # Shell commands prefixed with a 'system'

system diff logs/init.trace logs/after_create.trace # Shell commands prefixed with a 'system'
 

This script makes use of the 'system' command:

system  (\!)    Execute a system shell command.

Note that this is available only on UNIX systems.