This blog has been added to the MySQL developer zone!

You can reach it by going to the MySQL website and clicking Developer Zone -> blogs. This brings you to the Planet MySQL, which now contains this blog.

You can also go there directly by following this link: Planet MySQL

Blog: http://sqlbusrt.blogspot.com/

Project website: http://sqlbusrt.sourceforge.net/

Marc Fleury is giving the opening remarks at today's OSBC London, and is talking about the rise of open source. As Marc said, it's no longer a question of "Why?", but rather of "How?" with regard to open source. Open source is not going away - it's only going to thrive and dominate.

A few interesting points:

1. Debt to IBM. He talked a bit about the debt we owe to IBM for getting open source started with its $1 billion commitment to Linux, but noted that IBM seems conflicted now on that initial support for open source. It has a range of software businesses that compete with open source, rather than leverage it, in his words. True enough. In a company the size of IBM, you never get a single, consistent vision.

2. Bottom-up and top-down phenomenon: the system administrators are driving adoption from the "bottom," whereas CIOs are pushing for adoption …

Larry Ellison, billionaire CEO and founder of Oracle corporation has cancelled his $115 million gift to Harvard University.  Ellison, a college drop out, had pledged the funding to Harvard president Larry Summers in order to establish a global health foundation in his name.  Ellison is estimated by Forbes to be the 15th richest man with assets worth $16 billion. 

In late 2005, as part of an insider trading settlement, Ellison agreed to donate $100 million to a charity of his choice.  He chose his own Ellison Medical Foundation and has contributed $5 million to it, according to an Oracle spokesman.

• LA Times: Oracle's Ellison …

OK, anyone who's done any web development has eventually come across the choices one must make regarding how to handle sessions in your web applications. While there are a variety of methods of handling session interaction, file and cookie-based session management eventually reach a limit in the number of users that can be supported, as well as limitations involving web server farms, load balancing, and state management. To achieve scalability in session management, especially across a web server farm, a database is often used.

Jimmy Guerrero, senior product manager at MySQL, is giving a webinar tomorrow on scaling session management with MySQL Cluster. I, for one, am going to be attending, and I hope to see a number of community folks in the list of participants. It shoud be …

I recently was given a copy of O'Reilly's Baseball Hacks and have really enjoyed digging into a deeper level of understanding baseball. Yes, I watch a fair amount of baseball, but I'm only beginning to understand some of the strategies that come into play during the game (e.g. pitching to a batter or positioning the players on the field).

A few hacks of note:

• Hack #1: Score a Baseball Game - I never knew how scoring a game worked, very usefull to know how the stats are recorded.
• Hack #4: Follow Pitches During the Game - this is a great introduction to learning what goes on as the pitcher faces each batter, the hack also includes ways to identify the various types of pitches and pitch locations.
• Hack #8, 10, 16, 18 20 and many more - use MySQL to import, store, crunch, query and present your baseball data.
• Hack #13: …

So, I've been doing a bunch of coding on MySQL Forge over the last week, and I've added a number of new features to the Forge application. Some of the new features/changes include:

• Ability to add a project, with categories, and tags, in a single step, making it easier than ever to add new projects to the directory
• A whole new interface for tagging projects and code snippets, including the ability to remove existing tags and a review process which attempts to standardize the tags to remove redundancy. (NOTE: You now must be logged in to add tags to a project.
• A new tabbed UI for viewing project and snippet details
• Ability to copy snippet code source directly in the interface (yes, that's for you, Roland Bouman! )
• A project membership approval process. This replaces the flawed contributor implementation I devised before, …

I can not picture what $31 billion dollars means for one individual to have. I've done enough budgets in my life to understand millions of dollars, and I can grasp how entire companies run on billions of dollars, but $31 billion dollars resting with one individual is not something I can easily wrap my brain around. One decision with that much money, spend here, invest there, pull money from this account... can cause thousands of people to shuffle about.

Adding that sort of wealth to one foundation will influence our society in ways that today we can not comprehend. When I look at libraries, I look for the touch of Carnegie. His wealth long endures past his death and the death of the other industrialists of his time, but I believe the Gates Foundation will surpass them all. The social and economic power that this foundation wields is amazing.

I do not have anything in particular to say about the future of the …

The launch of Microsoft's Codeplex "shared source" site is merely the latest attempt to undermine and usurp the open source community via clever marketing.

There are two main reasons proprietary vendors are threatened by open source alternatives: price compression and loss of market share.

Open source companies have a pricing umbrella in relation to proprietary vendors license fees. Proprietary vendors argue that open source alternatives lack features, are less secure, socialist and so on, but fundamentally the difference in features is likely no more than 20%. Open source products are generally 10-30% of the cost of the proprietary competitor. This means you can pay roughly 20% of the cost and receive roughly 80% of the features. This is a very appealing proposition. And the more companies who take advantage of …

When setting up MySQL replication there are some things to remember. Although the setup is quite easy if you thoroughly read the documentation on MySQL's developer site you might still hit some issues.

We have quite a large scale replication setup (MySQL 4.1.12) with several hundred slaves. Today we saw a very strange situation: All of the slaves stopped replicating and claimed that a statement had been partially executed on the master side. The exact message was

Query partially completed on the master (error on master: 1053) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;

The error code 1053 which means as much as "server shutdown".

We checked the master and could not …

Here’s an announcement from the Docs team:

MySQL has provided support for CJK languages (Chinese, Japanese, Korean) for a long time. There’s a chapter in the MySQL Reference Manual that extensively covers MySQL character set support. Managing CJK data can be particularly tricky, though. Therefore we’ve just added a FAQ section that answers the most common questions about handling CJK contents and provides hands-on solutions to common problems. This Frequently-Asked-Questions section comes from the experiences of MySQL’s Support and Development groups, after handling many enquiries about CJK issues. The FAQ is available for the MySQL 5.0 and 5.1 manuals:
- http://dev.mysql.com/doc/refman/5.0/en/cjk-faq.html
- …