A new white paper has just been released on mysql.com at http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_deploy_opencge.php

Open Source Carrier Grade hardware and software stack

Abstract:

Open source technologies and commodity, carrier-grade hardware can combine to create a highly available, scalable and responsive infrastructure to deploy next-generation communications services. This paper examines a solution stack based on integrating Sun GlassFish Communications Server, MySQL Cluster Carrier Grade Edition database, the OpenSolaris operating system, Sun Netra ATCA blades and Sun open storage products into a carrier-grade solution for converged services …

Just a quick introduction to begin with.

I joined Sun Microsystems in Feb 2009 to look after the product management for MySQL Cluster and MySQL replication.

I started my career with Nortel (technically BNR which was the R&D arm of Northern Telecom but everything later got merged and rebranded as Nortel). I was responsible for writing the original proprietary, in-memory database for Nortel’s HLR product. Later on, we used a number of 3rd party databases for the HLR (provisioning rather than real-time) and then HSS - starting with Oracle for the HLR and then SOLID but then settling on MySQL Cluster as the scaleable real-time database for the HSS.

When I left Nortel (via an IBM rebadging) I moved to Sun, hoping to use my experience as a MySQL Cluster customer to help the team build upon their strong product.

So far, so good - I’ve been really impressed both with the MySQL team and with how well the product is …

We've added some new options in MySQL Cluster 6.3.22 which makes it possible to selectively restore tables. The new options for ndb_restore are:

  --include-databases=name 
      Comma separated list of databases to restore.
      Example: db1,db3
  --exclude-databases=name 
      Comma separated list of databases to not restore.
      Example: db1,db3
  --include-tables=name 
      Comma separated list of tables to restore. Table name
      should include database name. Example: db1.t1,db3.t1
  --exclude-tables=name 
      Comma separated list of tables to not restore. Table name
      should include database name. Example: db1.t1,db3.t1

To demonstrate in a few examples, lets assume you have the following tables:

 mysql> SELECT …

Today I gave an introduction talk of MySQL Cluster at FOSDEM 2009 in Brussels. The room was full and I didn't see anyone dozing!
A good feedback later on was to show more usecases. This a good point and I think on working on a talk showing less how it works, but how it can be used. Doing both technical details and use-cases is hard to do in 50 mintes.
I feedback is appriciated!

BTW, slide will eventually come online somewhere..

One year after Sun acquired MySQL we see the positive results of this acquisition. Things are going very well in terms of collaboration, the teams are getting closer together and share the experience and the knowledge. If you want to know how the teamwork is seen from the Sun Cluster engineers, Thorsten Frueauf and myself, you should read this.

It was interesting for us to see that this interview was well observed by MySQL customers and community members. Although the interviews were not technical, they lead to technical questions. You can get more information here.

So if you are keen to see what the MySQL community wants to know about Sun Cluster, read the blog entry about MySQL and Sun Cluster.

Detlef …

One year after Sun acquired MySQL we see the positive results of this acquisition. Things are going very well in terms of collaboration, the teams are getting closer together and share the experience and the knowledge. If you want to know how the teamwork is seen from the Sun Cluster engineers, Thorsten Frueauf and myself, you should read this.

It was interesting for us to see that this interview was well observed by MySQL customers and community members. Although the interviews were not technical, they lead to technical questions. You can get more information here.

So if you are keen to see what the MySQL community wants to know about Sun Cluster, read the blog entry about MySQL and Sun Cluster.

Detlef …

One year after Sun acquired MySQL we see the positive results of this acquisition. Things are going very well in terms of collaboration, the teams are getting closer together and share the experience and the knowledge. If you want to know how the teamwork is seen from the Sun Cluster engineers, Thorsten Frueauf and myself, you should read this.

It was interesting for us to see that this interview was well observed by MySQL customers and community members. Although the interviews were not technical, they lead to technical questions. You can get more information here.

So if you are keen to see what the MySQL community wants to know about Sun Cluster, read the blog entry about MySQL and Sun Cluster.

Detlef …

A while ago we published an interview with Detlef Ulherr and Thorsten Früauf about Solaris Cluster / OpenHA Cluster on the MySQL Developer Zone.

We received a number of followup questions from our readers, requesting more technical background information. For example, Mark Callaghan was wondering about the following:

• How is failure detection done?
• How is promotion of a slave to the master done after failure detection?
• How are other slaves failed to the new master?

I asked Detlef to elaborate some more on the technical details of this solution. Here's his very exhaustive reply, thank you very much, Detlef!

I would also like to point out that he'll be …

Since MySQL Cluster 6.2 it is possible to setup a pool inside the mysqld process opening multiple connections to a MySQL Cluster. This is pretty cool, but it might give troubles when you have to use Single User Mode.
Take for example the following configuration for your SQL Nodes:

[SQL]
Id=10
Hostname= 10.100.9.6
[SQL]
Id=11
Hostname= 10.100.9.6
[SQL]
Id=12
Hostname= 10.100.9.7
[SQL]
Id=13
Hostname= 10.100.9.7

No further slots are defined, and you setup your two MySQL Servers to use connection pooling:

[mysqld]
ndb-cluster-connection-pool = 2

This will result in the following output of SHOW in the ndb_mgm client tool:

[mysqld(API)]   4 node(s)
id=10   @10.100.9.6  (mysql-5.1.30 ndb-6.3.20)
id=11   @10.100.9.6  (mysql-5.1.30 ndb-6.3.20)
id=12   @10.100.9.7 …

We've now concluded our call for papers for the MySQL Developer Room at FOSDEM 2009 in Brussels, Belgium, which will be open on Sunday, 8th of February from 09:00-17:00.

We received some excellent proposals and I am very excited about the schedule. Here's the quick summary of the talks:

• Vladimir Kolesnikov: Practicing DBA's Guide to the PBXT Storage Engine
• Kris Buytaert: Monitoring MySQL
• Geert Vanderkelen: MySQL Cluster
• Roland Bouman: MySQL 5.1 Plugins
• Kaj Arnö: MySQL, powering and using Social Networks
• Ewen Fortune: Percona MySQL patches and the XtraDB storage engine
• Giuseppe Maxia: Boost performance with MySQL 5.1 partitions
• Jurriaan Persyn: Database Sharding

See the …