MySQL Connector/Net 6.1.4, a new version of the all-managed .NET driver for MySQL has been released. This is our latest GA release and is suitable for use in all scenarios against servers ranging from version 4.1 to 5.5!

It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/6.1.html] and mirror sites (note that not all mirror sites may be up to date at this point of time – if you can’t find this version on some mirror, please try again later or choose another download site.)

This is a maintenance release and includes many bug fixes.  Please review the change log for details.

Thank you for using our product!

Global Voices Advocacy has a new guide: Mirroring a Censored WordPress Blog. They continue to be the best source for using WordPress to democratize publishing in places restricted freedom.

MySQL Connector/Net 6.0.6, a new version of the all-managed .NET driver for MySQL has been released. This is a maintenance release and is approved for use in all situations.

It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/6.0.html] and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can’t find this version on some mirror, please try again later or choose another download site.)

There are lots of bug fixes in this release so please review the changelog.

Thank you!

Here’s the talk I presented at the MySQL User Conference. This talk is a fairly technical talk on how fractal trees work.

You can find this talk and other mostly technical material at http://tokutek.com/technology/.

Like many other MySQL conference visitors, also Codership team was stranded in bay area due to the volcano eruption in Iceland. For us however, the extra time in silicon valley was not an issue, as we were working on local assignments anyways, and staying local enabled us to work really focused during this period.

Also the "evacuation" from SFO worked out really well for us, thanks to KLM and Air France. We just visited SFO on Thursday (22) and got flights for the next morning. I actually got two bookings, which was a little embarrassing. There were many empty seats and especially the CDG-HEL leg was practically empty. Ash refugees had already left by train, I guess.
The return from SFO happened somewhat too early for us, as we had holiday plans for the forthcoming weekend, and we had to cancel the fun part. So this trip ended up as all work and no joy for us...

The conference itself, was fun and very …

Install and Run Apache Roller 4.01 on GlassFish and OpenSolaris
Dave Koelmeyer has posted Detailed Instructions on how to install Apache Roller 4.01 on GlassFish v2.1 using MySQL 5.1 for storage.  He uses OpenSolaris snv_134, the subject of a tea-leaf-reading thread.

Slides and Code Samples on Jersey and JAX-RS
The Slides and code from Paul Sandoz's presentation at Presentation at AlpesJug on Jersey, JAX-RS and Atmosphere are now  …

As I mentioned in my talk An Overview of Flash Storage for Databases I see in the near and middle term future a lot of interest for using Flash storage in Level 2 caching level. The price-capacity trade-off makes Flash as the very good fit for a cache layer.
Actually it is not the new idea, and it was implemented in L2ARC ZFS for two years already.
It is also described in ACM article "Flash storage memory" by Adam Leventhal.

So I am exciting to see it is available for Linux now. Paul Saab and Mohan Srinivasan from Facebook released Flashcache, which allows to use Flash as …

I spent the day today reviewing Dmitry's patch for Bug#46947. When looking at the quick fix, we discovered that MySQL <-> storage engine locking protocol is very weakly defined when it comes to more advanced features, such as subqueries, stored functions, views.
It's badly defined, it's not documented, it's not tested. As a result, some bits of server behaviour flipped back and forth between 4.1, 5.1 and 5.5.

The problem is that when a statement accesses the table via a subquery, view or a function, the lock that the server needs to take on that table is not a function of the SQL in the subquery/view itself, but depends on the context where this view or function is used.
If we use the view in an UPDATE statement, and don't take sufficiently strong locks on its tables or rows, replication may break, or, in some engines, repeatable read consistency get …

The time has come. People keep on asking why there is a practical limit on the number of nodes in multi-master cluster and what is it exactly. So here's some no-nonsense hardcore multi-master math
(hereafter I assume that all nodes in a cluster have the same processing power and load is distributed uniformly between them).

Let's denote the total work that a node can do as W, the work that it doing serving local connections as L and the work that it is doing applying replication events from another node as R. While W is constant, L and R are variable and depend on the number of nodes. Clearly R is an unproductive replication overhead which we don't want to have there, but have no choice.

Then for a single server we have W = L.

For a 2-node cluster we have W = L + R.

For a N-node cluster we have W = L + R×(N − 1).

Let's denote ratio R/L as α. This quantity lies between …

Announcing a new beta 10 release of MySQL Workbench. Version 5.2.20 includes new fixes for 49 bugs (P1 – 1, P2 – 7 , P3 – 39, P4 – 2)

A few new tips you might try. Some have been in the last 2 betas – but in case you haven’t noticed:

1. Once connected in SQL Editor – type control-T or command-T to add a new editor Tab
2. In the SQL Editor run a select. Highlight a cell (one with an image blob preferably) and right click (or command click) and select “Open Value in Viewer” or another option.
3. In a results set — select multiple rows — right click and “copy row content”
4. Click on snippets. Click on the selector and look at DDL and DML lists.
5. Add your own snippets selection drop down option by creating an empty file in the snippets folder and re-opening Workbench.

For example on Windows …

C:\Documents and Settings\<your …