web stats
Failover to the Mirrored Mirth Database - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 03-14-2017, 09:52 PM
justinMirth justinMirth is offline
What's HL7?
 
Join Date: Mar 2017
Posts: 2
justinMirth is on a distinguished road
Default Failover to the Mirrored Mirth Database

Hi,

Is there a way for the Mirth Connect server to failover to a mirrored Mirth database?

I've tried the following Mirth Database string without success.
In Mirth Connect Server Manager under the Database tab (See Attachment):
URL
jdbc:jtds:sqlserver://PrimaryServer:1433;DatabaseName=mirthdb;failover Partner=MirrorServer:1433

Mirth version 3.4.2.8129
Java ver: 1.8.0_111

Cheers
Attached Images
File Type: jpg MirthCapture.JPG (28.5 KB, 7 views)
Reply With Quote
  #2  
Old 03-15-2017, 06:26 AM
narupley's Avatar
narupley narupley is online now
Mirth Employee
 
Join Date: Oct 2010
Posts: 7,119
narupley is on a distinguished road
Default

I don't know about that specific SQL Server connection URL setting. I do know that our appliances satisfy this. We support PostgreSQL replication and automatic failover with a database virtual IP. But it's something that the appliance does, not Mirth Connect per se.
__________________
Step 1: JAVA CACHE...DID YOU CLEAR ...wait, ding dong the witch is dead?

Nicholas Rupley
Work: 949-237-6069
Always include what Mirth Connect version you're working with. Also include (if applicable) the code you're using and full stacktraces for errors (use CODE tags). Posting your entire channel is helpful as well; make sure to scrub any PHI/passwords first.


- How do I foo?
- You just bar.
Reply With Quote
  #3  
Old 03-15-2017, 08:11 AM
kirbykn2's Avatar
kirbykn2 kirbykn2 is offline
Mirth Guru
 
Join Date: Sep 2014
Location: Michigan
Posts: 570
kirbykn2 is on a distinguished road
Default

Does jtds support the use of "failover Partner=MirrorServer:" in the connection string?
__________________
Kirby

Mirth Certified|Epic Bridges Certified|Cloverleaf Level 2 Certified

Appliance Version 3.11.2
Mirth Connect Version 3.6.1
Java Version 1.6.0_45-b06
Java (64 bit) Version 1.6.0_45-b06
Java 7 (64 bit) Version 1.7.0_151-b15
Java 8 (64 bit) Version 1.8.0_121-b13
PostgreSQL Version 9.6.3
Reply With Quote
  #4  
Old 03-15-2017, 08:18 AM
narupley's Avatar
narupley narupley is online now
Mirth Employee
 
Join Date: Oct 2010
Posts: 7,119
narupley is on a distinguished road
Default

Quote:
Originally Posted by kirbykn2 View Post
Does jtds support the use of "failover Partner=MirrorServer:" in the connection string?
I would guess not. But I'd imagine the official Microsoft driver supports it: https://technet.microsoft.com/en-us/...=sql.105).aspx

You can download their driver here: https://www.microsoft.com/en-us/down....aspx?id=11774
__________________
Step 1: JAVA CACHE...DID YOU CLEAR ...wait, ding dong the witch is dead?

Nicholas Rupley
Work: 949-237-6069
Always include what Mirth Connect version you're working with. Also include (if applicable) the code you're using and full stacktraces for errors (use CODE tags). Posting your entire channel is helpful as well; make sure to scrub any PHI/passwords first.


- How do I foo?
- You just bar.
Reply With Quote
  #5  
Old 03-15-2017, 09:46 AM
siddharth siddharth is offline
Mirth Guru
 
Join Date: Feb 2013
Posts: 832
siddharth is on a distinguished road
Default

FYI

http://www.mirthcorp.com/community/f...highlight=arun
Reply With Quote
  #6  
Old 03-15-2017, 04:43 PM
jack.downes jack.downes is offline
OBX.2 Kenobi
 
Join Date: Apr 2014
Posts: 59
jack.downes is on a distinguished road
Default

Seems like you'd have to build a HA postgresql cluster, and connect to the VIP of that...

https://github.com/smbambling/pgsql_...greSQL-Cluster
Reply With Quote
  #7  
Old 03-15-2017, 05:02 PM
justinMirth justinMirth is offline
What's HL7?
 
Join Date: Mar 2017
Posts: 2
justinMirth is on a distinguished road
Default

Thanks for all the replies.
In regards to using the Microsoft driver, where do I put the code to detect if the Mirror SQL has changed its role to Principal?
The Mirth Connect Server sits on a different server to the SQL servers. If the MirthDB (stores channels, transformers,HL7 messages...) is not reachable, Mirth freezes. I cannot find other sections in the Connect Server Manager to add more code to try a different SQL server with a backup copy of MirthDB.
Please let me know otherwise.
Reply With Quote
Reply

Tags
failover, mirror, sql

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 01:31 AM.


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