Bitronix and Database clustering
srashmi30 opened this issue · 1 comments
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
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.