web stats
Connecting to SQL database cluster - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 02-11-2020, 12:39 PM
dramos70 dramos70 is offline
What's HL7?
 
Join Date: Apr 2019
Location: Boynton Beach, FL
Posts: 1
dramos70 is on a distinguished road
Question Connecting to SQL database cluster

I am running Mirth Connect version 3.4.2.8129.

When our clustered SQL Server database goes down for maintenance, the three node cluster will roll from node 1 to node 2 for example.

Our instance of Mirth Connect fails to automatically connect to the node 2 of the database.

The current workaround that we perform is to stop and start the Mirth Connect service for our application so that it can automatically establish a connection to the next node in the database cluster.

Does anyone have any ideas on how to workaround this issue?

Perhaps something in the conf/mirth.properties file that can be tweaked for the database.url.

Is there anyone in the community who is using a SQL server cluster that does not experience any issues when the database rolls? If so, would you be willing to share your JDBC connection string?
jdbc:sqlserver://sqlcluster_hostname\instancename;DATABASENAME=data basename

I look forward to your replies.
Thank you.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 08:24 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Mirth Corporation