[jboss-dev-forums] [Design of JBoss Collaboration Server] - Re: JBMS Alternate Datastore

[csand101]

Thanks for the reply sappenin.  The latest topology for a MySQL cluster is a synchronous cluster where the mysqld SQL server is sitting on top of a clustered db engine which is spread across many machines.  There is no master or backups.  They are equal.  This means each node can be used rather than just sitting and waiting for another to fail.

So ip takeover is not the answer since wouldn't allow usage of all db nodes.

Loadbalancer would work, yes, but getting too complex for a "simple" email instalation since requires 3 layers of hardware just to store an email.

What makes sense to me, as a simple solution, is that each JBMS server can use a particluar db node.  But then there is the issue as posted of what happens to JBMS when it's db node goes down?  There is still at least one more db running on another ip.  JBMS just needs to start using a different one.

As you mention, if JBMS could manage a pool of connections to different databases in the db farm that would be nice.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3959643#3959643

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3959643