As I am happy to report a number of people have responded on my initial challenge of 3+3 lessons on building open source business, I wanted to post the links so far, enjoy:

Mårten Mickos, CEO of MySQL

Stephen Walli, an Open Source Expert

Ignacio Correas, CEO of Warp

Stephen O’Grady, Redmonk

Michael Tiemann, President of Open Source …

Zimbra is today's featured scale out example as part of our 12 days of scale out series.  I've always had a soft spot for Zimbra since I first met CEO Satish Dharmaraj a couple of years back at the first Red Hat Summit in New Orleans. Their ambition is significant: they offer a plug-in replacement for Microsoft exchange that is open-source, cross-platform and more scalable. Zimbra Collaboration suite can handle multiple hundreds of thousands of email …

MySQL AB today published a case study on Wikipedia's successful use of the MySQL database to help manage its massive popularity. The winner of the 2005 'MySQL Application of the Year' Award, Wikipedia is today's featured user in the vendor's "Twelve Days of Scale-Out" educational initiative. The campaign is live at www.mysql.com/scaleout.

Microsoft and Linspire sign collaboration agreement. Ohloh enhances online service for open source contributors. Open-Xchange launches new version of collaboration server. (and more)

Microsoft and Linspire Collaboration Promotes Interoperability and Customer Choice, Micrososft / Linspire (Press Release)

Ohloh Launches New Online Service to Connect People Who Create and Use Open-Source Software, Ohloh (Press Release)

Open-Xchange Gives Feature Boost to Collaboration Server, Open-Xchange (Press Release)

…

I was reading only last week the notes from Wikipedia: Site Internals, Configuration and Code Examples, and Management Issues Tutorial by Domas Mituzas at the recent 2007 MySQL Conference. I didn’t attend this session, like a lot of sessions too much good stuff at the same time.

It’s obviously taken a while to catch up on my reading, but with the present MySQL 12 days of Scale-Out I thought I’ll complete my notes for all to see.

If you have never used Wikipedia well, why are you reading this, you should spend an hour there now. Alexa places Wikipedia in one of the top 10 visited sites on the Internet.

…

I was asked recently to confirm a consistent state of data in a non-transactional MySQL table after a failing statement updating multiple rows did not complete successfully.

Hmmm, this is what I did.

• Created a MEMORY table
• Populated with some data, and a Primary Key
• Updated the Primary Key so that it failed with a Duplicate Key Error after updating only half the rows
• Confirmed that the rows that were updated, were, and the rows that were not updated, were not

DROP TABLE IF EXISTS mem1;
CREATE TABLE mem1(
i1  INT UNSIGNED NOT NULL PRIMARY KEY,
c1 CHAR(10) NOT NULL,
dt TIMESTAMP)
ENGINE=MEMORY;

INSERT INTO mem1(i1,c1) VALUES (1,'a'), (2,'b'), (3,'c'), (4,'d'), (5,'e');
SELECT * FROM mem1;
+----+----+---------------------+
| i1 | c1 | dt                  |
+----+----+---------------------+
|  1 | a  | 2007-06-14 17:26:29 |
|  2 | b  | 2007-06-14 17:26:29 |
|  3 | c  | 2007-06-14 …

Damien Seguy had an interesting observation on my use of self joins for generating rolling sums yesterday:

What about using a user variable to make the rolling sum from the beginning? Something simple enough like this :

set @sum := 159;
// to start with the original number of post, or 0 if you prefer.
set @mn := 0;
// for the month number
select @mn := @mn + 1 as MonthNumber Month, Added, @sum := @sum + Added as RunningTotal from ResultListing1;

Damien, of course, is correct, that I could have used a user variable like the above to generate the rolling sum, instead of using a self join. However, there are some complications. First, let's look at what happens if I rewrite Lenz' original GROUP BY statement to include a user variable to calculate running totals:

Finally! Some MySQL ActionScript drivers. We have a couple choices right now, so bookmark the one you like - asSQL, Asql.

I don’t claim to be a security expert, but I’d like opinions from people in the field, as well as database experts that view security highly. Here are some opinions from a discussion with Chad and Lenz a while ago. What do you consider a security hole, that warrants immediate action or a release of a server within a sensible timeframe?

• Remotely exploiting MySQL without login credentials
• Remotely crashing MySQL without login credentials

The above two are definite problems. What about:

• denial of service attacks
• data loss
• data changes
• data insertion

Chad tells us, “security is policy enforcement.” And the policy should state: “the service should always be available to authorized people, never to …

In the first article in this series on archiving strategies for online transaction processing (OLTP) database servers, I covered some basics: why to archive, and what to consider when gathering requirements for the archived data itself. This article is more technical. I want to help you understand how to choose which rows are archivable, and how to deal with complex data relationships and dependencies. In that context, I'll also discuss a few concrete archiving strategies, their strengths and shortcomings, and how they can satisfy your requirements, especially requirements for data consistency, which as you will see is one of the most difficult problems in archiving.