Note: Installing Oracle 11gR1 on Ubuntu 8.10 Intrepid Ibex is now published.

After many requests from readers, I’ve put together new, revised version of the Oracle 11g on Ubuntu recipe. This new version is a little different than the first one published: it’s based on a bare-bones install of Ubuntu 7.10 (Gutsy Gibbon) server version instead of the desktop version. As an improvement, I’ve tried to pare down dependencies to a minimal set.

Your feedback is more than welcome — it’s the main reason why I wrote a new version of this HOWTO. I’ve also tested and repeated this procedure twice. Even so, it might still have problems, so please let me know so we can improve it …

Jim Starkey, Senior Software Architect at MySQL, is featured in an online interview over at Dr Dobb's Journal. It's a short interview, but every question reveals insight into the Jim's thoughts on the relational model, SQL, security, standards and more. For those who don't know Jim, he is one of the pionneers of the database industry and has implemented several relational databases in his career. Jim has always been an innovator, inventing the widely accepted notion of Blobs (binary large objects) and multi-generational versioning, a key innovation of InterBase. Jim and Ann Harrison joined MySQL from Netfrastructure, the company they... READ MORE

Jim Starkey, Senior Software Architect at MySQL, is featured in an online interview over at Dr Dobb's Journal. It's a short interview, but every question reveals insight into the Jim's thoughts on the relational model, SQL, security, standards and more. For those who don't know Jim, he is one of the pionneers of the database industry and has implemented several relational databases in his career. Jim has always been an innovator, inventing the widely accepted notion of Blobs (binary large objects) and multi-generational versioning, a key innovation of InterBase. Jim and Ann Harrison joined MySQL from Netfrastructure, the company they... READ MORE

Jim Starkey, Senior Software Architect at MySQL, is featured in an online interview over at Dr Dobb's Journal. It's a short interview, but every question reveals insight into the Jim's thoughts on the relational model, SQL, security, standards and more. For those who don't know Jim, he is one of the pionneers of the database industry and has implemented several relational databases in his career. Jim has always been an innovator, inventing the widely accepted notion of Blobs (binary large objects) and multi-generational versioning, a key innovation of InterBase. Jim and Ann Harrison joined MySQL from Netfrastructure, the company they... READ MORE

So, I have been putting it off a lot and I decided to do something about it.
This whole blog is supposed to in one part, describe the steps and progress of my project and write some things about my progress with MySQL (and other databases).
I actually did plan to use stored procedures very much when doing my project so the 2 areas are very much connected to one another.


Main Idea

I wanted to make a web-based text game called Shadow People. Shadow people will be a game to do with government agencies and spy organizations.
There will be two different groups of agencies: Government owned/regulated ones and Terrorists/Freelance ones.
If it helps you imagining how it will look like, if anyone saw the series ?"La Femme Nikita" with the actress Peta Wilson.
The game revolves round the cool and secret world of small yet highly effective organizations that either try to keep order in …

By Jesse Robbins

Jonathan Schwartz is treating NetApp's lawsuit over ZFS as an attack on free software. He posted his position and plan for counter-attack to his blog:

Their objectives were clear - number one, they'd like us to unfree ZFS, to retract it from the free software community. Which reflects a common misconception among proprietary companies - that you can unfree, free. You cannot.

Second, they want us to limit ZFS's allowable field of use to computers - and to forbid its use in storage devices. Which is quizzical to say the least - in our view, computers are storage devices, and vice versa [...] . So that, too, is an impractical solution.

We're left with …

Here is a simple configuration file (XML) for MySQL Administrator client.
In addition to the the default graphs I added some new pages containing the most important status variables to monitoring and evaluate the performance of InnoDB.

The new pages are:
idb storage: reads, writes, doublewrites and fsync activity
idb logs:writes to innodb logs and file system activity
idb buffer pool: buffer pool activity
idb disk: pages and rows activity

Just download the file mysqladmin_health.xml.gz then
gunzip it and copy it in the following (default) directory:
(Windows) C:\Documents and Settings\UserName\Application Data\MySQL
(Linux) ~/.mysqlgui

I hope this could be …

A short time ago I found this very well done podcast: Hanselminutes by Scott Hanselman. In one of the latest episodes he was talking to Jonathan Zuck of ACT Online about Software Licensing. It’s great to get a quick overview about existing licenses and how to best use them. Since this is a huge topic you only get a short overview, but very understandable imho!
Especially interesting was what Jonathan said about the MySQL licensing model, which I had not properly understood all the way until now neither :-). He said since MySQL owns the rights of the software they can decide what license to sell a software under to a customer and

relief them of the burden of a GPL based license, by simply selling it to them …

XAware, Inc., provider of the industry's first comprehensive, real-time open source data integration solution, today announced it has become a Gold Partner in the MySQL Enterprise Connection Alliance program. MySQL AB is the developer of the world's most popular open source database software ? and offers MySQL Enterprise, a premium subscription offering for database developers and DBAs. XAware's data integration solution, XAware 5, is available for download at the community site: www.xaware.org.

This article contains my notes and detailed instructions on setting up a MySQL cluster. After reading it, you should have a good understanding of what a MySQL cluster is capable of, how and why it works, and how to set one of these bad boys up. Note that I'm primarily a developer, with an interest in systems administration but I think that every developer should be able to understand and set up a MySQL cluster, at least to make the dev environment more robust.

Notes

• High availability. If one or some of the machines go down, the cluster will stay up, as long as there is at least one copy of all data still present. The more redundant copies of data there are, the more machines you can afford to lose.
• Scalability. Distributed architecture allows for load balancing. If your MySQL …