Enabling fail-over for MS SQL Server databases in JBoss
Issue
Our production SQL Server is set up with Database mirroring (in high safety mode) with automatic failover to mirror database server if principal database server becomes unavailable.
I would like to configure JBoss AS to automatically change database connections to mirror server (prdsql2), when principal database server (prdsql1) goes down.
Is this automatic failover recommended with JBoss AS, if so; please provide info what parameters should be set?
My current datasource file is as below:
<local-tx-datasource>
<jndi-name>myDS</jndi-name>
<connection-url>jdbc:sqlserver://prdsql1.example.com:1433</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
...
</local-tx-datasource>
-
A-MQ Master/Slave with SQL Server Mirroring?
We're looking into setting up A-MQ on two servers as Master/Slave with SQL Server as the message store. Most of what I've read talks about having a single database. However, to give us "high-
availability", we'd like to use SQL Server Mirroring so it's replicated across two database servers - that way, if one of the database servers goes down, everything will carry on working from the other
server.I think what we're wanting to do is basically the "clustered JDBC database" as described on "http://activemq.apache.org/replicated-message-store.html". I haven't found much other documentation
on this, so please can you confirm I've understood it correctly? Are you able to confirm that SQL Server Mirroring is supported for this?
Environment
- JBoss Enterprise Application Platform (EAP) 4.3
- MS SQL Server
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
