A new case study has been published that describes how and why Mapion adopted MySQL Cluster as the real-time, mission critical database for their Mapion Mobile applications.

Mapion adopted MySQL Cluster Databse because it allows for the availability of existing applications through its ’shared-nothing’ distributed architecture with no single point of failure, to meet Mapion’s mission-critical application requirements of 99.999% availability. This is coupled with automatic data partitioning with load balancing, which allows almost unlimited database scalability for the company. Mr. Takashi Ando comments, “Some databases supported clusters when we previously reviewed our database technology, but they were hard to operate and would have increased costs substantially. We found ourselves in a completely different situation when planning the introduction of the new system. MySQL Cluster Database had made it possible to construct a highly …

I would like to hear some opinions from the MySQL worldon what knowledge does it require to be a MySQL Developer?

Not the folks who write the MySQL server code but a developer who really knows their stuff when programming with MySQL? The MySQL 5.0 developer exams going under a review. The hands on exam for 5.1, which has been hindered by other chores, is also under construction. But I still have a fundamental question : What makes someone a MySQL Developer?

The course book from the MySQL for Developers class is very thick and filled with a lot of information. It covers a broad spectrum from basic SQL to query optimization. None of it is programming language specific (or covers approaches like using PDO …

For anyone running any version of Kontrollbase right now I’d highly recommend downloading this release. There are a lot of bug fixes, especially ones that some very nice users have pointed out during the support process – “nandan_it” and “hipparcos” to mention a few.The biggest changes are the Analytics tab that adds about 99% of [...]

Welcome to the 162nd edition of Log Buffer, the weekly review of database blogs.

Oracle

The big news this week came was Oracle’s unveiling the OLTP Oracle Database Machine & Exadata v2, as reported by Alex Gorbachev.

Kevin Closson covered it, of course: Oracle Drops Exadata In Favor of Sun FlashFire Based OLTP Database Machine?, and he and his readers kick it around in a diverting way.

…

This is a “dogfood” type story (see below for explanation of the term)… Open Query has ideas on resilient architecture which it teaches (training) and recommends (consulting, support) to clients and the general public (blog, conferences, user group talks). Like many other businesses, when we first started we set up our infrastructure quickly and on the cheap, and it’s grown since. That’s how things grow naturally, and is as always a trade-off between keeping your business running and developing while also improving infrastructure (business processes and technical).

Quite a few months ago we also started investing (mostly time) in the technical infrastructure, and slowly moving the various systems across to new servers and splitting things up along the way. Around the same time, the main webserver frequently became unresponsive. I’ll spare you the details, we know what the problem was and it was predictable, but since it wasn’t …

Citrix joins the Linux Foundation. BonitaSoft raises $3m. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

# Citrix joined The Linux Foundation.

# Open source BPM vendor BonitaSoft raised $3m from Ventech and Auriga Partners.

# Jaspersoft updated JasperReports Professional with enhanced data visualization.

# US CIO Vivek Kundra outlined the government’s cloud strategy, using NASA’s open source Nebula cloud.

# Infobright …

Recently Mark observed that we now all need a storage engine independent test suite, Sun included! Well, as far as I know, there is such a thing at Sun, sort of. Apparently it has been used to test PBXT and other engines, but I've heard it is not in good enough shape to be released.

But my question is, why not release it anyway? We could turn it into an engine community project. I believe there are enough engine developers out there to get this moving forward.

The secret is to start small, and just get a few tests to run with all engines. Then additional tests can be added step by step. Engines need a way to specify that they want to skip a test entirely (e.g. transactional tests), and it should be easy to customize results for various engines.

An example of a simple and elegant solution can be found in Drizzle. As …

Ever wanted to find a text string in a whole database? Using a nightly build, now you are able to do that, even your whole server can be selected. Just press Ctrl+Shift+F to call the "table tools" dialog.

The maintenance dialog was refactored recently to allow different tabs and actions. Probably you have ideas for further tabs here - please post them in our feature tracker!

I let a couple of these pass by but just thought I'd mention it (just in case any other ex-MySQLer is experiencing anything similar...Why does the MySQL bugs system remove former employees from the historical record?Date: Thu, 17 Sep 2009 20:26:35 +0200From: Bug Database Subject: #29838 [Csd]: myisam corruption using concurrent select ... and updateIn-reply-to: X-Originating-IP: [140.98.193.23]To

Recently I got this question twice. Although SIGNAL was implemented in version 6.0 (which is partially mysql-trunk now) this version is not stable yet, so users still need to use workaround.

Here it is. Create 2 procedures as following:

DROP PROCEDURE IF EXISTS raise_application_error;
DROP PROCEDURE IF EXISTS get_last_custom_error;
DROP TABLE IF EXISTS RAISE_ERROR;

DELIMITER $$
CREATE PROCEDURE raise_application_error(IN CODE INTEGER, IN MESSAGE VARCHAR(255)) SQL SECURITY INVOKER DETERMINISTIC
BEGIN
  CREATE TEMPORARY TABLE IF NOT EXISTS RAISE_ERROR(F1 INT NOT NULL);

  SELECT CODE, MESSAGE INTO @error_code, @error_message;
  INSERT INTO RAISE_ERROR VALUES(NULL);
…