search

scalar-labs / btm

JTA Transaction Manager
Apache License 2.0
424 stars 152 forks source link

Bitronix and Database clustering #71

Closed srashmi30 closed 7 years ago

srashmi30 commented 7 years ago

I have the below configuration: Tomcat 8.0.30 as application server BTM:2.1.4 SQL Server 2014 Cluster setup with two Nodes

Does BTM supports database clustering with the above version. If yes, then is there any documentation available for the same. The specific scenario being N1 and N2 are two nodes in the cluster and N1 goes down during transaction, in this case how can we ensure that the application is in consitent state. We also need to do Oracle RAC support with the BTM hence any pointers to the same is highly appriciated

lorban commented 7 years ago

If you're speaking about database clustering, all the functionalities and limitations you get come down from the database / JDBC driver themselves.

It's been years since I last touched a RAC installation running XA transactions but from the top of my memory, in the Oracle 10g days, you couldn't get TAF together with XA (a failing node was just killing all transactions it was processing in a way visible to the application) and you had to explicitly configure a load balancing policy in the driver's connection string. I can't remember having to do anything special in BTM's config.

I would recommend you to get in touch with your database software vendor(s) and check with them what the implications are and what you can expect when you're running XA transactions in a clustered mode.