We are proud to announce that MySQL Workbench has reached GA (General Availability)
status and the final version - 5.0.19 - is available on our mirrors.

We managed to get another 32 bugs fixed since the last Release Candidate and hopefully there aren’t many still hidden in our code. We are planning to release a new Version of Workbench every three weeks so if new bugs are found and reported we’ll fix them and supply a improved build quickly.

Get a copy of our OSS Edition from Servers now and start designing your databases.
If you want all the time-saving features (including direct connection to DB, Validation of your models, …) you could invest 99 USD on the Standard Edition - please go to http://shop.mysql.com and get your license there! (Our web-shop is currently being prepared so Workbench will be available there at 4pm PST)

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/)

Hi there!

I arrived at Santa Clara yesterday, just in time for the MySQL Community dinner (check this post on Arjen’s blog). It was a lot of fun, not to mention the opportunity to talk to developers and other folks from MySQL/Sun.

Unfortunately, I forgot to pack in my luggage a card reader or a proper cable for my camera, so pictures will have to wait a few days. To mitigate this problem, I’ll try to hunt down more posts from other guys, but in the meantime, you might want to check the 2008 MySQL Users Conference & Expo group at Flickr.

Yesterday was the “Tutorials Day”. I’ve been to many of them. The subjects were so interesting I just couldn’t stay put for the whole session so, I kept jumping from one to the other. A few quite interesting sessions: …

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 …