There were several requests for copies of the replication presentation at MySQL Sunday at Oracle Open World. It will be published by the conference, but for now you can download it from www.larsthalmann.com.
There were also questions about the high availability book. It is called MySQL High Availability and was written by Chuck, Mats and me.

We are pleased to announce the availability of the 1.5.4 release of InfiniDB Community Edition.  This is our second maintenance release for 1.5.

This release includes a number of bug fixes that you can see at http://bugs.launchpad.net/infinidb.  You can download the latest InfiniDB binaries, source code, and updated documentation at: http://infinidb.org/downloads.  We welcome y...

I occasionally get in to light arguments healthy discussions with students about whether or not to use Foreign Key constraints on InnoDB tables.  My standard response has always been: “it depends on how much of a tradeoff you are willing to make for performance. In some situations the cost can be considerable”.

.. that’s when they expect me to “come up with some real proof” to show them. I do not disagree with their logic or proof being on their list-of-demands.  I support the use of data to make decisions.

The problem is that MySQL has (traditionally) been lacking the instrumentation required to make these decisions easy.  This is getting better  – here is an example we recently added to our InnoDB course:

 CREATE TABLE parent (
 id INT NOT …

With IBM intending to acquire Netezza the predicted consolidation in the distributed analytics market is well underway.  Recent deals include EMC/Greenplum Teradata/Kickfire and now IBM/Netezza.  A good breakdown of this deal is on Curt’s blog.  There is still more to go of course with one of the crown jewels, Vertica, still ripe for the picking. 

What this indicates is that MPP analytics has moved from the innovative edge into the mainstream market and now the more risk adverse large caps and now willing to invest substantially in growing this market.  Interestingly Microsoft made this move early with the …

Our idea is it to index the database examples and know-how that gets published day by day by individuals and companies in countless blogs all over the web. Imagine a database that contains all the valuable information, indexed by Apache Solr to make it easy to find the content you need once you really need it! Subscribe to our RSS feed, generate a personalized feed or follow us on twitter and you never miss interesting content again.

We are proud to announce the sqlexamples.org feed aggregation! Adding your own content can't be easier. To join us, all you have to do now is to add a RSS/Atom feed using the "add your feed" link once you're logged in. All comforts we offer apply! You can take part in the …

Yesterday, Sept. 19, 2010 at the inaugural MySQL Sunday event at Oracle OpenWorld, we announced the MySQL 5.5 Release Candidate. The MySQL 5.5 release candidate helps improve the performance and scalability of applications across multiple operating environments, including Windows, Linux, and Mac. Enhancements include:

Improved performance and scalability:

• MySQL Server and InnoDB have been enhanced to provide optimum performance and scalability when running on the latest multi-CPU and multi-core hardware and operating systems.
• InnoDB is now the default storage engine for MySQL Server, delivering ACID transactions, referential integrity, and crash recovery.

Higher availability:

• New semi-synchronous replication improves failover reliability by allowing the …

We recently had the case with one of our customers where we got externally generated random hash values (up to 70 bytes) and they were used as Primary Keys in InnoDB.

As we know, this is not a very good idea because the size of all secondary indexes becomes large and because a random hash value as a Primary Key gives us a bad locality of our rows in the table [1].

If we do not specify a Primary Key and have no Unique Key InnoDB generates a hidden Clustered Index based on the Row ID which is a 6 byte field.
This Row ID is increasing monotonically [1]. That would fit our needs.

So we were thinking about getting completely rid of any Primary Key of that InnoDB table.

This has the following advantages:

• It is sorted by time (more or …

As a follow up of this post I'd like to inform all the readers that the What's New event will be replicated in Rome on Oct, 7.

Join us at this live event to better understand what’s new with MySQL. You will learn more about the current and future state of MySQL, now part of the Oracle family of products. We will also cover Oracle’s investment in MySQL aiming to make it even a better MySQL.

In particular the following topics will be discussed:

• Oracle’s MySQL Strategy
• What’s New for:
  • The MySQL Server
  • MySQL Cluster
  • MySQL Enterprise
  • MySQL Workbench
  …

A few SQL queries are worth a thousands words:

mysql> SELECT VERSION();
+----------------+
| VERSION()      |
+----------------+
| 5.5.6-rc-debug |
+----------------+

mysql> SELECT @@global.storage_engine;
+-------------------------+
| @@global.storage_engine |
+-------------------------+
| InnoDB                  |
+-------------------------+

(Note: the above is without using the default storage engine option)

Scary! Excitement! MySQL!

A few SQL queries are worth a thousands words:

mysql> SELECT VERSION();
+----------------+
| VERSION()      |
+----------------+
| 5.5.6-rc-debug |
+----------------+

mysql> SELECT @@global.storage_engine;
+-------------------------+
| @@global.storage_engine |
+-------------------------+
| InnoDB                  |
+-------------------------+

(Note: the above is without using the default storage engine option)

Scary! Excitement! MySQL!