This Thursday (October 22nd, 13:00 UTC), Walter Heck will present Dual Master Setups With MMM. MMM (Multi-Master Replication Manager for MySQL) is a set of flexible scripts to perform monitoring/failover and management of MySQL master-master replication configurations (with only one node writable at any time). The toolset also has the ability to read balance standard master/slave configurations with any number of slaves, so you can use it to move virtual IP addresses around a group of servers depending on whether they are behind in replication. For more information, see http://mysql-mmm.org/.

For MySQL University sessions, point your browser …

If you have needed a good reason to drink heavily and forget, may I suggest taking a look at create_tmp_table() and those who call it. It’s probably one of the best illustrations of rot and awful, incomprehensible APIs in the server (Drizzle inherited it from MySQL).

In the normal paths for CREATE TABLE, you construct a data structure describing the table you want, create it and then open it. Opening a table gives you objects you can use to access it.

create_tmp_table() instead constructs these objects directly and then does some direct calls into specific storage engines (ever wondered why you can’t use your own storage engine for temporary tables created during query execution? this is why). So instead of having one place to construct TableShare and Table, we have create_tmp_table() doing its own thing.

I struck a blow against it today. Using the standard interfaces to create and open a table, I got the temporary …

MySQL Connector/Net 6.2.0, a new version of the all-managed .NET driver for MySQL has been released. This is an alpha release and is intended to introduce you to the new features and enhancements we are planning. This release should not be used in a production environment.

It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/6.2.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.)

The new features or changes in this release are

• Connection pool cleanup timer. We now utilize a timer that cleans idle connections that are no longer connected every 3 minutes
• We are now using stream and TCP-based timeouts to handle …

Antony and I are busy getting the Open Query GRAPH Engine code ready so you all can play with it, but we needed to test with a larger dataset to make sure all was fundamentally well with the system.

We have some intersting suitable dataset sources, but the first we tried in ernest because it was easy to get in (thanks to Roland Bouman for both the idea and providing xslt stylesheets to transform the set), was the Tree of Life which is a hierarchy of 89052 entries showing how biological species on earth are related to eachother.

GRAPH engine operates in a directed fashion, so I inserted the connections both ways resulting in 178102 entries. So, I inserted A->B as well as B->A for each connection. So we now have a real graph, not just a simple tree.

Just like with my previous post, we have a separate …

The complaints and concerns over Oracle’s pending acquisition of Sun Microsystems and open source MySQL database grew this week to calls for the acquisition, or at least the relatively small MySQL part of it, to be blocked. The Open Rights Group calling for such blockage was joined by none other than the father of the free software movement, Richard Stallman. However, I have to once again question how free and open are these free and open source software advocates? Is the movement and FOSS open to all (except Microsoft, Oracle or anyone else the Open Rights Group, Richard Stallman or any …

In the past I have needed to gain access to MySQL servers when the password had been strangely forgotten. Below there are thee different processes to gain access to MySQL if you just don’t have the right kind of access you need or want.

Option 1: --skip-grant-tables

This will allow you to login to the server and change what you need to in the mysql.user table. Of course you will need to restart the server again without --skip-grant-tables if you want the current and newly added or modified user account to work.

This option is a good way to gain access to the server in the event that you have no elevated (root) privileges on the MySQL server. You do need root on the server you are on so you can kill the pid and restart with --skip-grant-tables.

Option 2: elevating your privileges

You will need to have an account on the server with WRITE access to the …

So I guess the argument that Monty is putting forth is that MySQL's future depends on some company exploiting their ownership of the MySQL copyright. As in, he feels that MySQL future will fall apart if there isn't a company that makes its money by dual licensing MySQL under some proprietary license. Amazingly enough Stallman, chief hater of all things proprietary, agrees. Hell seems to have frozen over. I however humbly disagree. The MySQL community has already left the dual licensing model behind. Sun has never shipped the "best" MySQL version, the community has!

Obviously since many of the patches that make the community versions better have not been licensed to Sun, they can't of course apply these patches to their distro without leaving their proprietary customers …

Wow, Pulitzer-Prize winning photographer Vincent Laforet has done it again! This time with Canon’s brand-new 1D Mark IV and a film shot at ISO6400. And SmugMug’s got it in all it’s full 1080p hi-def glory, of course.

UPDATE: Canon, whom I love, has requested that Vincent take the video down.  As a courtesy to both Vincent and Canon, we have done so, but hope to put it back up again as soon as they give us the green light.  Read more about it over on Vincent’s blog.  Sorry for the inconvenience.

Related posts:

• Amazing Canon 5D MkII HD video footage! …

Do you know what this is? debian:~/mysql-cacti-templates/t# php mysql.php not ok 1 - basic test to check that the test suite works # Failed test (/root/mysql-cacti-templates/t/mysql.php at line 9) # got: Array ( [b] = 2 ) # Looks like you failed 1 tests of 1. ` It is the beginning of a test suite, which is long overdue. Writing a test suite for this code would have saved a lot of work ages ago.

Funny how different experiences lead to different evaluations of tools. The MySQL HA solutions the MySQL Performanceblog list, are almost listed in the complete opposited order of what my impressions are.

Ok agreed, I should probably not put my MySQL NDB experiences from 2-3 years ago with multiple Query of deaths and more problems than you into account anymore , but back then went in the list Less stable than a single node. I've had NDB POC setups going down for much more than 05:16 minutes
Ndb comes with a lot of restrictions, there are

As for MySQL on DRBD, I've said this before , I love DRBD, but having to wait for a long InnoDB recovery after a failover just kills your uptime ,
…