Clustering JBoss and MySQL, support for NDB

[rvdploeg]

I want to create a high avaliable messaging solution using a JBoss Messaging cluster, but now I'm confused:

From the documentation I read that "It is required that all the JBM servers in a given cluster must share the same database".

Suppose, I want a high available clustered messaging environment with MySQL persistency, I could create:
- At least two JBoss Messaging nodes with a shared database.
- A MySQL database with InnoDB tables because this is the only type that is supported.

This would mean that the database is still a single point of failure. Therefore, I could create a MySQL cluster, but in that case I need the NDB-engine, which is not supported (http://wiki.jboss.org/wiki/JBossMessagingDatabaseCompatibilityMatrix)

Pleas tell me that my conclusion "Creating a high available JBM solution is not possible at this moment using a MySQL backend" is not correct!

[mvecera]

Hello,

I'm afraid you are absolutely right. You can only have messaging cluster with MySQL as a single point of failure (supposing InnoDB doesn't support clustering). The best solution for you could be another database engine like PostgreSQL...

[timfox]

That's not correct, ndb *is* supported from JBM 1.4.0.SP3_CP02.

See JIRA http://jira.jboss.org/jira/browse/JBMESSAGING-1261

[mvecera]

Great, I was not aware of this. Sorry for confusion ;-)

[rvdploeg]

No problem, thank you very much!