Just as a reminder, there is a MySQL Seattle Meetup on Monday at the Elysian. People show up at 7:00.

More Information is here:
http://mysql.meetup.com/31/events/4796298/

I believe I should have some O'Reilly books on hand to give out.

Topics have included: MySQL, MySQL, favorite science fiction shows, Asterisk, and the ever popular "how many channels of TV are you recording on your MyTH system"

The first public release of MySQL 5.1 is available now. The MySQL 5.1.3 alpha release is a developer preview that gives early adopters, fans, and hard-core database geeks a chance to kick the tires of the next big release.

Major new features include:

Partitioned tables. You can have single tables spread across multiple disks based on how you define them at table creation time.

A Plugin API and support for dynamically loading new modules of code into the server. The first example of this is pluggable full-text parsers. That means you'll be able to write a custom parser to index any sort of oddball textual data you might want to store and retrieve. MySQL still handles the details of executing the queries, so you need only …

hot on the heels of the mysql 5.0 production release, the first mysql 5.1 alpha release is out. the major new features in the alpha are partitioning and the beginnings of the new plugin api (allowing for some cool full-text possibilities now, and even more to come in 5.1 and later versions). here?s the full announcement.

An article I wrote for iPHP magazine has now been published.

I heard a rumour about a task scheduling system within MySQL 5.1. Combine this with what I wrote in my article, and I'm sure there are infinite new possibilities.

How much time do you spend every week typing in ‘mysqladmin -u root -p showprocesslist’ ? or ‘mysqladmin -u root -p kill 123,456,789 ? After listening to Tom Limoncelli’s video presentation of a workshop called “Time Management for System Administrators” (which was the forerunner to the O’Reilly book of the same name), I realized that I could implement some of his tips right away.

Specifically, aliasing. I’ve now aliased the following in my .bash_profile:

alias myps=’mysqladmin -u root -p processlist’
alias mystatus=’mysql -u root -p -e “show status; status;”‘
alias mykill=’mysqladmin -u root -p kill’
alias mysqlr=’mysql -u root -p’

I’d rather not put …

MySQL QA
Just a blog to leave comments about and suggestion of QA of MySQL, MySQL Cluster and MySQL Replication software.

Hi All! If you don’t already know, MySQL 5.0 deep-sixes perhaps the largest ‘gotcha’ pointed out by MySQL pundits. I’ve got a new article on how you now have full-fledged server-enforced data integrity with MySQL 5.0. Check it out! Robin

Larry Augustin, founder and chairman of VA Software, has written a very clear editorial at sandhill.com on why applications are the next wave in Open Source adoption.  Augustin has a strong background in open source from his Linux days and is involved in several open source application companies.  Clearly with the amount of VC investment going to open source startups ($400 million in 50 startups over the last 18 months) there are others also placing bets in this area. 

While VCs have been known to overinvest in speculative areas (and that's an understatement!) you have to wonder what is driving the investment.  Augustin goes through a well thought out investment thesis to describe what he believes will separate the winners from the losers.  While Augustin may not be completely unbiased …

While browsing the postings in the MySQL Installation Forum I noticed, that quite a lot of people run into trouble when trying to install our MySQL 5.0 RPMs on recent Fedora Systems or RHEL4. Most of the times the problems boil down to these two issues:

• SELinux is enabled and set to enforce policies. The MySQL policies don't exactly match the layout of the MySQL RPMs, therefore SELinux prohibits the proper installation of the RPM. This is filed as BUG#12676 in the MySQL bug database. The workaround is to either disable or change SELinux into "permissive" mode, exempting the MySQL service from the SELinux configuration using the system-config-securitylevel tool, or modifying the MySQL policies using this patch (See the bug …