I’ll be blogging and posting photos from the 2008 MySQL Conference.

My photos can be seen in a Flickr set at  http://www.flickr.com/photos/mhillyer/sets/72157604556435611/

Watch this space for session notes.

Here is the notes from MySQL online backup in 6.0 session by Dr. Charles A. Bell, the Author of MySQL Expert book.

• Introduction
  • SQL Driven, run from any client
  • backup to localhost
  • new security privileges for backup/restore
  • blocking restore
  • non-blocking backup for Innodb, Falcon etc
• Overview
  • protection and restore
  • basic functionality of backup and restore available now
  • db level -> table, views, sps, functions, … are supported
  • 6.0.5 has it already, try it
  • source code is another way to look into it
• Design
  • ent level consistency between engines
  • default driver …

Download the PDF: http://www.mysqlfulltextsearch.com/full_text.pdf

Default search by relevance, default sort is by relevance

Boolean search is also popular. cats AND dogs. No default sorting, so you need to order the results yourself

Phrase search

MySQL Full Text Index, only available with MyISAM, and it supports natural language and Boolean search. ft_min_word_len - 4 characters per word by default is indexed. Frequency based ranking, doesn’t count distance between words

SELECT * FROM articles WHERE MATCH (title,body) AGAINST (’database’ IN NATURAL LANGUAGE MODE);

For Boolean, you use AGAINST (’cat AND dog’ IN BOOLEAN MODE).

n-gram fulltext plugin for CJK languages are available as plugins

DRBD and MySQL FullText search? DRBD requires InnoDB, when there is a failover, DRBD needs to …

• Robin Schumacher
• gives overview of MySQL products
• MySQL Enterprise
• MySQL 5.1 announced
  • table/index partitioning -> great for data warehouses, range, cache, key, list, composite, subpartitioning. Partition pruning. Response time greatly improved with proper partitioning.
  • row-based/hybrid replication -> safer and smarter
  • disk-based cluster -> supports bigger DBs
  • built-in job scheduler -> simplified task management
  • problem SQL identification -> easier troubleshooting. Dynamic query tracing is now available, no need to trace things in slow query logs.
  • faster full-text search -> 500% increase in some cases
  • 5.1.24RC available for the conference
• MySQL 6.0
  …

Diamond NotesApril 16, 2008Faster, Greener, Cheaper (Why every MySQL server will one day have a SQL chip) (http://www.paragon-cs.com/wordpress/2008/04/16/raj-cherabuddi-faster-greener-cheaper-why-every-mysql-server-will-one-day-have-a-sql-chip-uc/)

Hello everyone,

Reading PlanetMySQL today, I discovered that Alex Gorbachev’s announcement that he has released the first public beta of his Oracle Grid Control plugin for MySQL was not aggregated! This is probably because Alex is primarily working on our Oracle space and so his feed isn’t on planet.

This plugin has been under development since 2006 and this is a major achievement.

Knowing that my feed is aggregated, and not willing to let this news and this amazing work go unnoticed by the MySQL community during the conference (I am at MySQLConf listening to Amazon.com’s CTO speak right now!)

In any event, if you missed them inline up there, here’s …

I think I’ve been asked a number of times what it is like to suddenly be part of a 34,000 person company after being in a 400 person open-source driven company. Oddly enough, personally, it’s not that much different. I guess that’s what happens when the cultures of the 400 person and the 34,000 person companies match so closely. It could also be I’m drinking some kind of kool-aid that they are passing around at the MySQL Users Conference.

If it’s crazy kool-aid then I’m drinking deeply right now.

Jonathan Schwartz, the CEO of Sun delivered a keynote that really resonated with me. It was about Sun’s agenda. Delivered to a couple thousand folks attending an open source conference he started off with the joke of “enough of this free softwareâ€. Well, really, I like to think that I made the choice to …

Pentaho is hosting its first community meet-up in Mainz, Germany, on 13th and 14th June, 2008.

I will be there, and so will the leaders of the other Pentaho projects: Thomas Morgner (Pentaho Reporting), Matt Casters (Kettle), Mark Hall (Weka).

The format of the meeting will be along the lines of a BarCamp: no PowerPoint, lots of demos, audience participation, beer/wine on hand, and fun afterwards in the form of a cruise on the river Rhine. (Mainz is in the heart of Germany's wine country, so it would be difficult not to have fun!)

Are you going to join us? What would you like to see at the meet-up? What application/technology could you demo?

And by the way, if you can't wait until June, I will be giving a …

I’ve been using MySQL now for the better part of this decade. For most of that decade I’ve been writing and storing CREATE statements and organizing my databases in text files. Oh sure we’ve had tools around, even the old MySQL Administrator stuff, but let’s face it, I believe in Free Software and well, I’m cheap and it’s not like I couldn’t live with the textual way of doing things. At one point, I even organized all my documentation on the databases we managed (literally hundreds of tables and schemas) into a wiki with CREATE statements and ALTER statements all documented.

If you are nodding your head while reading the above you have felt my pain. Even worse, you used to work with me and are swearing at how much documentation is/was needed or you’re going “Dups, I know how you document and I want to bludgeon you to deathâ€.

This morning at the first major keynote for the …

As you probably have already heard Innodb Announced new Plugin version for MySQL 5.1 So now you can see Heikki and the Team were not just doing only bug fixes for last two years, but rather kept very quite.

We had access to this code for few weeks and should say we were impressed in quality (we found only one crash bug which was fixed in less than 24 hours) as well as performance improvements to compression and fast index build functionality. As it is now publicly released we'll try to put it to some production slaves to see how well it works.

There are still usability issues with this release (which you can blame both MySQL and Innodb for) - for example neither of standard data load tools (mysqldump import, using LOAD DATA INFILE or ALTER TABLE from other storage engine) would use Fast Innodb Index creation. Keep it in mind if you decide to …