We’ve written about how a bad economy is indeed good for open source software. We’ve also recognized that with open source software’s maturity and place at the enterprise software table, a bad economy can be a double-edged sword for open source since the failure or fade of large enterprise customers, say big banks, hurts open source vendors right alongside traditional software providers.

What is interesting is that after a couple of years of economic rebuilding, we’ve seen recently how open source is being driven by innovation, particularly in cloud computing, …

Opscode appoints a new CEO. SugarCRM gains a new CFO. And more.

# Opscode named Mitch Hill as CEO, with Jesse Robbins becoming Chief Community Officer.

# SugarCRM claimed billings up 58% in Q2 and appointed a new CFO.

# Tasktop released Tasktop Dev 2.1 and announced Tasktop Sync 1.0.

# Pentaho delivered improved support for Hadoop …

Google and Microsoft trade patent claims. Actuate announces Q2 results. And more.

# Google accused Microsoft, Oracle, Apple and other companies of organising a hostile patent campaign against Android. That prompted Microsoft executives to claim that Microsoft invited Google to be involved in the CPTN purchase of Novell’s patents. However, Google explained that joining CPTN might have decreased its ability to defend itself against potential patent claims.

# Actuate announced its Q2 …

An important part of benchmarking is to draw graphs. A graph can reveal results you wouldn't have spotted just by looking at raw numbers. By the way, the process of massaging the raw numbers into graphs will often reveal things too.

Sysbench output tends to be quite wordy, especially when you have a script that runs 1, 2, 4, 8... threads with the same test. To manually copy paste the numbers into a spreadsheet is tiresome. So I came up with this monster shell one-liner to condense the output into a csv file. I'm posting it here so I will find it the next time I need it:

read more

I will be presenting Care and Feeding of a MySQL Server for Linux Adminstrators twice in August. The first is August 2nd at the Oracle Office in Frisco, Texas at 4:30 PM (Suite 300 ,7640 Warren Parkway, Frisco, TX). We will have refreshments, door prizes, and a discussion about having a meeting (or two) in the Irving office.

Come be cool with us!

The second will be August 19th, in Plaza B, Hyatt Regency Vancouver at 3PM at Linuxcon North America.

This presentation developed from requests from Linux Administrators who know MySQL runs great on commodity hardware. But they want to make sure that they get their servers set up to get the best possible performance. This is a presentation to turn anyone into a DBA after forty minutes. But it will help a Linux admin create the foundation for great MySQL servers. Topics …

Most analytical and BI databases have date dimension table(s). One frequently needs to generate and populate such data. I present a solution below for such data generation, written in Python. Please use different database drivers/modules to connect to your specific database server (MySQL, SQL Server, Oracle, etc.) for data population.

Notes:

1. It takes 2 parameters, start date and end date, in YYYYMMDD format, inclusive. Extensive error checking is built in, but let me know if you have comments/suggestions;

2. The script produce a Python dictionary (associated array) and print out its content;

3. The output includes dayNumber: a day’s position in a year. For example, 2011-02-01 is the 32ed day in 2011, therefore its dayNumber is 32;

4. The output includes weekNumber: a week’s position in a year. The week number in year is based on ISO standard. From documentation: the ISO year consists of 52 or 53 …

Open Cloud Initiative launches. HP joins OpenStack. Oracle releases Java 7. And more.

# The Open Cloud Initiative launched to drive open standards in cloud computing.

# HP announced its support for OpenStack.

# Oracle announced the availability of Java SE 7. The Apache Software Foundation warned of index corruption and crashes in Apache Lucene and Solr.

# Nebula …

I wrote last year about the way Google’s Android mobile operating system was serving as a more open alternative to Apple’s iOS, but not so open that it didn’t leave opportunity for an even more open alternative.

Given that we continue to see software patent-based attacks on Android, as well as swirling FUD around coverage of the attacks and never ending suits and settlements and courtroom developments, it is clear it will be a long time before any of this legal business is ever close to settled, unless ended by settlements first, which is likely.

However, I’m more interested in the technology in the meantime. I also think it’s interesting to see, if not a ‘more open’ …

CloudBees raises $10.5m. Microsoft commits $100m to SUSE. And more.

# CloudBees secured $10.5m in Series B venture funding.

# Microsoft renewed its vows with Attachmate’s SUSE business unit, committing to invest $100m in new SUSE Linux Enterprise certificates over the next four years.

# Oracle announced that it has acquired Ksplice, twhioch offers zero downtime update technology for Linux.

# Ingres announced that Steve Shine has been named Chief Executive Officer and President.

# Dell …

It happens that sometimes you need to access a remote box which supports ssh key authentication. Recently I was trying to reproduce a bug related to SSH public key authentication, so here I would like to share some of my experience.

There will be no explanation of the public key authentication itself here, rather the actual setup and steps to have a public key auth for Windows(client) -> Linux(server) working. Why Windows you would ask? Because interactions for Linux->Linux and for Mac OS X -> Linux simply work using the Unix way, while for Windows you may need some extra actions to do.

Setup

What I had at endpoints:

• Linux –

Ubuntu 11.04, sshd is set up to deny password auth.
Windows – well, it is an XP SP3 i386 box. MySQL Workbench 5.2.34+ is installed

First of all I created an encrypted pair of RSA keys, …