Since the European Commission announced it was opening an in-depth investigation into the proposed takeover of Sun Microsystems by Oracle with a focus on MySQL there has been no shortage of opinion written about Oracle’s impending ownership of MySQL and its impact on MySQL users and commercial partners, as well as MySQL’s business model, dual licensing and the GPL.

In order to try and bring some order to the conversation, we have brought together some of the most referenced blog posts and news stories in chronological order. Part one, below, takes us from the announcement of the EC’s in-depth investigation up to the eve of the communication of the EC’s Statement of Objections. We will continue to update part two until either the acquisition or the EC’s investigation …

The importance of information exchange in Health Care will continue to grow and the Federal Goverment has several projects to improve it, while also trying to reduce costs. And, as Bill wrote earlier in the year, Sun's Open Source has been actively engaged in this.

Added - Just noticed Tim O'Reilly's note on WhiteHouse.GOV's stack. They use MySQL, Drupal and Apache.

1. Toiling in the Data Mines -- Tom Armitage describes the process that Berg calls "material exploration". Programmers very rarely talk about what their work feels like to do, and that's a shame. Material explorations are something I've really only done since I've joined BERG, and both times have felt very similar - in that they were very, very different to writing production code for an understood product. They demand code to be used as a sculpting tool, rather than as an engineering material, and I wanted to explain the knock-on effects of that: not just in terms of what I do, and the kind of code that's appropriate for that, but also in terms of how I feel as I work on these explorations. Even if the section on the code itself feels foreign, I hope that the explanation of what it …

For those who use Amazon EC2 service and were anxious about having XtraDB ready to launch there is a good news.

We created a public AMI (Amazon Machine Image) with XtraDB release 8 installed on CentOS 5.3.

How to use it.

First make sure it is avaiable.

PLAIN TEXT CODE:

1. $ ec2-describe-images ami-4701e22e
2. IMAGE   ami-4701e22e    xtradb/centos-5.3-x86_64.fs.manifest.xml        834362721059    available       public          x86_64  machine
3. $

Run it. It is built for x86_64 plaform, so allowed types are m1.large, m1.xlarge and c1.xlarge

PLAIN TEXT CODE:

…

I’ve released version 1.1.4 of my improved Cacti templates. Unlike the prior release, which was solely bug fixes, this one includes new graphs in the MySQL template. Some of the graphs are of data that’s exposed in standard MySQL versions, but some of it is available only in Percona’s high-performance builds of the MySQL database server. If you don’t have a Percona build, those graphs will just contain nothing, but there is no detrimental effect.

This template release is fully backwards compatible with the previous release. The upgrade process is to copy the new PHP file into place and import the new template file. You can then add the new graphs to your hosts.

I’ve also taken the opportunity to address many of the other open issues. Most of these were minor, such as a debug …

Once in a while we been in situations where you need to quickly understand/analyze a database given to you by others.  We can go through each table and try to understand but it is usually lot simpler if you can visualize all the tables involved and relationships between those.  Enter SchemaSpy: a free tool to do that.    For sake of specifics, say the database given is MySQL and your pc is running some version of Windows.

A. Download and Install Pre-requsites (if you dont have already)

• Graphviz  (http://www.graphviz.org/Download_windows.php)
  • use MSI installer (see warnings specific to vista on the download page)
• Java (http://www.java.com/en/download/index.jsp)
  …

The attendees were not satisfied with the first answer RMS gave to Brian, that Harish Pillay (Chief Technical Architect, Red Hat Singapore), chose to ask RMS what more he had to say, with regards to the letter he’d written. He answered quite candidly in this video, which Brian chimed in for as well.

The back channel for all this was Twitter… Don’t hesitate to follow @harishpillay, @brianaker, @piawaugh or even @webmink …

You do SHOW PROCESSLIST, and you see one of your web apps issue the following query:

 SELECT ... WHERE ... AND 1=2 UNION SELECT ...

What does this tell you, and what do you do next?

Ever seen this in SHOW INNODB STATUS and wondered what it means?

-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 4634, seg size 4636,

I’ve never been quite sure, and Peter didn’t really clarify things himself, so I took a look at the source. If I’m not mistaken, the seg size is really one more than the number of records the insert buffer can hold, the free list length is the number that aren’t in use, and the size is just seg_size - (1 + free_list_len). These seem to be kept in lockstep as records are inserted and merged.

Related posts:

1. How to …

Galera 0.7pre release was published, well actually 2 weeks ago already, and is now ready for downloads both in codership and launchpad sites:

• www.codership.com/downloads/galera
• https://launchpad.net/codership-mysql

read more