A second (after Open eHealth) Open Source industry announcement today.

I just need to get some basics off of my chest here, it’s by no means a full list but it’s the most basic list I can think of to start with, and it’s basic because I am surprised by some of the slop I’ve seen in production environments.

1. Highly available server clusters - this is different than load balancing cluster, if confused see here.

2. Disaster recovery

-> this means daily,weekly,monthly backups as well as off site backups, and tertiary backups as well as a plan to get those backups imported and running in production as fast as possible. Backups should have consistency checking when they are created.

3. Security

-> perimeter on the network, VLAN’d databases from the web/app servers, firewall, ACLs, etc

-> system level: strong passwords on OS and database accounts (no blank …

Today, Sun announced we've closed the acquisition of MySQL - MySQL is now officially a part of Sun! From a dinner meeting back in late November, through some introspection from MySQL's CEO, to a closing today in late February - everyone involved showed a great sense of pace, urgency and excitement. And now, it's off to the races!

Since the announcement, I've seen and heard near universal support for the relationship - most everyone wants to know where we're headed, so here's a quick overview of our initial plans.

Starting today, we're rolling out global programs to raise awareness and adoption of MySQL among more established enterprises - you'll see ads like this (to the right) targeting institutions and independent software/service vendors (ISV's) looking to …

Let’s begin by assuming you have a server that runs MySQL and lots and lots of traffic flows through it everyday, let’s say… something like 50% of the size of the partition that the mysql binary logs are written to is on, then we will assume the binary log is turned on. Then we assume that expire_logs_days is not set.

What happens? Nagios/etc alerts that the partition is reaching a usage threshold because - low and behold the binary logs are filling up the partition. Tuning this variable is also important. It may need to be set to as low as 1 day, in which case I would say we need a bigger partition for binary logs, but setting it so low can cause replication problems if the slave(s) gets behind more than 1 day - god help us if it does - then those binary logs that the slave is reading are no longer available, and rebuilding replication will be next on the task list. (or using maatkit)

While I’m at it here are some good ones …

Ok, at least they tried. But it seems SAP has for now put their attempts to rest to smoose up a bit closer to OSS. I guess Oracle-InnoDB deal send enough shockwaves around the SAP HQ to kill of any of the little wishpers that had made the surprising MySQL-SAP deal happen in the first time. Now things have come full circle again, MaxDB development is not only back at SAP as I have noted before, its also back to closed source development. At the same time most big European OSS companies seem to end up in the hands of US based companies.

A while ago Novel scooped up SUSE. Recently MySQL AB was bought up by Sun. The biggest European software maker …

As a rule I always execute the following commands on a fresh database installation. Then for each user that is granted privileges, of course they are given a password and the host permissions are locked down as much as possible for their needs, alternately table and column privs as well. I’m not going to get into the parts the manual covers, but rather mention a couple of things on my mind.

First the initial commands:


mysql> use mysql
mysql> delete from user where User='';
mysql> delete from db where User='';
mysql> update user set Password=password('password_here') where User=’root’;
mysql> flush privileges;


However, one thing I’ve noticed is that when you hand over a server to someone that doesn’t necessarily follow your same understanding or regard to user privilege security, bad things can happen. Such as users created without a password. …

No, this is not a blog post on the endless battle between end user and developers as a result of them not understanding each other. No, this post is about "what determines the value of a software/service company". Is it the number of end users or the developers/service people?

Lets start off with a made up example: What would MySQL AB be worth if, lets say Microsoft and not Sun would have bought it? Microsoft would have gotten a ton of users this way. Maybe it would have been worth the price just for an opportunity to try and kill a competitor (this would of course only partially work due to MySQL's GPL nature). How many developers would quit their jobs? How would that affect the future of the product? Ultimately I would expect the chances for a MySQL product and related services to go down considerably because key developers leaving would diminish end user trust and they would spearhead the creation of alternatives.

Now what …

Last week, we held a conference for leading financial and industry analysts from around the world. My keynote presentation is below - broken into two parts for ease of viewing. One analyst remarked, "but this is pretty much what you said last year."

I responded with, "That's the point."

If you'd like more specifics on our financial performance (directly from Mike Lehman, our CFO), views from the marketplace (from Don Grantham, our Global Sales and Services) or specific product roadmaps (from the heads of our Systems or Software businesses), just click here...)

I came across this very thought provoking blog post by Brain Aker of MySQL and /. fame. I think he raises some very important points about OSS development and how to create a successful new project. However some of the advice can also be applied retroactively to existing projects. I especially find his comments regarding "old boys clubs" important. Sometimes when you have a successful project it becomes hard to manage the influx of new people. So the old boys start to feel most comfy when they ignore the new guys. Patches are a good basis (though you still need people to have a look at the patches) of judgement to let new guys in. After all with good patches the project should be moving forward. I think in PHP we have a very similar policy to the "Three Commits, Ding, Ding, Ding" policy Brain applies. And that is a good thing.

A bit more on the "old boys club" stuff …

We’ve got a lot of queries recently on the MySQL docs team address about the documentation (particularly man pages) for MySQL on Debian/Ubuntu.

The source of the original problem was reported as a Debian bug. The assumption from the reading of the license in this instance is that you are not allowed to distribute MySQL documentation unless you’ve asked first, and that the documentation is not released under the GPL license.

The original license was misunderstood in this respect.

In fact, the license as originally quoted in that bug does allow you to provide the documentation if you are providing the MySQL software.

In addition, regardless of how you interpret the license, all of our documentation, including installable man pages, has been available on …