Yesterday Kaj Published changes to MySQL Community Release Policies. I knew about them a bit in advance but now they are public I can comment a bit.

In general I'm disappointed and think this is moving in the wrong direction, it also makes me to think hard if MySQL is out of more creative solutions to increase the sales revenue ?

The main issue for me is Change policy for MySQL Community version. We are patching MySQL with minor extension so this concerns us a lot - it would be much easier to make our customers to run Community version (at least temporary) compared compiling patched version for them. There was as hope MySQL Community version would allow to quickly make changes available but not it is gone.

Honestly I do not think it ever work. We have submitted our patches for microsecond resolution of slow queries over half a year ago. These patches had a …

A few days ago, I got the opportunity to hear about some upcoming changes in MySQL Community and MySQL Enterprise. I’ve been waiting for an official announcement before commenting on the changes, and Kaj has finally posted the official announcement on his blog in Refining MySQL Community Server.

In summary, the changes are:

• Community gets no new features in any version once that version becomes GA — This effectively means that the difference between the content of Community and Enterprise approaches nil, since the addition of “Community Enhancements” was the major selling point for MySQL Community; In addition, it means that as of today, any new …

Different things can be said about Kaj Arno's , Refining MySQL Community Server but given the fact that the source will continue to be freely available from Bitkeeper I see no issues apart from a possible growth in real community MySQL with real contributions.

In Mike Kruckenberg's article on the topic someone comments and asks how this is different from the RedHat model, I only see one difference, today we don't have a CentOS yet for MySQL .. I`m sure it's just a matter of time and someone will start building RPM/Debian packages from the source repository. (If it's not already happening today)

As long as MySQL keeps all their source code free ..

Different things can be said about
Kaj Arno's , Refining MySQL Community Server but given the fact that the source will continue to be freely available from Bitkeeper I see no issues apart from a possible growth in real community MySQL with real contributions.

In Mike Kruckenberg's article on the topic someone comments and asks how this is different from the RedHat model, I only see one difference, today we don't have a CentOS yet for MySQL .. I`m sure it's just a matter of time and someone will start building RPM/Debian packages from the source repository. (If it's not already happening today)

As long as MySQL keeps all their source code free ..

Oracle contributes code to Linux community. Linux Foundation adds legal talent. Luxoft open sources test automation tool. (and more)

Oracle Contributes Enhancements To Linux Community, Oracle (Press Release)

Leading Open Source Legal Experts Join Linux Foundation, Linux Foundation (Press Release)

Outsourcing Leader Luxoft Contributes New Test Automation Tool to Open Source, Luxoft (Press Release)

Oracle Provides Six New Validated Configurations for Linux …

Direct play this episode at:
http://technocation.org/content/oursql-episode-21%3A-rise-mysql-dba-1

Paul Vallee is back for this non-technical podcast about the special creature that is the MySQL DBA.

News:
October 2006 Enterprise/Community Split announcement
http://www.planetmysql.org/entry.php?id=4393

Current clarification of Enterprise/Community split
http://www.planetmysql.org/kaj/?p=123

Dorsal Source, a community-focused website whose goal is to provide builds of MySQL and related products.
http://www.dorsalsource.org

Learning Resource:
MySQL Camp II, August …

Mike Kruckenberg, well-respected community member recently blogged about MySQL taking another step (away from open source, and I’d like to refute some of his worries. In fact, this is really more to drive away from what some within the community think is not kosher, i.e. change #5 in Kaj’s blog entry.

The sources are always available. Its just gone one step further, in that you need to use the Bitkeeper free client, and pull the correct revision, tags of which are always at http://mysql.bkbits.net/. From there, you are welcome to compile it yourself, and even make a binary distribution, all with fair ease thanks to the excellent …

Paul Vallee is back for this non-technical podcast about the special creature that is the MySQL DBA.

News:
October 2006 Enterprise/Community Split announcement
http://www.planetmysql.org/entry.php?id=4393

Current clarification of Enterprise/Community split
http://www.planetmysql.org/kaj/?p=123

Dorsal Source, a community-focused website whose goal is to provide builds of MySQL and related products.
http://www.dorsalsource.org

Learning Resource:
MySQL Camp II, August 23-24 2007, Brooklyn NY
http://www.mysqlcamp.org

http://www.poly.edu

Feature:
The …

If you haven't checked out the MySQL Proxy yet, it is definitely worth playing with. One of the most useful features is the embedded Lua interpreter that allows a user such as myself to write scripts that modify queries and responses. Upon each connection to the proxy server, the Lua script is loaded and affects only that connection. Unfortunately my project requires logging over multiple connections (hard when each connections has its own instance of the script), but Jan was nice enough to add the PROXY.global feature. Now a single instance of my logging module can be used by multiple connections. So for your viewing pleasure, I am going to show you an example of how to use the globals in case you ever venture into using the proxy's embedded Lua interpreter.

So, to keep it simple, lets say that you want to simply count the number of queries that come through the server. Here is a script that adds one to `query_count` every time a …

The idea is as old as Replication is:

How do you know which is the most current slave.

You can use the Master_Binlog_Pos to guess what is most up to date, but which transaction does this binlog position match ?

With the proxy you can add a global transaction ID to your setup, if you let the inject some information into the stream.

The idea is simple and is documented in various places.

Create a MEMORY table which is replicated with a single UNSIGNED BIGINT and increment it at the end of each transaction.

CREATE TABLE trx (
  trx_id BIGINT UNSIGNED NOT NULL
) ENGINE=memory;

INSERT INTO trx VALUES ( 0 );

When ever you commit a transaction UPDATE the trx_id field:

UPDATE trx SET trx_id = trx_id + 1

Usecases:

• identify which slave is most current and …