We are going to be doing our first in person Developer Meeting for Drizzle on Friday April 24, 2009 from 10:00 a.m. to 5:00 p.m. right after the MySQL User's Conference.

You can sign up and find more information here:
http://drizzle.org/wiki/Drizzle_Developer_Day_2009_signup

A few topics for the day:
"What Craigslist needs from Drizzle" -> Jeremy Zawodny
"Drizzle Protocol" -> Eric Day
"Code Stub generation for various plugin apis" -> Hartmut

You can find more here:
http://drizzle.org/wiki/Drizzle_Developer_Day_2009

In MySQL 5.1.33 there is a fix for an apparently innocuous bug.
Bug #36540 CREATE EVENT and ALTER EVENT statements fail with large server_id.
This is a usability bug, that makes the DBA life unnecessarily hard. The reason for having a large server_id is because a DBA might want to use the IP address as server ID, to make sure that there are unique IDs, and to have an easy way of identifying the server through the IP.
All is well until you mix the server_id assignment with event creation:

 select version();
+-----------+
| version() |
+-----------+
| 5.1.32    | 
+-----------+
1 row in set (0.00 sec)

 set global server_id =inet_aton('192.168.2.55');
Query OK, 0 rows affected (0.00 sec)

 select @@server_id;
+-------------+
| @@server_id |
+-------------+
| …

2.6.29 was released. I don’t usually write about linux kernel releases, thats what Slashdot is for :), but this one introduces write barriers in LVM, as well as ext4 with write barriers enabled by default. If you run this kernel and forget to turn off barrier support at filesystems (like XFS, nobarrier), you will see nasty performance slowdowns (recent post about it). Beware.

The MySQL UC 2009 is coming and it is time for my own little marketing. As Matt already annonced it a few months ago we (Matt and I) are doing a WaffleGrid presentation, Distributed InnoDB caching with Memcached, Tuesday at 2PM. I am also presenting at the MySQL Camp or unconference, NBD (MySQL Cluster) performance tuning and pitfalls, also Tuesday at 4:25PM.

Contents

• What Is Database Designer?
• How to Create a Database Diagram
• Navigating the Diagram
• How to Quickly Print Diagram
• Saving and Restoring the Diagram

What Is Database Designer?

Database Designer is a powerful visual design tool for database development that allows you to build a clear and effective database structure visually and to see the complete picture representing all the tables, foreign key relations between them, views, and stored routines of your database on a database diagram.

Database Designer allows you to view and edit your database in a convenient visual way. You can observe all objects of your database, see foreign key relations between tables, viewing database objects information, easily access database …

If you are a twitter user, you may like to know that there are many people from MySQL who are regular twitters.

For a start, you may want to follow these ones:

People

1. kajarno Kaj Arnö
2. datacharmer Giuseppe Maxia
3. bytebot Colin Charles
4. LenzGr Lenz Grimmer
5. dups Dups Wijayawardhana

Non-people

1. mysqlconf MySQL Users Conference, which is going to be used during the conference to collect feedback for the panel …

Here are some quotes from a recent article talking about Oracle's maintenance and support fees:

Before Oracle acquired BEA earlier this year, the company charged 18% to 20% for support and maintenance. Oracle increased those fees to meet its own structure and also raised list prices on most BEA products.

That didn't sit well.

and


One Java-centric VAR, who spoke on the condition of anonymity, said some of his BEA WebLogic customers are moving to alternative application servers just to get away from Oracle.

and

"What company comes in this climate and not only jacks up prices but support prices as …

MySQL HA: 1. Desirable – most of the time, 2. Needed – often enough, 3. Available – there are some good options out there. Typical solutions consist of: Heartbeat with DRBD on Linux. Although HB was introduced to Linux, it can be used on Solaris, FreeBSD and others without the DRBD but with other solutions. Sun Cluster, Veritas (commercial), MySQL Proxy (still in [...]

After the Sunrise and Landrush phases (underway until March 23rd), .TEL domains will finally be available to everyone as of March 24th.

Online pre-reservation for this final phase is available at Gandi. Registration will be made on a first-come, first-served basis. Registration requests that failed will be fully refunded. The price for a .TEL domain has been set at 14 euros per year excl. VAT under A rates.

As a reminder, please do not forget that the .TEL extension is unlike other extensions! You will be unable to have a website with an address like example.tel. The purpose of the extension is to store and manage your personal contact information in a format that can be easily handled and accessed by everyone or specific persons via DNS records.

We invite you to discover all of the possibilities that are available to you on the registry's website at …

Quite common task during schema review is to find the optimal data type for the column value - for example column is defined as INT but is it really needed or may be SMALLINT or even TINYINT will do instead. Does it contain any NULLs or it can be defined NOT NULL which reduces space needed and speeds up processing in most cases ?

These and similar tasks are often done by bunch of SQL queries while really MySQL has a native feature to perform this task - PROCEDURE ANALYSE

Here is sample run of PROCEDURE ANALYSE on drupal schema of Percona web site. The output contains row for each column in the table but I've omitted everything by few rows.

PLAIN TEXT SQL:

1. mysql> SELECT * FROM node  …