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 …

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 …