You’ve probably seen the release announcement of MySQL Workbench this week at our User Conference and I wanted to add my public congratulations to the team.  At my last company, I oversaw a product line of many database tools for Oracle, SQL Server, MySQL, and others. And without question, out of the monitoring, admin, development, and other tools we produced, there was no other product that required more brainpower to produce than the modeling tool we sold (ER/Studio).  And that’s why I think the delivery of MySQL Workbench is so special - underneath the covers, there is a ton of complexity and hard work that other tools just don’t require. Modeling tools are just a different beast and the teams that build and maintain them are extreme developers - they have to be.  Mike Zinner and his team are just such developers and we’re lucky to have them.

Download and try out …

• Phil Hilderbrand of thePlatform for Media, Inc presents
• classic partitioning
  • old school - union in the archive tables
  • auto partitioning and partition pruning
  • great for data warehousing
  • query performance improved
  • maintenance is clearly improved
• design issues in applying partitioning to OLTP (On-Line Transaction Processing)
  • often id driven access vs date driven access
  • 1 big clients could be 80% of the whole database, so there's a difficulty selecting partitioning schemes
• partitioning is only supported starting from MySQL 5.1
• understanding the …

I know I’m a little late to the discussion, but Brian Aker posted a thought-provoking piece on the imminent death of MySQL replication to scale reads.  His premise is that memcached is so cool and scales so much better, that read replication scaling is going to become a think of the past.  Other MySQL community people, like Arjen and Farhan, chimed in too.

Now, I love memcached.  We use it as a vital layer in our datacenters, and we couldn’t live without it.  But it’s not a total solution to all …

ebizQApril 16, 2008Kickfire and Open Source Partners Team to Deliver BI Solutions on MySQL Database Appliance (http://www.ebizq.net/news/9416.html?grss)

check it out:
the announcement

plugin documentation


o) Fast Index Creation in the InnoDB Storage Engine
o) InnoDB Data Compression
o) InnoDB File Format Management
o) InnoDB INFORMATION_SCHEMA tables


yay!! gonna test the compression immediately :)

Here are my liveblogging notes from MySQL Sandbox: Easily Using Multiple Database Servers in Isolation by Giuseppe Maxia

Giuseppe has been a community member since 2001, and in the past year or so, a MySQL Employee.

He likes to give things away for free — he gave away T-shirts to the early arrivers to the workshop, and that’s why he’s giving away the sandbox as well. The sandbox is NOT an official MySQL product. It is released from GPL, available from http://sf.net/projects/mysql-sandbox.

Why the sandbox? To be able to set up 1 server in under 10 seconds. And to be able to set up multiple MySQL instances very quickly, and to use them quickly.

The sandbox untars in seconds, for …

Today there are a lot of presentations that stand out. They include:Roland Bouman - Information_schema presenations.Tobias Asplund and Jay Pipes - MySQL Performance.Tom Hanlon - Benchmarking and Monitoring.Balint - Deadlocks, Wait Timeouts and Other Transactional Issues.Grimmer - MySQL Backups using LVM Snapshots.

Monday I gave a presentation at the MySQL User Conference in Santa Clara.  I uploaded my presentation materials as a PDF to my website.  It's available under the Creative Commons 2.0 license for non-commercial, no derivative use.Download the PDF at http://www.karwin.com/downloads/SQL_Antipatterns_MySQLUC2008.pdf

Here is the quick notes from the session Scaling MySQL - Up or Out ? moderated by Kaj Arno as part of the todays keynote.

Here is the list of panelists are ordered by Alexa ranking.

1. Monty Taylor (MySQL)
2. Matt Ingerenthron (Sun)
3. John Allspaw (Flickr)
4. Farhan Mashraqi (Fotolog)
5. Domas Mituzas (Wkipedia)
6. Jeff Rotheschild (Facebook)
7. Paul Tuckfield (YouTube)

…

FYI, I changed two parameters on Planet MySQL to accomodate the current flood of postings coming from the MySQL Conference attendees: we now display the last 25 posts (instead of 10) on the front page, the RSS feed now includes the latest 100 posts (instead of 50). This should make sure that posts actually make it to the front page for at least some time, before they fall off again.

Please keep up the good blogging!